OLE DB Consumer using MySql

[Fabricio Suárez]

 Posted by:  Fabricio Suárez 

Hi NG:

Does anyone have an example of OLE DB Consumer using MySql??

TIA

Fabricio

[Jean-Philippe Victoire]

 Posted by:  Jean-Philippe Victoire 

hi Fabricio,

I installed myoledb v3.

sample :
Set SqlUser = toto
Set SqlPassword = toto
Set SqlDatabase = sDATABASE
Set SqlUDL = "Provider=MySqlProv;Location=" || sSERVER
If NOT SqlCreateSession( hSgAST, SqlUDL)
Return FALSE
If NOT SqlCreateStatement( hSgAST, hSqlgAST )
Return FALSE

Good luck