Yeah Ed - I know. I've heard you mention that a couple times. So, I
guess I'm in the same club now. Previously working w/Fox - yet no more -
but, still hanging with the Gang!
-K-
On 11/28/2018 8:05 AM, Ed Leafe wrote:
On Nov 28, 2018, at 9:43 AM, Kurt @ Gmail wrote:
Look at that! Glad I
You can determine if it is a rights issue from phpMyAdmin with:
select * from information_schema.user_privileges;
ASSuMIng you have rights to that metadata. You should see information about
the user you log in with and permissions for the database in question.
You might need to add the filter:
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
On Nov 28, 2018, at 9:43 AM, Kurt @ Gmail wrote:
>
> Look at that! Glad I could be of some limited use here - even though I'm no
> longer working in Fox - at least not right now...
Heh, I haven’t had a copy of Fox for over a decade. So don’t feel bad. ;-)
-- Ed Leafe
Look at that! Glad I could be of some limited use here - even though I'm
no longer working in Fox - at least not right now...
-K-
On 11/27/2018 6:41 PM, Ed Leafe wrote:
On Nov 27, 2018, at 6:59 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
However, when clicking the "View entire
On Nov 27, 2018, at 6:59 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>
> However, when clicking the "View entire thread"
> (https://leafe.com/archives/full_thread/506233), the site then failed and
> just said "No results were found. Please try again."
>
> (Flashing the big "E" in
First guess is the port # is blocked at the new location.
On Wed, Nov 28, 2018 at 5:39 AM Graham Brown 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
On Wed, Nov 28, 2018 at 6:38 AM Graham Brown 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
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
9 matches
Mail list logo