I always use
<CFSET DS = "">
<CFSET DBTYPE = "dynamic">
<CFSET CONNECTSTRING = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=A:\Full\Path\To\The\Database.mdb;UID=Admin;Pwd=;">
----- Original Message -----
From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 10:26 AM
Subject: DSNless query
> 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
