How to access a MySQL database from

[geetapm]

How to access a MySQL database from VB , Urgent
Thanks

Bye

 

[JustinEzequiel]

I will be doing the same soon so I did some searching...
see

http://www.mysql.com/products/myodbc/manual.html#MyODBC_With_VB

 

[geetapm]

Thanks for ur reply.

i got connection thru ODBC.
now i want to try it thru ADODB.
problem is what DataSource I have to give,
since MYSQL doesn't show me any DataSource.
If someone can through light on this matter,
it will be a big favour.

Bye

 

[RobertMottram]

This should open you an ADODB Connection to a SQL server.
The only other thing you need to do is projects|references in VB and ensure that ADO is selected.

Dim dbDMS As ADODB.Connection

Set dbDMS = New ADODB.Connection
dbDMS.Open "Provider=sqloledb; Data Source=

ServerName

;Initial Catalog=

IntialDatabase

;User Id=

UserName

;Password=

PassWord

;"

The database is now open. You then will probably want some recordsets to work on....

Dim rstTest As ADODB.Recordset
Dim strSelectSQL as String

strSelectSQL = "Select * from TestTable"

Set rstTest = New ADODB.Recordset
rstTest.ActiveConnection = dbDMS
rstTest.Open strSelectSQL

Do Processing

rstTest.close

Or you can execute stored procedures

dbDMS.Execute ("Insert testtable(Name, Surname) values (Robert, Mottram)")

When all is done on the database

dbDMS.close

Once the record set is created most of the function seam to work the same with ADODB as they did through ODBC (or at least the ones I have tried!)

I hope that this may help you

Robert Mottram

 

[mmilan]

I think the idea here is to use ADO to connect to the ODBC source.... I'm going to be messing with this as well soon...

 

[RobertMottram]

Sorry, I just noticed in my last post I was connecting to MSSQL not MySQL doh!

http://www.able-consulting.com/ADO_Conn.htm

Will gives a large number of ADO connection string examples. If you have created the ODBC connection to MySQL ( which I could not workout how to do last time I looked) you this page has an example of a connection string to ODBC. You would use this

oConn.Open "DSN=mySystemDSN;Uid=myUsername;Pwd=myPassword;"

I hope this makes some more sence!

Robert

 

[geetapm]

thanx to all of u guys.

It was a great help to me.

Thanx once again.