I'm trying to set up a ASP-site, with MySQL database, hosted remotely in DWMX2004. The settings under "Remote server" works fine. But if I use the same settings in "Testing server" I get an error when testing the Database connection:

<b>"Error 404
1. No testing server running on server
2.Testing server specified for this site does not map to..."</b>

This seems logical to me because the MySql server have another IP. But if I use that IP in the FTP host field (Testing server), make a db connection (using Custom connection string) and click on "Test" I get this error:

<b>"An FTP error occurred - cannot make connection to host. The server "212.214.136.77" is not responding. Please check..."</b>

The MySql server is running, can connect to it using MySQL Administrator.

So, the bottom question is: What settings to fill in Testing server? I develop on Mac OSX and I (think) that the web server is Windows.

This info comes from the ISP:

MySql:
IP: 212.214.136.77
Port: 3306
DB-name: *****
User: *****
Password: ****

FTP:
Host: arrownet.nu (IP 212.214.136.35)
User: ********
Passsword: *******
Remote Directory: /clients/arrownet.nu/

The ISP support gave me this code to open a connection to their shared MySQL server:

&lt;% Dim myConn
Set myConn=server.createObject("ADODB.Connection"
myConn.Open("DRIVER={MySQL ODBC 3.51 Driver};Server=[servername];Database=[databasename];UID=[user];PWD=[password];"
Set mrs = myConn.execute("[din SQL sträng]"
Set mrs = Nothing
myConn.close()
%&gt;

Can I copy&Paste that into the file inside the folder "Connection" ("connArrow.asp"?

//Magnus

yes you can paste it in.

try using the IP address of the ftp to connect, that is what i use.

regards

Dave Thomas
<b>DMX Zone Forums Manager</b>
Tip: Use Google or our own Search function to find answers before asking. You'd be surprised what's already written <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>