Jared Take off the prefix dbo form the table names in your query
Rob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jared Sent: Monday, 19 July 2004 7:18 AM To: CFAussie Mailing List Subject: [cfaussie] SQL TO ACCESS ERROR Hi Guys. I have a search box, which when a product name is entered it retrieves results (3 products across and unlimited number down) The old website was running from SQL server, and I have changed it over to MS Access. When I do the search the following error comes up from the product_results.cfm page. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'c:\WINNT\system32\dbo.mdb'. The error occurred in c:\InetPub\wwwroot\_8\site\product_results.cfm: line 45 43 : <cfquery name="getRanges" datasource="#dsn#" username="#username#" password="#password#"> 44 : SELECT dbo.ranges.* FROM dbo.ranges WHERE dbo.ranges.id 45 : = #getProducts.range_id# </cfquery> <cfset c=IIf(c eq 3,1,c+1)> <cfif c eq 1> 46 : <tr align=center> </cfif> 47 : <td width=1 valign="top" height="66"> ------------------------------------------------------------------------ -------- SQL SELECT dbo.ranges.* FROM dbo.ranges WHERE dbo.ranges.id = 0 DATASOURCE (renamed for posting) VENDORERRORCODE -1811 SQLSTATE HY000 Any help would be appreciated regards Jared --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
