Author: Stephen Russell
Posted: 2018-11-28 at 08:32:11
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]
_______________________________________________
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/CAJidMYLuHGCM11O42F87ju3hzUUKhaCOFk16Xn_1gZmhqfsb3A@mail.gmail.com
** 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.