Help with

[bigfoot]

I just set up a new server with Windows 2000 Server and IIS.

I set up the same configuration as in my NT server (ODBC), and when I try to read an access database, the page comes back with:

Error Type:
Provider (0x80004005)
Unspecified error
/arett/Arett2000/Enhancements.asp, line 21

Line 21 is this:
oRec.Open szSQL, szConn, adOpenStatic

Here's my code:
szConn = "DSN=WEBServ"
UserName=Request.Servervariables("AUTH_USER&quot

sSQL = "Select SERIAL, FNAME, LNAME From Users WHERE USERNAME = '" & UserName & "'"

Set oRec = Server.CreateObject("ADODB.Recordset&quot
oRec.Open sSQL, szConn, 3

If Not oRec.EOF then
Session("UserName&quot = UserName
Session("Serial&quot = oRec(0)
Session("FirstName&quot = oRec(1)
Session("LastName&quot = oRec(2)
Else
Session("UserName&quot = UserName
Session("FirstName&quot = ""
Session("LastName&quot = ""
Session("Serial&quot = ""
End If

oRec.Close
Set oRec = Nothing

This works ok on my NT 4 box, and I gave Everyone full permissions to the database.

Help

 

[link9]

Have you installed all the latest data access stuff on your computer? Just head over to

http://windowsupdate.microsoft.com

, download all the "critical updates" for your machine, and see if the error goes away.

with a little searching on support.microsoft.com, it seems as if this error comes from several different places, and everyone seems to think that getting the latest updates for your server should clear it up.

hope it helps
paul

 

[bigfoot]

It's a Windows 2000 Server machine. MS sez it should work out of the box. And I loaded mdac 2.6 on it too.

 

[bigfoot]

I rebooted the machine and it started working.????

This makes me worry.

It will not read one page but It'll read another.

This makes me REALLY worry.