Hi,
Complete newbie .
Does this still apply and I am using odbc mysql .....I think.
Also If I change to local host I get
TCX myODBC cant connect to mySQL server on localhost (10061)

If you get an error message during the test that says something like "server connection denies access to data source" or "[TCX][MyODBC]Host'.IP.routername.DSLcompany.net' is not allowed to connect to the MySQL server", you need to talk to your hosting company.

They need to run the following from the MySQL command line using the root user. (note EXACT syntax, with .* and "%"

mysql> grant all privileges on accname_dbname.* to accname_dbuser@"%" identified by 'passwrd';
> Query OK, 0 rows affected (0.16 sec)
>
> mysql> quit

Also If I change to local host I get
TCX myODBC cant connect to mySQL server on localhost (10061)
Thanks in advance
Smiler


<i></i><i></i>

You asked this question on the wrong topic. Try the forum for PHAkt Connections for Dummies....

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>

Hi,
Thanks Where is it??????
Smiler

Try looking for the tutorial 'PHAkT Connections for Dummies' then click on the 'Ask Questions' link at the foot of the page.

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>