PHP/MySQL and Visual Basic

berbbrown

We have a web site using PHP and MySQL which enables registered users to update via a Visual Basic client which is downloaded and installed on Windows based PC.

My question is what is the best interface to use for the database connectivity from the VB app to the online MySQL database.

We have tried:

MyODBC
MyOLE/DB

and just downloaded MyVbQL.

Also how easy is it to deploy the above combined with your application?

Anyone out there used the above?

Thanks in advance.

TheIceman5

all depends on wether the webserver will allow connection to mysql from outside the server, most dont that ive come across. if it dont your wasting your time.

berbbrown

Our web server is secure and available from the outside world.

Any recommendations based on my question above?

Doug_G

I've used MyODBC and it basically works, but I ran across a couple strange things when working with MyODBC recordsets in VB. One was that the recordset seemed to think short text data should always be char() even if the db said varchar(), which gave me problems when trying to change the recordset value in code.

This was with MyODBC 3.51 and VB6 in XP, using a RedHat 8 MySQL server on my local network.