I know it sounds overly simplistic but the only time I've ever received that
error is when I've spelt the datasource name wrong in the actual cfquery tag
itself.....
Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN 13107913
-----Original Message-----
From: Mary Fowler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 1:57 PM
To: CF-Talk
Subject: Windows2000 migration - Datasource Problem
Good evening, me fellow CF'rs.
I have been working all day trying to troubleshoot this and hope that I am
coherent enough to y'all to state the problem I am having correctly.
I am in the process of finishing up a migration to a new machine with
Windows2000 on it. I have datasource connections for Oracle, SQL Server and
DB2. They are in the Windows admin for ODBC under systems DSN, they show up
in Cold Fusion Admin for ODBC and verify, I can call up data from them in CF
Studio and I can access them with MSQuery. The problem is when I try to call
up a couple of the apps I get an error message that says:
Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)
[Microsoft][ODBC Driver Manager] Data source 'FRSDEVNATIVE73_NATIVE' 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.
Data Source = "FRSDEVNATIVE73_NATIVE"
I have checked to make sure the spelling is correct on the DSN. Everything
work fine on the old machine (WINNT 4) Is this a bug with Win2000 and CF
4.5.1? Any suggestions, clues or answers would be greatfully welcomed.
TIA,
:)mary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
