classic ASP running on Windows 2008 server

[garethharvey]

we are moving our site to a Windows 2008 server (currently on Windows 2003), I am having problems with session cookies.

Any page that is protected with a session cookie is producing the following error:

An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error.

Any suggestions to what could be the error. All page working fine except for any with session cookies.

[jhardman]

Unfortunately those error messages are the least helpful messages I've seen in a long time. There is no indication what the issue might be. I'm not convinced cookies are the issue at all. Can you remove the cookie code to test?

One thing that might work to show you the real problem is remove all the code and just type "hello world" or some such. Refresh your browser to make sure the server now recognizes the page is error-free. Put your code back in and refresh again. This might fool the server into showing the actual error message instead of the "friendly error message".

Jared

[garethharvey]

I have changed the properties to show the error, it's not a session cookie issue as I anticipated but a database connections issue. It's not allowing me to connect to my database with ODBC connection. Current connection string:


DIM conn
ConnectString = "driver={MySQL ODBC 3.51 Driver};server=" & dbServer & ";uid=" & dbUser & ";pwd=" & dbPassword & ";database=" & dbDatabase & ";option=3;Port=3306;Socket=;Stmt=;"
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open connectstring

[stepterr]

Have you verified that the driver is installed on the new server?

[jhardman]

Many query analizers allow you to test a connection string. That's where I would start.

Jared