new2codecharge
|
| Posted: 08/08/2002, 11:00 AM |
|
Hi,
I have been trying to get a simple codecharge project up and going using PHP4 and MySQL (18 days on the trial...), with the destination of an Apache 1.3.x server on a Linux Machine.
I have been unable to establish a connection with the MySQL databases on the Linux machine through codecharge, and thus am stuck. I can connect to MySQL throgh admin tools such as Mascon, so I'm sure it is working. I have read that MyOBDC is necessary from other threads, but the setup is fuzzy. Do I need to install MyOBDC on both my 2000 workstation with codecharge, just the linux machine?? what are good "default" config options? where are the default config files? Debugging? etc.
Thanks for any help
|
|
|
 |
kburnett
|
| Posted: 08/08/2002, 12:04 PM |
|
you need to do the following:
1) on the linux machine you need to create a mysql user that has access to the tables you desire. this user needs to have access from any machine so use the %.
eg. on the mysql command line type ... grant all privilives on yourdb.* to someuser identified by "somepassword";
or you can do the same with mascon manually.
2) go back to your 2000 machine and download the mysql odbc driver from http://www.mysql.com/downloads/api-myodbc-2.50.html
3) install the myodbc driver
4) in code charge create a project. and for the connection use an odbc connection. you will need to click "new" and create an odbc connection using the mysql driver, the username and password you setup in mysql, and the location of the mysql db be it an ip or domain name. when creating this connection it will tell you if it was successful. if not, verify all the info entered and try again.
5) also on the code charge connection you will need to add info about your db. but you will see what needs to go where.
hope that helps.
|
|
|
|
SQL
|
| Posted: 12/18/2002, 10:33 PM |
|
There has been a recent bug with MySQL that it does not allow remote connection access. This relates to a recent upgrade to the glibc library. I have not heard as of yet if there is a bug fix for this. This may be what is causing the problem.
|
|
|
|
|
