dh PBMYSQLer Experiment 1: Saya dah coba konek PB ke MySQL pakai driver MySQL ODBC 3.51. Koneksi berhasil, tapi ketika bermain-main di database lewat PB, Masuk ke DataWindow - Freeform - SQL select - kemudian pilih salah satu table selanjutnya muncul error:
"SQLSTATE = 37000 [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "user".pbcattbl where pbt_tnam = 'indk_kar' and" Meskipun setelah di click OK tetap bisa masuk. Setelah itu untuk bermain-main table masih bisa, tapi ketika menyimpan DataWindow nya tidak pernah berhasil, selalu muncul error tersebut dan tak tersimpan. Experiment 2: Tetapi jika saya connect ke database tanpa bikin table, dimana rencananya table ingin saya buat di dalam PB, muncul error ketika konek sbb: "Catalog tables could not be created and are not available for use"Tapi database tetap bisa konek, tapi untuk bikin table error lagi error lagi. Salah dimananya kah ? settingan PB or settingan MyODBC nya or dua-duanya :-( Terimakasih atas bantuannya. ps.fyi: Di experiment 1, table system terlihat lengkap: pbcatcol, pbcatedt, pbcatfmt, pbcattbl dan pbcatvld Di experiment 2, table system hanya terlihat 2 table, setelah aku otak-atik terakhir terlihat 4, yaitu: pbcatcol, pbcatfmt, pbcattbl, pbcatvld ___________________________________________________________ indomail - Your everyday mail - http://indomail.indo.net.id ----------------------------------------------- IndoPB - Indonesia PB User Group An Indonesian PowerBuilder User Group's Event 2nd PowerBuilder Update Rumah Sakit Jantung Harapan Kita 26/27 August 2006 To Register : http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
