Page 1 of 1
Connection To MySQL
Posted: Sat Jan 21, 2006 4:41 pm
by jcoleuk
How can I use PureB to connect to a local MySQL database on my Windows machine.
Thanks,
Josh.
Posted: Sat Jan 21, 2006 5:08 pm
by josku_x
Do you have MySQL and PHP installed on your machine?
And if yes, which versions?
Posted: Sat Jan 21, 2006 5:09 pm
by Flype
hello, i made this daily. it's quite easy.
1/ Download on the mysql website the 'ODBC MySQL Connector for Windows 2000/XP', and install it.
2/ Be sure you have opened the MySQL TCP Port 3306 on your firewall(s).
3/ Execute the native configuration ODBC software 'odbcad32.exe' provided by Windows.
4/ Create a new system file, specifying a connection name, user, pwd, ...
5/ Use OpenDatabase(0,'odbcname','odbcuser','odbcpwd').
Posted: Sat Jan 28, 2006 12:16 pm
by jcoleuk
Thanks for the reply.
I'm still having problems, I tried to add an SQL server connection to the ODBC config software but it won't connect to the MySQL server...
I disabled my firewall and still it wouldn't work, it doesn't show up in the Select Server menu so I just put in "(local)" like the help file says.
I really need some help with this.
Thanks,
Josh.