VB connection to Linux DB

[NicoleM]

hi

Anyone know of a way that a database on a linux box can be accessed by visual basic running on a windows box?
If not - I heard there is visual basic for linux - are the exact same components available to windows vb available for linux or do they have to be created?
Linux Db + VB????

 

[sleipnir214]

The most common way is the same way you access any database from VB: ODBC. You just need to install the appropriate driver for your database backend.

If your Linux DB is MySQL, then get MyODBC (

http://www.mysql.com/downloads/api-myodbc-2.50.html)

If you Linux DB is PostgreSQL, then get psqlOdBC (

http://odbc.postgresql.org/psqlodbc.php?DocID=index)

Is your Linux DB among these?