ODBC Connection error in NT4

[369852]

Hi,

I developed the asp pages on Windows 2000. The web server that will hold the files in Windows NT. When i placed the files up on the web server, i get an odbc error saying "there is no data source or default driver". The ODBC connection has been set up and is working. It appears to me that global.asa is not running.

Did anyone ever have this problem??
Thanks for your Help

 

[Dynapen]

What makes you think that the global.asa isn't working. Are you doing your connection strings in a application varialbe built in the global.asa?
The money's gone, the brain is shot.....but the liquor we still got.

 

[369852]

On the default.asp page i put
on error resume next
response.write(Application("Test_ConnectionString&quot)
response.end

where Application("Test_ConnectionString&quotholds the details of the connection and nothing was written to the screen. Which i thought would suggest that global.asa was not run to set the variable???

Yep i Have the application variable in global.asa

Application("Test_ConnectionString&quot = "dsn=Test;uid=Test;pwd=Test"

The error is:
"Data source name not found and no default driver specified"

and occurs at this line

dbtest.Open Application("Test_ConnectionString&quot


Thanks for the help this has me stumped!!