Here is the error I am getting:
ODBC Error Code = IM002 (Data source not found and no default driver specified)
[Microsoft][ODBC Driver Manager] Data source 'POLICY' 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 (1:1) to (4:1).
______
I am running WinNT server 4.0 with IIS 4.0. I just had to rebuild and reinstall ColdFusion and this was working before. Going in to CF Admin page and the odbc sources my databases (the one giving the error and the one that is accessed after this file) are the only 2 databases there and both can be verified. I then went in to NT Server Control Panel~ODBC~System DSN. Both files are there that I added through the CF admin page. I did notice however the User DSN Tab only has Foxpro Charts and Foxpro Tables in it.. Went to add in a MSAccess in to it but it wants a file .. the user dsn shouldn't need the file where the system dsn should and does.. perhaps I'm wrong? The directory structure is the same. The Access databases are version 7.0 CF Enterprise Server version 4.5.
Thanks!
Brandon [sig][/sig]
ODBC Error Code = IM002 (Data source not found and no default driver specified)
[Microsoft][ODBC Driver Manager] Data source 'POLICY' 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 (1:1) to (4:1).
______
I am running WinNT server 4.0 with IIS 4.0. I just had to rebuild and reinstall ColdFusion and this was working before. Going in to CF Admin page and the odbc sources my databases (the one giving the error and the one that is accessed after this file) are the only 2 databases there and both can be verified. I then went in to NT Server Control Panel~ODBC~System DSN. Both files are there that I added through the CF admin page. I did notice however the User DSN Tab only has Foxpro Charts and Foxpro Tables in it.. Went to add in a MSAccess in to it but it wants a file .. the user dsn shouldn't need the file where the system dsn should and does.. perhaps I'm wrong? The directory structure is the same. The Access databases are version 7.0 CF Enterprise Server version 4.5.
Thanks!
Brandon [sig][/sig]