Forums
This topic is locked
Connection String problem
Posted 06 Jul 2005 18:22:58
1
has voted
06 Jul 2005 18:22:58 Javier Castro posted:
A new problem, how original, right?I used to be able to connect to the host server with no problem using the "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\user_name\database\database_name.mdb;"
However, a few days ago it just did not want to connect anymore. It takes a long time to test connection and shows a server timeout error. I know the server is running, I know the connection script is right. Also, I called tech support because I noticed that all the db driven pages on my website were not viewable. The browser showed attemps to open the page but nothing was happening. Did anyone experience something like this? Any ideas as to why this would happen. I'm using Dreamweaver MX 2004 and have an Access DB on the back end.
Replies
Replied 09 Jul 2005 00:39:01
09 Jul 2005 00:39:01 paul durbar replied:
Think its definitely your hosting providers tech supports' problem. If a script like that suddenly stops working then it points to a server issue. As a test, try temporarily using the Microsoft Access driver instead to see if the problem goes away (change you connection string to:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\user_name\database\database_name.mdb;Uid=;Pwd="
If this works, it points to an error with the Jet driver on the server. If it is a server issue then it'll resolve itself as you wont be the only one complaining if its on a shared host box.
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\user_name\database\database_name.mdb;Uid=;Pwd="
If this works, it points to an error with the Jet driver on the server. If it is a server issue then it'll resolve itself as you wont be the only one complaining if its on a shared host box.