Advice with odbc alternatives

[bobrivers2003]

I have made a little application on mylaptop (that I have full write access to) that connect to a database and prints a couple of lines from a sql database.
...
Dim cnMySql As New rdoConnection
Dim rdoQry As New rdoQuery
Dim rdoRS As rdoResultset

' set up remote data connection using the
' MySQL ODBC driver

cnMySql.CursorDriver = rdUseOdbc
cnMySql.Connect = "uid=root;pwd=monkey;server=localhost;" & _
"driver={MySQL ODBC 3.51 Driver};database=test;dsn='';"
cnMySql.EstablishConnection
...

It works a treat because I have installed ODBC on my laptop.

I have then attempted to run the same application on a work desktop and will not work because ODBC is not installed and I do not have admin rights to do so.

i am stuck. Are there alternatives to connecting vb to MySQL without using ODBC?

I am a novice with vb. I have looked through previous thread but because I don't know what I am looking for I can't find anything!


Any Help would be greatly appreciated.

 

[BobRodes]

Look into using ADO objects. They are more up to date technology than ODBC using RDO.

 

[dilettante]

It isn't an issue of having ODBC installed. You need the MySQL ODBC driver installed.

I agree, move to ADO instead of RDO, and then stop using the ODBC driver altogether. You'll want the OLEDB provider for MySQL - which of course will still need to be installed on client computers.

RDO and ODBC are old technologies that may have a place in some specialized applications but should mostly be avoided.

Look at

http://luggle.com/~sean/Articles/MySQLPV.php

and other sources.