Application DSN and Session DSN
I am moving my website from an NT4 box to a Windows 2000 box. Some of the code uses an application level DSN e.g.
Application("db_ConnectionString") = "DSN=DATAWAREHOUSE;UID=sa;PWD=*******"
I cannot find the DSN entry on the machine using the ODBC screen.
However the pages that use this connection string do work on NT4.
Also there is another connection string with the same DSN name, eg.:
I have found the corresponding DSN entry on the machine for this connection string.
Again the pages that use it work on NT4.
Moving to Win2k, the pages that use the 1st connection string do not work. I have not attempted to put add 2 DSN entries to the ODBC screen with the same DSN name.
Do you have any thoughts on why the two connection strings work in NT4 but not Win2k?
Why the application level connection string works without a corresponding DSN entry on the ODBC screen?
Many thanks in advance.