Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ASP, Access & Link Table Password

Reply
Thread Tools

ASP, Access & Link Table Password

 
 
Colin Steadman
Guest
Posts: n/a
 
      01-20-2005
I've written an online survey in ASP using Access as the
db. To get the results and some data about the user I've
written a simple select query in Access and saved it
as 'QRY_GET_RESULTS'. 'QRY_GET_RESULTS' uses two tables:-
TBL_RESULTS (Access) and TBL_DIRECTORY (link table to our
directory server). The QRY_GET_RESULTS query works great
in Access when I've supplied the directory server password.

And it should mean that I can connect to the Access db
from ASP and run 'select * from QRY_GET_RESULTS'. However
when I do this I get the following error:

Microsoft JET Database Engine error '80004005'

ODBC--connection to 'directory_db' failed.

/isebsurvey/dev/view_results.asp, line 32


Line 32 is:

rs.Open Join(arSQL, " "),cn


I think this is happening because I need to also supply
the directory server password in the connection string,
but I'm not sure how to go about this. At the moment it
looks like this:

"Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("survey.mdb")

Could anyone tell me what I'm missing?

Thanks,

Colin


 
Reply With Quote
 
 
 
 
Bullschmidt
Guest
Posts: n/a
 
      01-26-2005
Perhaps this will give you some ideas:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change a users password without knowing the old password nor the answer to the password question AAaron123 ASP .Net 1 01-16-2009 02:56 PM
Changing a users password without knowing the old password nor the answer to the password question AAaron123 ASP .Net 2 01-16-2009 02:08 PM
RE: Link Link Link =?Utf-8?B?REw=?= Windows 64bit 0 05-17-2005 12:15 PM
Re: Link Link Link DANGER WILL ROBINSON!!! Kevin Spencer ASP .Net 0 05-17-2005 10:41 AM
add hyber link to table or table cell web control Symphony ASP .Net Web Controls 1 03-16-2005 12:30 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57