MDAC 2.8 Access & ASP

[Wayne]

Hi All,

I have one serious problem...

I have a windows 2000 server, with IIS 5.0, dot net framework 1.1 installed.

I have a few classic asp sites running, which before I updated to MDAC 2.8 were working fine...

After the update of the latest patches and Jet 4.0 stuff, non of the asp sites work any more..

The error I get is Unspecified which occurs right after the connection is opened, but the error I get is "Unspecified ".

This problem is consisted over all servers that I manager on different locations.... this is a fragment of test code that I used to track the problem..

<%
on error resume next
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;Persist Security Info=False"
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

response.Write err.Description & vbCrLF & err.number

%>

Does this have something to do with the dot net framework 1.1 or the upgrade of the MDAC to version 2.8?

Please help, my head is flattening rapidly from banging my head against my screen...

Wayne

[Bob Barrows]

Read this to make sure you are not being bitten by the new security changes in ado 2.8:
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/ado28_securitydcrs.asp[/url]


Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
"Wayne" <nospam_wvaneck@nwgeo.com> wrote in message news:%23TmAgIVrDHA.392@TK2MSFTNGP11.phx.gbl...
Hi All,

I have one serious problem...

I have a windows 2000 server, with IIS 5.0, dot net framework 1.1 installed.

I have a few classic asp sites running, which before I updated to MDAC 2.8 were working fine...

After the update of the latest patches and Jet 4.0 stuff, non of the asp sites work any more..

The error I get is Unspecified which occurs right after the connection is opened, but the error I get is "Unspecified ".

This problem is consisted over all servers that I manager on different locations.... this is a fragment of test code that I used to track the problem..

<%
on error resume next
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;Persist Security Info=False"
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

response.Write err.Description & vbCrLF & err.number

%>

Does this have something to do with the dot net framework 1.1 or the upgrade of the MDAC to version 2.8?

Please help, my head is flattening rapidly from banging my head against my screen...
Wayne

[Wayne]

Hi Bob,

Thank you for your quick reply..

I think it has something to do with the upgrade from the .NET framework 1.0 to 1.1...

I just found a "clean" 2000 server that had the jet 4.0 and all it's updates installed but was still running with .NET framework 1.0

I then tried the sample code and now it is working fine.. I am about to install the .net framework 1.1 on this server to see if it will break the code..

....

I just installed .net framework 1.1 on the test server and guess what .... it works...

So... now what??? is it the order in which the patches are installed that is important?

All the other servers are fully patched.....

I don't know where to look for anymore..

Help...
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message news:%23V3YHYVrDHA.1600@tk2msftngp13.phx.gbl...
Read this to make sure you are not being bitten by the new security changes in ado 2.8:
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/ado28_securitydcrs.asp[/url]


Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
"Wayne" <nospam_wvaneck@nwgeo.com> wrote in message news:%23TmAgIVrDHA.392@TK2MSFTNGP11.phx.gbl...
Hi All,

I have one serious problem...

I have a windows 2000 server, with IIS 5.0, dot net framework 1.1 installed.

I have a few classic asp sites running, which before I updated to MDAC 2.8 were working fine...

After the update of the latest patches and Jet 4.0 stuff, non of the asp sites work any more..

The error I get is Unspecified which occurs right after the connection is opened, but the error I get is "Unspecified ".

This problem is consisted over all servers that I manager on different locations.... this is a fragment of test code that I used to track the problem..

<%
on error resume next
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;Persist Security Info=False"
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

response.Write err.Description & vbCrLF & err.number

%>

Does this have something to do with the dot net framework 1.1 or the upgrade of the MDAC to version 2.8?

Please help, my head is flattening rapidly from banging my head against my screen...
Wayne