Created a access database which works fine locally, got the ISP to setup the ODBC on their server with the same database name. When I upload all the pages, and try and access the database pages I get the following message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
/vacancy.asp, line 8

Now line 8 reads as followings: rs_search.ActiveConnection = MM_BridgeRecruit_STRING

Form what I gather I have to change the way the databse is seen once on the server. the databse is stored in the following path on server \\htdocs\data - this is a Win2000 Server. Done some reading on Server.Map etc but getting a bit confused as when I try to use the DSN tab to connect to the testing server I don't know what path or string to put in the Data source name (DNS) field. Tried using the DSN button to connect to serever but it times out. Have setup the remote server in the site definations and connects fine but not when I try the DNS button. Do I have to manually edit the .asp page to allow the connection to work. Just need to connect to the remote server ODBC database. Am I going about this the wrong way, any help will do.

DW has connection tests for Server/Database <i>Connections</i>, and when setting up your <i>Site Definition</i>. If you click "Test" on any of these and they present a fail, then I would do my best to get them resolved before moving forward.

As for the <b>DNS</b> issue, that could be the issue, I'd <b>set the <i>Testing Server</i> as your host and try the "test" button</b> like that, once it goes fine then continue.

Also, DW creates two folders: a <b>Connections</b> folder, and a "hidden" folder <b>_mmServerScripts</b>, and when you first connect (FTP) to your <i>Remote</i> or <i>Testing Server</i> (defined in DW), then DW automatically will try uploading the "_mmServerScripts" folder. You need to <b>make sure both those folders are uploaded</b>, if you can't tell then try another FTP program to see all files uploaded where DW put them.

Start there, see if anything fixes.

A bit confused with 'set the Testing Server as your host'. I've setup the testing server and remote site in the site options and both connect to ISP server, but when I go to the database in DW and say 'Dreamweaver should connect using DSN on testing server it go to server via ftp and then it cannot find the database - it comes up with error timeout, server might not be running or the ODBC DNS exists on server. The ISP say it is there as they put a test page up and it connects to the database so confused. The Connections and _mmServerScripts folders are there as well.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...when I go to the database in DW and say 'Dreamweaver should connect using DSN on testing server it go to server via ftp and then it cannot find the database - it comes up with error timeout, server might not be running or the ODBC DNS exists on server. The ISP say it is there as they put a test page up and it connects to the database so confused. The Connections and _mmServerScripts folders are there as well.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Did you notify your host that you are using DW MX/MX2004? Did they test with DW or they made a custom page with hand-code of connecting to the database?! There's definitely something slightly wrong with your <i>Connection</i> string, ask your host to provide you with one they would recommend for MS Access.

Just for clarification:
<ul><li>DW MX or MX2004?</li><li>ASP or ASP.NET?</li></ul>

Getting a new error now:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/vacancy.asp, line 8

Asked the ISP if they have added ODBC and told them using DW MX2004, I'll ask them to test using DW or to give me a connection string. The page they used as a test was a hand coded test page. I'll also ask about ASP or ASP.Net, I've put down ASP VB. Whats also now happening I do the ftp tests and they work fine but when I try to upload files it cannot connect.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Asked the ISP if they have added ODBC and told them using DW MX2004, I'll ask them to test using DW or to give me a connection string. The page they used as a test was a hand coded test page. I'll also ask about ASP or ASP.Net, I've put down ASP VB. Whats also now happening I do the ftp tests and they work fine but when I try to upload files it cannot connect.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Ya, if they want your business, then they'll get you that connection string. At the worst is they can download a demo (30-day) of DW MX2004 and see wtf. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

MaximumASP (DMXzone's host) was super helpful like that with me. Also their knowledgebase added DW + ASP/.NET F.A.Q.'s, maybe for all the refered DMXzone members, hehe.

Sorry for long delay in reply, got it all working, removed the dbo. infront of table name and all connecting now.
Also I think they eventually added DSN to server
Cheers