?
Solved

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

Posted on 2003-02-21
10
Medium Priority
?
269 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:doler
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 10

Expert Comment

by:MaxOvrdrv2
ID: 7995395
can i see the code that connects to the DB?!?

MaxOvrdrv2
0
 
LVL 15

Expert Comment

by:gladxml
ID: 7996321
0
 
LVL 4

Expert Comment

by:Wakie
ID: 7997649
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Expert Comment

by:sandyz
ID: 7997759
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 ;)
0
 

Author Comment

by:doler
ID: 8146025
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.
0
 
LVL 4

Expert Comment

by:Wakie
ID: 8146127
Good to hear, doler.

How are you going to close this question?
0
 

Author Comment

by:doler
ID: 8150390
Don't know. . .
0
 
LVL 4

Expert Comment

by:Wakie
ID: 8150458
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 (http://www.experts-exchange.com/Community_Support/) and provide a link back to this question.

Regards,
Wakie.
0
 

Expert Comment

by:RotaredoM
ID: 8170609
Dear expert(s),

A request has been made to close this Q in CS:
http://www.experts-exchange.com/Community_Support/Q_20556550.html

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

Thank you,

RotaredoM
CS Mod & EE
0
 

Accepted Solution

by:
RotaredoM earned 0 total points
ID: 8189708
No objections has made.

Question PAQed and points refunded.

RotaredoM
CS Mod & EE
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question