Thanks for the pointers
The app runs local on Windows 7 and uploads a lot of Excel data to an external online portal on shared hosting.
The hosting has a remote SQL option to unlock the port for my IP. If the port is locked it won't even connect. Also I get a connection and I can fire off select and delete commands but not update and insert commands. I've checked the size of the MySQL DB and it isn't over quota.
I don't know anything about the set up as it is shared hosting with www.20i.co.uk. As the domain is managed by another company I can't even talk to 20i myself. I don't know where MySQL is in relation to PHPMyAdmin. They just say use the mysql.abc.com in the hostname and they resolve this to the correct box.
The domain was originally hosted by HeartInternet.co.uk and the update always worked.
One thing the 20i have said in the last hour is that there are a number of "discarded" commands in the event log. I haven't found out why they are discarded but there doesn't appear to be any problems with the SQL as I can run the same sql in PHPMyAdmin.
I don't get any error so don't know how to check what the ODBC or MySQL is doing or why commands are being discarded if they are mine.
Regards Graham
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 28 November 2018 14:01 To: profox@leafe.com Subject: Re: MyODBC not updating tables
On Wed, Nov 28, 2018 at 6:38 AM Graham Brown info@compsys.co.uk wrote:
nMySQL=Sqlstringconnect("Driver=MySQL ODBC 5.1 Driver;SERVER=mysql.abc.com ;UID={aw};PWD={test};DATABASE={aw16};port=52905")
and sqlexec(nMySQL,cSQL)
Do you capture the results of these functions and test that they are not returning an error?
It has worked for years but the client recently moved to a new hosting company. No errors at runtime, no data arrives in the table but I can run these commands in PHPMyAdmin so the SQL commands are fine.
PHPMyAdmin is running on the same machine as the MySQL, or a different one?
The VFP is surely running on a Windows box. The PHP and MySQL, well, you didn't say.
Offhand, I'd confirm that port 52905 is open in any firewall in place.
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]