Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Connection String
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Connection String

 Post Reply Post Reply
Author
topping View Drop Down
Newbie
Newbie


Joined: 18 June 2007
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote topping Quote  Post ReplyReply Direct Link To This Post Topic: Connection String
    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



Edited by topping - 18 June 2007 at 7:32pm
Back to Top
KCWebMonkey View Drop Down
Senior Member
Senior Member
Avatar
Go Chiefs!

Joined: 21 June 2002
Status: Offline
Points: 1319
Post Options Post Options   Thanks (0) Thanks(0)   Quote KCWebMonkey Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
topping View Drop Down
Newbie
Newbie


Joined: 18 June 2007
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote topping Quote  Post ReplyReply Direct Link To This Post Posted: 19 June 2007 at 5:55pm
How do I do That? Pls help
Back to Top
KCWebMonkey View Drop Down
Senior Member
Senior Member
Avatar
Go Chiefs!

Joined: 21 June 2002
Status: Offline
Points: 1319
Post Options Post Options   Thanks (0) Thanks(0)   Quote KCWebMonkey Quote  Post ReplyReply Direct Link To This Post 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")


Edited by KCWebMonkey - 19 June 2007 at 6:31pm
Back to Top
topping View Drop Down
Newbie
Newbie


Joined: 18 June 2007
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote topping Quote  Post ReplyReply Direct Link To This Post 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.
 
Back to Top
KCWebMonkey View Drop Down
Senior Member
Senior Member
Avatar
Go Chiefs!

Joined: 21 June 2002
Status: Offline
Points: 1319
Post Options Post Options   Thanks (0) Thanks(0)   Quote KCWebMonkey Quote  Post ReplyReply Direct Link To This Post 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?


Edited by KCWebMonkey - 19 June 2007 at 9:45pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.