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 .Connectio n")
strConn = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & Server.MapPath("db/communi ty.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
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
strConn = "Provider=Microsoft.Jet.OL
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
doler,
Try to check out the link might help in solving the problem...
http://www.iisfaq.com/default.aspx?View=A481
http://www.banmanpro.com/support/odbc.asp
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115
Try to check out the link might help in solving the problem...
http://www.iisfaq.com/default.aspx?View=A481
http://www.banmanpro.com/support/odbc.asp
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115
Hi doler,
Replace this:
strConn = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & Server.MapPath("db/communi ty.mdb")
With this:
strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/communi ty.mdb")
Regards,
Wakie.
Replace this:
strConn = "Provider=Microsoft.Jet.OL
With this:
strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/communi
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 ;)
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 ;)
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.
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?
How are you going to close this question?
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MaxOvrdrv2