My site works perfectly on my "localhost/...." however, on my remote server, I get the following error when trying to access my .php pages:

Warning: Access denied for user: 'root@localhost' (Using password: YES) in /usr/local/plesk/apache/vhosts/ttsc.co.uk/httpdocs/hidden/adodb/adodb-mysql.inc.php on line 113

Any ideas?

Cheers (again)

I just replied to this problem on the PHAkT mailing list, but as you posted here I will repeat that answer.

Essentially you need to ensure that you are using the right username and password for your remote connection. This error indicates that one (or both) of these items of information is incorrect.

What you need to do is to click on Modify->Connections and edit your connection, and then double check your connection settings for Remote PHP Connection. Once you have done this, check it all again.

Hope this helps

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

yep the user name and password are correct. However, when I get the error message, it adds "@domain.com" to the user name!

So user name "monkey" in the error message comes up as " ".

Is this right?

Yes that's right. This is the way that MySQL operates. However, if it literally put @domain.com rather than @ttsc.co.uk then this is the source of your problem. This is a sure sign that the MySQL server hasn't been properly configured.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Right then - after playing with the settings and so on, i have reconfigured my remote site and made a new database there from scatch (the original was only small so not a big deal) using phpmyadmin. Alls good so far!

I can now get access, and under the connections tab (I'm using OBDC) when i test it all is OK!

Under daytabindings, my recordset is working and when I test it, I can see the records I've inputted into my database on the remote server! All is good here!

But.....when I try the Live Data view, I'm hit with the following error:

"An error occured while requesting the documant from the app server: No Database Selcted"

Where have I gone wrong?<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Cheers

silly me - forgot to upload the new adodb folder for the new connection! Works like a charm now <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Excellent! Glad to hear you've got it all working now <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>