I have a curious problem with IIS, ASP and ASP.NET. It
seems once I run an ASPX page on the server and then do an
IIS restart it screws up ADODB in ASP.

I have a simple ASP page "simpleconn.asp" which creates an
ADODB Connection to an Access database. This page executes
fine and creates the connection no problem at all.

I also have an ASPX page which simply does a
response.write which also runs fine. After I have executed
the aspx page everything works until I restart IIS
Services. After doing this the "simpleconn.asp" page no
longer creates a connection and I get an "unspecified
error" returned. Nothing resolves this problem until the
WHOLE server is REBOOTED.

The server is running Windows 2000 Server (SP4) with MDAC
2.7. It has the lastest .NET Framework installed.

I have included the code for the simpleconn.asp page. The
problem occurs when I run any ASPX page on the server or
even access an ASP.NET Webservice ???

Any thoughts or comments would be most appreciated as I
have wasted a great deal of time on this already.

Curiously I cannot replicate the bug on my own machine
running windows 2000 Professional ??

Kind regards
Mark Feather


simpleconn.asp
-----------------

Dim my_conn, strconnString

strConnString = "Provider = Microsoft.Jet.OLEDB.4.0;Data
Source=c:\datamanagementcomp\webtest\dbs\developd. mdb"

set my_Conn = Server.CreateObject("ADODB.Connection")

my_Conn.Open strConnString

if my_conn.Errors.Count > 0 then
Response.write "CONNECTION FAILED " &
my_conn.errors(0).Description
else
Response.write "CONNECTION OPENED"
end if

my_Conn.close

set my_Conn = nothing