Hi
I am Prashant I am using PowerBuilder 11.5 and MySQL 5.1 on Windows 7 32 Bit. PowerBuilder Application required Optional prameter IGNORE_SPACE Ignore space after function names 4096 Tell server to ignore space after function name and before “(” (needed by PowerBuilder). This makes all function names keywords.
Previously i was using ODBC Driver there we do have Option in the form of checkbox to set this option.
Now i am trying to connect using JDBC driver i sucesfully connect to MySQL but the problem is whenever is used any function like sum() or count() it give PowerBuilder error
Database C0038: SQLSTATE = 42000 You have an error in SQL syntax; check the manual for corrosponding to your MySQL server version for the right syntax to use near '*) from my_table' at line 1
you will get more info on
http://dev.mysql.com/doc/refman/5.0/es/myodbc-configuration-connection-parameters.html
http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-configuration-connection-parameters.html#codbc-dsn-option-flags
since i am new to this please help i am in great trouble.
my connection parametrs are as follows
// Profile Transporter3
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = "tss"
SQLCA.LogId = "root"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/mydb'"