By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,888 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,888 IT Pros & Developers. It's quick & easy.

Database connection string

P: 1
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'.

/amg/login.asp, 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.
Jun 18 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.