powerbuilder mysql_Powerbuilder mysql catalog tables

1) In the past, we had to put some param in the config of mysql odbc connector:

Option 135176.

"Allow Big Result Sets"

"Enable Safe Options"

"Ignore Space after function Names"

2) // Powerbuilder Profile 32bit MySQL

SQLCA.DBMS = "ODBC"

SQLCA.AutoCommit = False

SQLCA.DBParm = "ConnectString='DSN=32bit MySql;UID=user;PWD=password;server=nnn.nnn.nnn.nnn;db=testdb;option=135176',OJSyntax='ANSI'"

3) add lines in your pbodb125.INI file to explain how pb must talk to mysql

[MySQL]

PBSyntax='MySQL_SYNTAX'

to the Syntax Section:

[MySQL_SYNTAX]

GetIdentity='Select @@identity'