CJWSoft Support Info: I get this error

Active Info

Memberlist

Help

Database Connection Issues
CJWSoft Support Info : Database Connection Issues

Info: I get this error - 80004005

Author

Message

<< Prev Info | Next Info >>

RishiK
New User

Joined: May/24/2006
Online Status: Offline
Info: 3

Added: May/24/2006 at 10:48am \| IP Logged

Hi, I purchased ASP Protect last year and instsalled it successfully on a Windows hosted server.

Unfortunately, we had to take the website down. We have reprogrammed our webiste (still in ASP). Before uploading the webiste, I wanted to make sure the stand alone version of ASP Protect was still working. I have followd the installation procedure down to the word but I still can't access the system for the first time.

This is the wrror I ma receiving:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

E:\KUNDEN\HOMEPAGES\30\D94167773\5LEGAL_DOCS\PASSWORD_ADMIN\ ../scripts/populate_config_variables_inc.asp, line 11

The webiste address where I have uploaded ASP Protect to is:

http://www.legaldocs.5legal.com/password_admin/get_me_in.asp

I have been through to your support forums and also looked through the articles you have refereed to for this error. I'm still not having any success and would be most grateful for your assistance.

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729

Added: May/24/2006 at 11:02am \| IP Logged

Hi,

Well, unfortunately there isn't really anything I can say that I haven't covered in fairly large detail in previous posts and articles.

http://support.cjwsoft.com/code/moreinfo520-1.htm

http://support.cjwsoft.com/code/moreinfo136-1.htm

(an article I wrote)
http://www.powerasp.com/content/hintstips/permissions.asp

(more articles)
http://www.aspfaq.com/show.asp?id=2009

http://support.microsoft.com/default.aspx?scid=kb;en-us;3065 18

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115

http://www.macromedia.com/support/ultradev/ts/documents/8004 005_cannot_open_unknown.htm

If you are getting that error its a low level database connection issue. Your not really even getting to any of my ASP code. If you are using a dsn-less connection as you should be... then it is almost always (99%) an incorrect physical path specified or permissions for the database folder... until those things are right you will get random errors like that.

__________________

Best Regards, Christopher Williams www.CJWSoft.com

Guests
Guest Group

Joined: April/06/2004
Online Status: Online
Info: -35

Added: July/06/2006 at 6:23am \| IP Logged

It looks like RishiK is using 1and1 (as I am) and may have done the same "bang me on the head again" thing I did...

In dataconn_inc.asp, for some reason I interpreted the instructions to replace the entire connection line with the results from the server, so I left out ConnectionString =, and ended up with..

"DBQ=e:\kunden\homepages\44\d999999999\mysite\asp7\data\data base\aspprotect_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

After lots of headbanging, I decided to try leaving out DBQ= as follows...

ConnectionString = "e:\kunden\homepages\44\d999999999\mysite\asp7\data\database \aspprotect_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

Then it finally dawned on me that it should be

ConnectionString = "DBQ=e:\kunden\homepages\44\d999999999\mysite\asp7\data\data base\aspprotect_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

Like I said, go ahead, bang me on the head.

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

Printable version

Info Jump

You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area