PB 6.5 - MySQL table format

[ConsMorante]

hi!!


i'm currently learning Powerbuilder i used to work with Visual Basic and PHP but here in my current project i've been assigned as a programmer using Powerbuilder..


the thing that i'm wondering about is that whenever i try to connect to my database to either INSERT and RETRIEVE data from MySQL i always end up with this error "table <tablename> has no columns, possible invalid table format"

i really don't know what to do.. i'm really trying so hard to learn powerbuilder... eventually more question about PB will be posted by me.. ^_^


hope somebody can explain to me how to solve this issue..

thanks...

 

[bernds44]

I asume you are connecting to the database via odbc connection. this seams to be an powerbuilder(pb) problem when retrieving the table structure in database. pb uses the special functions from odbc interface to get the table structure out of the database.

the reasons for that may be various.

1. the odbc function is not implemented or implemented wrong in your odbc driver

2. the odbc-driver properties need to be set/changed for a pb-connection (try mysql-support/forum)

3. the table in your database is curropt. maybe it was created without updating mysql-metadata correctly. (try various db-tools to retriev/update the table. if they succed all seems ok with metadata)

4. the pbodbxx.ini file in the pb shared folder needs to be updated. (xx is your pb version e.g. pbodb90.ini for pb-version 9) from that file pb takes the syntax for creating sql-statments either in desing/develop mode as well as in deployed apps)