Hello all
Hoping someone can tell me what I am missing here.
We are running: CF5 NT ACCESS2K
<CFSET myconnection="Driver={Microsoft Access
Driver(*.mdb)};DBQ=test.mdb;defaultdir=H:\inetpub\wwwroot\Test
Sites\database\">
<cfquery name= "q" connectstring= "#myconnection#" dbtype="DYNAMIC">
SELECT DrawingDetails.*
FROM DrawingDetails
WHERE DrawingDetails.ESID=5;
</cfquery>
I get the error:
Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)
[Microsoft][ODBC Driver Manager] Data source '' not found and no default
driver specified
Hint: In order to use ODBC data sources with Cold Fusion you must create the
data source using the Data Sources page of the Cold Fusion Administrator. In
addition, if you are running under Windows NT you must make sure that the
Data Source is created as a System DSN in order for it to be available to
ColdFusion.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (4:1) to (4:68).
Date/Time: 04/03/02 15:31:44
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 137.80.60.254
Thanks for any help
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
