Link to home
Start Free TrialLog in
Avatar of doler
doler

asked on

I get error 80004005 when I try to access the database. . .

I'm trying to learn ASP and I wanted to build a page where you're able to login and log off.
I have a small problem, I get this error when the page is loaded:

Microsoft JET Database Engine error '80004005'

Ogiltig kopplingssekvens som inte kan hanteras av operativsystemet.

(Not valid connection sequnce that can't be handeld be the operationsystem)

/register.asp, row 48

I've tried to translate from Swedish if it's kind of blurry!

I don't really know what to do about this.
I've used Access 97 and I'm running Win98.

The code looks like this:

Set objConn = server.CreateObject("ADODB.Connection")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/community.mdb")
objConn.Open strConn

strSQL = "SELECT userLoginName FROM tblUsers WHERE userLoginName = '" & strLoginName & "'"

Row 48: Set rstUser = objConn.Execute(strSQL)

Tired to look at other forums and of course this but can't find a soulutions that can be too any help.

Would be grat if I could find one here.

/Ola
Avatar of MaxOvrdrv2
MaxOvrdrv2

can i see the code that connects to the DB?!?

MaxOvrdrv2
Hi doler,

Replace this:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/community.mdb")

With this:
strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/community.mdb")

Regards,
Wakie.
80004005 is an all to common error.  Afraid you will see it a lot with Access.

Pretty sure that the directory with the *.mdb file has to be readable, writeable and executable.  

Put it in your /cgi-bin but could be a different location depending on your hosting company configuration.  Ask them to be sure.

sandyz
wants points ;)
Avatar of doler

ASKER

Found what was wrong. . .

It really wasn't that hard. Just a stupid misstake!

I hadn't installed the SQL-support to MS-Access. Therefor i got the error.
Good to hear, doler.

How are you going to close this question?
Avatar of doler

ASKER

Don't know. . .
My advice would be to select an answer above if it assisted in solving your problem.

If none of the proposed answers helped, you can request to a refund of your points at Community Support (https://www.experts-exchange.com/Community_Support/) and provide a link back to this question.

Regards,
Wakie.
Dear expert(s),

A request has been made to close this Q in CS:
https://www.experts-exchange.com/questions/20556550/Answerd-my-own-question.html

Without a response in 72 hrs, a moderator will finalize this question by:
22 Mar 2003

Thank you,

RotaredoM
CS Mod & EE
ASKER CERTIFIED SOLUTION
Avatar of RotaredoM
RotaredoM

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial