Ah, yes, I remember seeing some of this COM or ADO stuff in the Que book, plus
the SQL passthrough stuff. I remember putting the book to one side for some
reason, and that reason follows:
It looked to me as if you certainly *could* manage to *read* data from another
machine, but (tell me if I'm right) it looks as if there's no way to UPDATE or
INSERT data into the remote database. Of course, it already looks pretty
involved, especially if you don't just go Micro$oft's way and use the SQL
Server.
CK
"Cal Evans" <[EMAIL PROTECTED]> on 05/29/2001 01:18:08 PM
To: Charles Kirby/Usdcsdny@&2DC-NYS-Notes, [EMAIL PROTECTED],
[EMAIL PROTECTED]
cc:
Subject: Re: FoxPro6 and MySQL, odbc
Thank you! :)
Go grab the ODBC driver for mysql. Install and create a DSN for your mysql
database.
Then go into VFP and open your DBC, add it as a connection.
Now you can add updateable views of all your mysql tables into it and use
them like you could any other remove view.
NOTE: I've spent the last 2 months working with FP & SQL server, using views
like this is not like using FP tables. There are a LOT of problems. We got
around most of them by either :
1: using SQL passthrough (sqlexec, etc)
2: Using ADO
HTH,
Cal
http://www.calevans.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:05 PM
Subject: Re: FoxPro6 and MySQL, odbc
>
>
> Any specifics?
>
> Informative/interesting articles on your Nerd Herd web site, Cal !
> Better fix <INPUT TYPE="hidden" NAME="item_name"
VALUE="ConsultaingAssistance">
>
> I have the Que book, "Special Edition, Using Visual FoxPro 6", but all it
ever
> discusses is how *other* applications can access _FoxPro's_ database. I
don't
> want to do that. I'm considering this really great program (that someone
else
> designed) in FoxPro, but I don't want to use the FoxPro database (it's too
> Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained
some
> functionality for being able to access foreign databases. Other than SQL
Server
> (or Access), that is. I like my databases to be located on Unix servers
(the
> type that don't crash).
>
> Thanks,
> Charles Kirby
>
> ["In a world without fences, who needs Gates?]
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
