Import MySQL stored procedure into DS 4.1 using ODBC connector

[djuricz]

Is is possible to import MySQL stored procedure into DS 4.1 using ODBC connector? I don't seem to be able to do this.

Zlat

[djuricz]

I have managed to call it using sql() command in BODS script. It seems to work.

I'm connecting to Google Cloud SQL using ODBC connection as BODS 4.1 doesn't support native connections with MySQL 5.5 (on MySQL 5.0 or 5.1)

However, I was not able to import is as a function using a datastore, such as other tables from this data source.

[Former Member]

Hi,

Yes, there shouldn't be a problem.

What your DS and MySQL exact version and what type of ODBC connector  and version are you using ? Is the DS job server on Windows or Unix platform?

Thanks

Nawfal