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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dylim

  1. dylim

    Latest VFP Version

    Thank you sir. By the way, have you tried out that VFP "Advance", aka VFP 10? Should we?
  2. dylim

    Latest VFP Version

    Hi Joe, So the latest version is still this? Visual FoxPro 09.00.0000.7423 for Windows Right?
  3. dylim

    Latest VFP Version

    Yep, 2024. Very unlikely of Micro$oft to give us a new patch for VFP. :rolleyes: Please do sir. Keep us posted. Thanks in advance!
  4. dylim

    Latest VFP Version

    What version number does your VFP install have sir?
  5. dylim

    Latest VFP Version

    Hi Guys, This is the version of Visual Foxpro I have been using for the longest time: Visual FoxPro 09.00.0000.7423 for Windows Is this still the the latest? The reason I am asking this is because I came across this link from Microsoft...
  6. dylim

    Correct Connection String VFP to MariaDB

    Hi Guys, Am so glad that after installation of the latest stable release of MariaDB server (11.4.5) and ODBC (3.2.5), albeit with some booboos along the way, it has so far been a generally smooth transition. My apps have run so much snappier. Am keeping my fingers (and toes as well) crossed...
  7. dylim

    Correct Connection String VFP to MariaDB

    Chriss, That is a bad habit of mine. Coz it has been working for the longest time, that's why I immediately "rule them out" since they never were a problem maker for me. Anyways, thanks be to our Lord, and thank you Chriss. Cheers!
  8. dylim

    Correct Connection String VFP to MariaDB

    Hi Chriss, I found the darn culprit! The real reason of not being able to connect was because of my Connection Manager class! In my Connected() method, which returns .T. or .F., the code is as follows: RETURN ( This.DataSource > 0 ) AND ( SQLEXEC( This.DataSource, "DO 1" ) > 0 ) It appears...
  9. dylim

    Correct Connection String VFP to MariaDB

    How come you didn't need skip-ssl setting? The screenshot has same contents are the results in the remote laptop. I am now in the test computer running MariaDB.
  10. dylim

    Correct Connection String VFP to MariaDB

    Am so sorry Chriss. What I meant was that -- I omitted the database. My brain cells must be fried. And... GUESS WHAT?! I added "skip-ssl=1" to the connection string like so: lnConn = SQLSTRINGCONNECT( "DRIVER={MariaDB ODBC 3.2...
  11. dylim

    Correct Connection String VFP to MariaDB

    Hi Chriss, I tried connecting using an omitted server. Still no luck. But, when I change {MariaDB ODBC 3.2 Driver} to {MySQL ODBC 8.0 Unicode Driver}, it connects. I reinstalled the test PC with Windows 10 LTSC Evaluation, thinking it may be because of Win 11. Same undesired behaviour. You...
  12. dylim

    Correct Connection String VFP to MariaDB

    Chriss, Did you like tweak anything in MariaDB? More specifically, the file my.ini? Are you running on Windows 10 or 11? Thanks.
  13. dylim

    Correct Connection String VFP to MariaDB

    For now, the very obvious thing is, all thing being equal... same server, same settings.. why does the MySQL ODBC function work, while the MariaDB ODBC does not?
  14. dylim

    Correct Connection String VFP to MariaDB

    And to think that the PC (with 192.168.0.25), I just did a clean install of Windows 11 LTSC Evaluation. Then install MariaDB Server 11.4.5. Then the ODBC. It is so frustrating!
  15. dylim

    Correct Connection String VFP to MariaDB

    driver={MariaDB ODBC 3.2 Driver} server=127.0.0.1 port=1696 uid=root pwd=p@55w0rd database=richline Same unwanted result! Drats!

Part and Inventory Search

Back
Top