Classic ASP Discussion - Connection String

Print Page | Close Window

Connection String

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23555
Printed Date: 29 March 2026 at 10:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Connection String

Posted By: topping
Subject: Connection String
Date Posted: 18 June 2007 at 7:29pm

Hello All,

I need some help with my dsn less connection string. I am using Dreamweaver MX 2004, using Access db and I have a testing server on my local machine. I am using ASP pages. I was able to set up my site and I could test it with no problems locally, however when I upload the site to my web hosting server which is a windows platform I get errors connecting to my database. This is the error I get when I log in to my site:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x468c Thread 0x1f48 DBC 0x1676fc4 Jet'.

line 15

And this is where the error refers to:

MM_rsUser.ActiveConnection = MM_amgcard_STRING

I am new with programming and I mainly used the graphical user interface. This is the connection string I used:

' FileName="Connection_ado_conn_string.htm"

' Type="ADO"

' DesigntimeType="ADO"

' HTTP="true"

' Catalog=""

' Schema=""

Dim MM_amgcard_STRING

MM_amgcard_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ= c:\Inetpub\wwwroot\amg\connections\amg.mdb"

Please help.

Thanks

Replies:

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 3:28pm

did you change the path to your database after you uploaded it? 99% of the time the path is different.

Posted By: topping
Date Posted: 19 June 2007 at 5:55pm

How do I do That? Pls help

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 6:31pm

change this path

c:\Inetpub\wwwroot\amg\connections\amg.mdb

to whatever the path is on the server to your MDB file. You can either use an absolute path like you have currently, or you can use a relative path by changing the code something similar to this:

MM_amgcard_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/mydirectory/mydatabase.mdb")

Posted By: topping
Date Posted: 19 June 2007 at 8:40pm

Thanks for your quick response, however after I did what you recommended I still got this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x4458 Thread 0x645c DBC 0x167f2d4 Jet'.

This points to this line:

MM_rsUser.ActiveConnection = MM_amgcard_STRING

Please help and once again thanks for your efforts.

Posted By: KCWebMonkey
Date Posted: 19 June 2007 at 9:45pm

are you sure the path is correct to your database? the example i provided above using Server.MapPath starts at the root of the website. for example, if your database is located at "mysite.com/myfolder/database.mdb" then your path should be:

Server.MapPath("/myfolder/database.mdb")

is that how you have it coded?

Posted By: WebWiz-Bruce
Date Posted: 20 June 2007 at 8:26am

You can also get this error if you use Access 97, as there are compatbility problems with newer drivers and OS's.

If you are using Access 97 upgrade it to at least Access 2000

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting