Active Server Pages error 'ASP 0241'

We are having the same issue after installing Windows Server 2003 SP2 and the latest myODBC driver could I ask if this is error is happening after SP2 was installed on the server?

Also to try and fix the issue in the database_connection.asp file change:-

Server.CreateObject

To:-

CreateObject

removing the Server. part.


Edited by -boRg- - 04 April 2007 at 9:37am

Have found a solution to the issue by removing the latest myODBC 3.51.14 driver and installing the older myODBC 3.15.12 driver. It seems to fix the issue when using Win2k3 SP2, at least it does for us.

Also if you remove the Server. part from:-

Set adoCon = Server.CreateObject("ADODB.Connection")

To leave:-

Set adoCon = CreateObject("ADODB.Connection")

It will also help resolve the issue, the Server. part is not required in IIS5+ but was left in for compatibility with IIS 4 which some users are still using.

However, I would recommend using the older myODBC driver as anyone running the older Server. code with myODBC on the server will bring down the entire application pool for all sites that it serves.

Thanks for the tip on the Session_OnEnd with ASP, I was wondering why the active users at the bottom of this page was not decreasing.

Edited by -boRg- - 05 April 2007 at 11:57am

hi -boRg-,

did you mean "myODBC 3.51.12"?
I can't find information about 3.15.12 and I can't find a site for downloading 3.51.12.

Thx








Edited by milchman - 30 October 2007 at 11:13pm