Visual Basic Forum for Visual Basic Programmers VB

[EricBerg]

I am trying to get a list of the various tables in a MySQL database. I can connect to the database with the following code:

Set cnn1 = New ADODB.Connection
cnn1.ConnectionString = "DSN=MyODBC;UID=root;PWD=password;"
cnn1.Open

If I'm using an access database I simply do:

With SelectedDatabase
For I = 0 To .TableDefs.Count - 1
cmbAccessTable.AddItem .TableDefs(I).Name
Next I
End With

How can I access the names of the various tables in MySQL database?

Kind Regards,
Eric

[dougthomas]

Hi,

The information here:
[link]
may be of some use to you.

Regards
Doug
_________________
If you can see the light at the end of the tunnel, it probably means there's a Train coming.