First guess is the port # is blocked at the new location.
On Wed, Nov 28, 2018 at 5:39 AM Graham Brown info@compsys.co.uk wrote:
Hello
I've just had to revisit a foxpro app I wrote about 10 years ago.
This just reads an excel spreadsheet, generates an SQL statement and fires it at a MySQL database.
I'm using MyODBC 5.1 and Foxpro 8.
This is a sample of the SQL.
insert into aw_due
(f_mem_rn,f_supplier_rn,f_mem_name,f_supp_name,f_date,f_value,f_mem_code,f_x ls_ref) values (544,0,
'AB ','An','1990/01/01',3735.49,'117 ','9999');
The code opens a connection with
nMySQL=Sqlstringconnect("Driver=MySQL ODBC 5.1 Driver;SERVER=mysql.abc.com ;UID={aw};PWD={test};DATABASE={aw16};port=52905")
and sqlexec(nMySQL,cSQL)
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.
Has anybody seen anything like this please?
Graham
This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]