I am using the ODBC object so I can connect to a MySQL database and send registration information a user enters to the database. I am having problems getting the ODBC object to connect to the MySQL database server. Any suggestion?
Printable View
I am using the ODBC object so I can connect to a MySQL database and send registration information a user enters to the database. I am having problems getting the ODBC object to connect to the MySQL database server. Any suggestion?
I am using the ODBC object so I can connect to a MySQL database and send registration information a user enters to the database. I am having problems getting the ODBC object to connect to the MySQL database server. Any suggestion?
Is this a mySQL on a web server?
Does your server allow remote connections to the mySQL database?
Most (99%) of web server hosts don't so you would need to ask them.
Having an a mySQL set up to allow remote connections opens up the server to security issues.
Most just allow "localhost" connections which means in MMF you would need to use a socket extension (like MOOSock) and communicate with the database thru a PHP (or other) script.
The V-Cade uses PHP and MOOSock to get data in and out of a mySQL and it works and after the extra step of parsing out the headers on what is sent back its a snap. You can sign up and the V-Cade and get an example file of how they do it.
Or you can search our old forums -- I know we went over this in depth many times.
Perhaps I will write a new "Getting the most of" article on this since its a common question.
Is this a mySQL on a web server?
Does your server allow remote connections to the mySQL database?
Most (99%) of web server hosts don't so you would need to ask them.
Having an a mySQL set up to allow remote connections opens up the server to security issues.
Most just allow "localhost" connections which means in MMF you would need to use a socket extension (like MOOSock) and communicate with the database thru a PHP (or other) script.
The V-Cade uses PHP and MOOSock to get data in and out of a mySQL and it works and after the extra step of parsing out the headers on what is sent back its a snap. You can sign up and the V-Cade and get an example file of how they do it.
Or you can search our old forums -- I know we went over this in depth many times.
Perhaps I will write a new "Getting the most of" article on this since its a common question.
[]Perhaps I will write a new "Getting the most of" article on this since its a common question.[/]
Yes please, Jeff!
[]Perhaps I will write a new "Getting the most of" article on this since its a common question.[/]
Yes please, Jeff!
Could you give me a link to any example files?
Could you give me a link to any example files?
Something quick I found on our old forum
www.clickteam.com/CTforum/showthreaded.php3?Cat=&Board=upload&Number =294334&Search=true&Forum=upload&Words =mysql&Match=Or&Searchpage=0&Limit=25& amp;Old=allposts&Main=294334
Something quick I found on our old forum
www.clickteam.com/CTforum/showthreaded.php3?Cat=&Board=upload&Number =294334&Search=true&Forum=upload&Words =mysql&Match=Or&Searchpage=0&Limit=25& amp;Old=allposts&Main=294334