Search results for query: *

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.

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?

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!

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

When I installed MySQL server, I already changed the port from 3306 to 1686 during the installation process. Never had any issues with Firewall. I did the same with MariaDB Server installation process.

I did exactly as you have shown in the pictures. Only thing different is I change port 3306 to 1696. Of course, the password you supplied is different from what I put in. I used both root and appuser in my SQLSTRINGCONNECT() right in the local machine (192.168.0.25) where MariaDB is running...