Search results for query: *

Hi Chris, I ran lnsuccess_fetch_new = SQLExec( gnConnHandle_CR, "SHOW VARIABLES LIKE '%vers%';", 'mysqlvariables') I got version 5.7.44-48 Best regards, Abe

Dear ALL, Hip Hip Hooray!!! I have tried what mJindrova suggested "MySQL ODBC 3.51 Driver" and IT WORKS . Thank you so much for all your support and time to help me! Blessings to all! Abe

Hi Chris and Mike, Thank you so much for your feedback! I have tried Option=16387 gnConnHandle_CR = Sqlstringconnect("Driver={MySQL ODBC 8.0 ANSI Driver};Option=16387;Server=123.123.123.123;Database=database;Uid=abe;Pwd=d") This is what I got The id column has all ZEROs instead first field...

Using Driver={MySQL ODBC 8.0 ANSI Driver} I have uploaded three images, one for MySQL table records and the other is its structure and last one VFP cursor This what shows in VFP cursor

Hi Chris, Thank you for your response. I have tried Driver={MySQL ODBC 8.0 ANSI Driver} The cursor had same .Null. data. exactly like the above image. I'm not sure what to do. Abe

Hello All, I need your help with: *---------- cQuery = 'SELECT * FROM database.lfx_wc_orders' *---------- Connect to MySQL Server and import all records gnConnHandle_CR = Sqlstringconnect("Driver={MySQL ODBC 8.0 Unicode Driver};Server=123.123.123.123;Database=database;Uid=abe;Pwd=d") If...