Outlook and Mysql

[fimietta]

Hi guys
I'm an italian web developer, I'm a new to outlook programming.....
I've a very simple question: from my outlook application, I would to
connect to mysql database and execute query.....
Is it possible? How? I saw that this is possible for Access......

Thanks in advance for the attention and sorry for my bad english

Daniela Remogna
www.fimietta.it

 

[fimietta]

I found mysql ODBC connector. Probably it is the solution!
Now I'm searching a code example.

 

[fimietta]

Well, I solved the problem.

This is the code:

Sub testDB()
Set db = CreateObject("ADODB.Connection")
db.Open ("Driver={MySQL ODBC 3.51
Driver};Server=localhost;Database=ged;User=root;Password=;Option=4;")
sql = "INSERT INTO prova(testo) VALUES('ooo')"
Set rs = db.Execute(sql)
db.Close


End Sub

"ciao ciao"

Daniela