I have an Access 2000 database in a directory on a web server (at a hosting company), and I cannot connect (using ASP) to it. The company set up a DSN for me called D10070870-hcc, and sent me the following ASP connection instructions:

Set objConn = Server.CreateObject("ADOBD.Connection"
strConnection = "DSN=D10070870-hcc;"
objConn.Open strConnection

When I try to alter the connection file that Ultradev 4 creates using the above code, Ultradev 4 seems to reject the ASP file, and no longer recognizes the connection. Here is the code that Ultradev 4 writes when I set up a connection to the DSN:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_connHCC1_STRING = "dsn=D10070870-hcc;"
%>

The connection name that I use in Ultradev 4 in this case is called, "connHCC1". The hosting company let me know that in setting up the connection to the DSN, I did not need to specify a user name and password (I tried it that way, it didn't work). After I created the connection called "connHCC1", upload the file it creates (connHCC1.asp) in the "Connections" directory, and tried to create a record set on a new, blank file, I get the following message after I select the connHCC1 connection: "Unable to retrieve tables from this connection. Click on the "Define.." button to test this connection." Then I click "Define", select connHCC1 and test. The result I get is an empty error message.

I am not certain that I have the URL prefix correct in the Application Server set up. A support person at the hosting company let me know that the root directory for the site is at /http/h/o/hollywoodcc.net on the "D" drive of the server. In the Application Server set up of the site, I have the URL prefix expressed (and i've tried it different ways) as /http/h/o/hollywoodcc.net/.

If any of you have any idea as to what the problem could be here, please let me know. Thanks for your help.

Try

D:/h/o/hollywoodcc.net/MyDatabaseDirectory/MyDatabase.mdb

If you use WS_FTP you can see the Remote Site directory structure in the text box at the top right. Navigate to your database at the remote site take off the preceding <b>/</b>, add on your database name and you have the connection string. Don't know about other FTP applications but would imagine they're similar.


Regards

Owen.