Replies Back to Article
PHAkt Connections for Dummies
Could you provide more information connection on SQL 7.0!
jack
PHPwebhosting.com is a great host and was willing to allow remote access through UltraDev.
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
Followed these instructions and it all work. Apart from The Define Connection it never updated. I've made Five connections all various types and can't see any of them, when I come to select a conncetion, the is nothing there even though it told me that connection was successful, it just continusly ask me to define a connection. I'm on the brink of throwing this damn machine out the window. Somebody please help. I've installed adodb and have tried to install phpMyAdmin but can't because of the define connection fault.
Thanks
Dennis
Hello,
having installed phakt, when I perform database connection setup i get returned the messages:
"Cannot find file c:\program files\macromedia\dreamweaver ultradev 4\configuration\connections\php\win\connection_php_mysql.htm."
"Cannot find file c:\program files\macromedia\dreamweaver ultradev 4\configuration\connections\php\win\connection_php_adodb.htm."
Clicking ok bypasses this. When i try to do anything which is remotely database orientated I get returned errors. The following is the error i receive when creating a recordset:
"the server behaviour panel cannot determine whether "<server behaviour>" or "<server behaviour>_PHAKt" is applied to your page. Please select Edit Server Behaviours and change one of the two behaviours to ensure that each is uniquely identifiable."
Please help.