Hosting that doesn't allow remote database connections

[johngordon12]

I'm currently just trying to connect to a database I've created on a GoDaddy hosting account, but am getting an error message in DW :

Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect) comment function.

I've been rummaging around their site / forums and the net to figure it out, and as far as I can tell Go Daddy hosting does not support remote database connections.

In which case I'd be a bit clueless as to how to go about the usual thing of creating recordsets etc in DW.

Would that still be possible somehow, or might the best plan of action be to advise my client to change hosting company?

Thanks for any advice on this.

[bregent]

I believe DW uses a server side script in a hidden folder (hidden in DW) to connect to the database and return results.

So it isn't really a remote connection. Have you verified that the necessary DW scripts have been uploaded to the server?

[Guest]

you most certainly can connect remotely to your godaddy database. For testing pourposes it's recommended to use a testing server and local database though. Without providing a step by step of your remote databse connection steps and/or a sample of your connection script (ommiting your credentials, or course) it's difficult to provide a solution.

[johngordon12]

Thanks guys.

After further investigation I established that you could connect, but that you had to specify to Allow Direct Database Access when you create a database.

I tried creating a new database in case I'd missed that, but didn't see any option to do so.

Then I figured out that you have to have something called IIS7 rather than IIS6 before you can do that. So its currently upgrading to this IIS7, which can take up to 24 hours.

Basically, I'm just used to creating the connection in DW, ie Database > Add mySQL connection and entering the mySQL server, username and password in the dialogue box.

[johngordon12]

Just to say that upgrading to IIS7 resolved the issue.