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

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/05c301d4870f$01b31600$05194200$@compsys.co.uk

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.