Accessing mySQL without ODBC, is it possible?

[iliasKBS]

As a new programmer, I am forced to the ODBC & ADO route of abstaining a physical connection with my database. So far it's proven SLOW and unreliable. However, I've seen incredibly lightweight mySQL admin programs connecting to mySQL databases blazingly fast. A first research I've done leads to the usage of "mySQL client libraries" for connection purposes, instead of ODBC. What are they? How can one use them in VB6? Any help will be greatly appreciated!
Thanks in advance…

 

[sleipnir214]

VB6? If VB6 can use c-language code libraries, the MySQL client libraries are bundled with your server software. Look in the MySQL online manual for documentation on the API.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[iliasKBS]

Thanks for your time to see my question...
Well, I am not very familiar with the API in general. The only piece of information I could practically use so far is here:

http://perso.club-internet.fr/ffaure/vb5.html

(look halfway the page, for the libmySQL.dll reference)

I think it's simple this way, however the general object manipulation under this approach remains an undocumented mystery (at least for me!). Do you know any other resources of this type of information?

 

[sleipnir214]

The full documentation of the API is, as I have said, available as part of the MySQL online documentation:

http://www.mysql.com/doc/en/C.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!