How to connect mysql database using vb?

[salvelinus]

From the second link I posted:
# ODBC 3.51 Local database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"


# ODBC 3.51 Remote database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

[clairexh]

Hi Salvelinus

Thanks a lot for your reply. If I use code below (I only need to connect to local host for the time being)

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"

an error message: complile error: syntax error

I am applying this code in vb Editor in Word document, what I want to do is to connect mysql from the vb Editor using vb code, then I could try to get the data from mysql and put into table in the Word.

Please could you give me more detailed instruction? Many thanks in advance

Claire