Web based MySQL Question?

[Dave Lewis]

Hi All,

Can someone point me in the right direction?

I have a web site which uses a MySQL database to store items for sale,
client information and credit card info etc (or will be soon). I'm
currently looking at building a back-end website to control all this
information, what I was wondering is their a recognised way of connecting to
a web based MySQL database using VB6 and if so how securely can that
connection be made, at the moment I'm using an SSL connection, but this of
course is still not that secure, anyone finding the address will then need
to work out the username and password, but potentially will be able to gain
access, if I could use VB then they would need to get hold of the exe in
order to gain access, and my knowledge of VB6 is higher that my knowledge of
PHP.

Any help much appreciated

Regards

Dave L

[Bill Karwin]

Dave Lewis wrote:

is their a recognised way of connecting to
a web based MySQL database using VB6
Probably ODBC is your best choice. See the MyODBC product on dev.mysql.com.
and if so how securely can that connection be made

That's a tricky subject. Tips you get from newsgroup users should not
be mistaken for a thorough security plan. It's kind of like trusting
legal advice from people on the net. If you need very strong security,
you should consult an expert.

Here are a couple of articles to get you started:
http://dev.mysql.com/doc/mysql/en/mysql-connectors.html
http://dev.mysql.com/doc/mysql/en/windows-and-ssh.html
http://www.nwfusion.com/columnists/2...4internet.html

Regards,
Bill K.