Author: Ted Roche
Posted: 2018-11-28 at 08:00:59
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
--- 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/CACW6n4tmWYBPJ6HDmJNO9V2RhYA9OopzYvHMYvSkTcDV+vYXGg@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.