PHP mysql remote testing server nightmare

[Tw|chie]

Hi,

I am having trouble setting up a mysql connection using dreamweaver mx 2004 on
a win2k machine. The database is hosted remotely and was setup using the
phpadmin gui available from my web host.
[url]http://secure.resellerspanel.com/login/login.html][/url].
My site definition setup is correct because I can upload files to my hosting
provider without any problems. I know php is functioning properly because I
have checked with the phpinfo() and it comes back with the correct information.
Using the database connection utility in dreamweaver with the correct sql
server information, username, password, I tried selecting a database,
dreamweaver connects to my hosting provider successfully, tests the database
connection, but comes back with error message: "unindentified error message
occurred".
I have tried searching the internet for some answers, however all sem to
tackle the problem from a local point of view and talk about having the correct
version of php and mysql installed, but i'm using a remote host with it all
setup.

Any help would be much appreciated, many thanks in advance
A very frustrated Tw|tchie:confused;

[David Powers]

Tw|chie wrote:

> I am having trouble setting up a mysql connection using dreamweaver mx 2004 on
> a win2k machine. The database is hosted remotely and was setup using the
> phpadmin gui available from my web host.

The first question would be to ask your host if it permits remote access
to MySQL databases. Most of them don't, for security reasons.

I believe Dreamweaver has some method of getting around this
restriction, but I've never tested it myself. Because using a remote
host as a testing server is much slower, I've always recommended
creating a local testing environment.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[Tw|chie]

Hi, David,

Thanks for your quick reply.

I thought of asking my host just after I posted this and your right, they do
not allow access for security reasons.
I am very interested in knowing how to get round the restriction, as I have a
4mb broadband connection my upload speeds are very reasonable.

regards

Richard

[David Powers]

Tw|chie wrote:

> I thought of asking my host just after I posted this and your right, they do
> not allow access for security reasons.
> I am very interested in knowing how to get round the restriction, as I have a
> 4mb broadband connection my upload speeds are very reasonable.

You may find this article of help:

[url]http://www.dreamweavermxsupport.com/index.php?type=article&id=85&block=1&pid=60&sid=61[/url]

It was written for Dreamweaver MX, but it may still be relevant. It was
written by Gareth Downes-Powell, who is very knowledgeable and reliable
(he also hangs around here from time to time).

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[Tw|chie]

Brilliant, the article resolved the problem!! :))))

Thanks very much for finding it for me and thanks to Gareth Downes-Powell for writing it.

[David Powers]

Tw|chie wrote:

> Brilliant, the article resolved the problem!! :))))
>
> Thanks very much for finding it for me and thanks to Gareth Downes-Powell for writing it.

Thanks for letting me know it worked. I must experiment with some time.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]