Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Abe D
  • Order by date
  1. Abe D

    Running SQLEXEC on MySQL Database

    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
  2. Abe D

    Running SQLEXEC on MySQL Database

    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
  3. Abe D

    Running SQLEXEC on MySQL Database

    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...
  4. Abe D

    Running SQLEXEC on MySQL Database

    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
  5. Abe D

    Running SQLEXEC on MySQL Database

    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
  6. Abe D

    Running SQLEXEC on MySQL Database

    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...

Part and Inventory Search

Back
Top