Search results for query: *

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

Here are the contents of my.ini (MariaDB): [mysqld] datadir=D:/MariaDBData port=1696 skip-ssl=1 innodb_buffer_pool_size=1010M [client] port=1696 plugin-dir=C:\Program Files\MariaDB 11.4/lib/plugin These are the modifications I made: 1) change port to 1696 2) added skip-ssl=1 3) changed...

Chriss, I have two PCs. The one with IP 192.168.0.25 is the one running MariaDB server. The one with IP 192.168.0.10 is where I am connecting from. And yes, I have already checked my firewall settings. It's all good. It's kinda automatic for both MySQL and MariaDB I believe; they both opened...

Hi Chriss, Here is the connection string as pasted: DRIVER=MariaDB ODBC 3.2 Driver;PORT=1696;SERVER=192.168.0.25;DATABASE=richline;UID=appuser;PWD=p@55w0rd I also tried with curly braces like so: DRIVER={MariaDB ODBC 3.2...