External MySQL connection w/ ODBC?

[Anon]

An associate and I are currently developing a two part website product for certain specific businesses. We have written the website shell (in PHP4), and are working on a client at the moment. The client is being written in VB. However, we are having GREAT difficulty persuading MySQL to allow us to connect externally using ODBC.

Anyone got a clue?

Cheers,

RM.

[ace21]

I had the same problem but was unable to come up with a solution if there is one. I tried to write to Access on a different harddrive on the same computer as the script and could not get that to work. It seems that there is some security feature built into ODBC that has to be overcome.

Ace21

[Anon]

Hello,

Have you follow this link:
<a href="http://www.mysql.com/doc/M/y/MyODBC_clients.html">http://www.mysql.com/doc/M/y/MyODBC_clients.html</a>

BR
Philippe

[Anon]

No, what I mean is that the MySQL database is running on a remote host (i.e. a web server). What I want to do is have my VB client store all the transactions for the day, then update the MySQL database on the web-server. I can't persuade the client application to connect to the database though - more specifically, I can't persuade the database to accept a connection that originates outside the host machine. The only solution I have thought of consists of making my application write a custom php4 script, upload it to the webserver, and execute it. Which is pants.

Anyone else?

RM.