MySQL ODBC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 11 Jul 2003 16:28 GMT

I'm trying to use FoxPro to front end a MySQL database
using MySQL's ODBC 3.51 driver. I can make the connection
but can only view the database. I need to be able to
view, update & delete. Using Access using the same
database and same ODBC driver I can view, update &
delete. I would like to do the same using FoxPro.

Thanks...
Eric

Reply to this Message

Lee Mitchell - 11 Jul 2003 22:25 GMT

Hi Eric:

I do not have MySQL available for testing, so I cannot run this code
against MySQL data. However, you might want to look at this article on
making an updatable view using SQL Passthrough to SQL Server:

138094 How to Create Updatable Views by Using SQL Passthrough
http://support.microsoft.com/?id=138094

If MySQL is similar to SQL Server, then I think this should point you in
the right direction.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>I'm trying to use FoxPro to front end a MySQL database
>using MySQL's ODBC 3.51 driver. I can make the connection
>but can only view the database. I need to be able to
>view, update & delete. Using Access using the same
>database and same ODBC driver I can view, update &
>delete. I would like to do the same using FoxPro.

>Thanks...
>Eric

Reply to this Message

Mark Stanton - 14 Jul 2003 14:40 GMT

> I'm trying to use FoxPro to front end a MySQL database
> using MySQL's ODBC 3.51 driver.

I played around with this briefly and had the type of problems you
describe when I hadn't got the permissions set properly on the MySQL
database. After I got those right I could update and add.

Regards
Mark
-If more of us acted more sensibly,
d'you think Governments might join in?

Reply to this Message

Eric Cetnar - 14 Jul 2003 22:02 GMT

Mark,

I did a Grant All Privileges for the user and still cant
do an update. Was there anything special with the create
statement for the database?? Did you have to do anything
special with building the remove view within FoxPro?

Eric

>-----Original Message-----
>
[quoted text clipped - 11 lines]
>
>.

Reply to this Message

Mark Stanton - 15 Jul 2003 17:13 GMT

> I did a Grant All Privileges for the user and still cant
> do an update.

8-z
I hate it when that happens. It's a while ago now. I seem to
remember that my problem was that it (VFP) wasn't being the user I
was expecting. Might that be what's happening here?

I don't remember anything odd about the database or view.

Regards
Mark
-If more of us acted more sensibly,
d'you think Governments might join in?

Reply to this Message

EFGroup - 22 Jul 2003 01:51 GMT

Eric -
in the view designer - have you selected a field/colum that represents the
'primary key' for that table?
If NOT - you will not be able to update/delete/insert .

hth = regards [Will]

> I'm trying to use FoxPro to front end a MySQL database
> using MySQL's ODBC 3.51 driver. I can make the connection
[quoted text clipped - 5 lines]
> Thanks...
> Eric

Reply to this Message