Recent content by dylim

Chriss, For now, I will use your suggestion: SQLEXEC(h,'Do @dummy=0') I get your point regarding having empty non-queries. I just hate the idea of having to programmatically erase/delete the resulting returning cursor each and every time my system queries this. I use this in a timer event...

Hi, Pardon my ignorance, but how do you execute a comment sir? I tried this first in Workbench, but no response or feedback. Thanks.

Hi Guys, With MySQL, I use "DO 1" to check for the server's online status. Works like a charm. But MySQL 8.x has caused me so much pain by way of unknown errors I cannot seem to understand and correct. So, I tried MariaDb, installed the latest GA todate, 11.7.2 and used the latest ODBC 3.2.5...

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

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

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!

What version number does your VFP install have sir?

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

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

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!

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

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.

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

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

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