Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building remote view on MySql crushes VFP
Message
From
25/07/2008 09:59:13
 
 
To
25/07/2008 05:26:12
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01334020
Message ID:
01334066
Views:
10
>Dear All,
>
>Testing for multiple backends;
>
>When I try to build remote view filtered on single primary key using something like '?myPk'
>as filter (where) expression for RV, VFP9 crushes every time. I am simply not able to exceute it even once.
>If myPK is not populated it normally prompt me fopr value but then immediately afterwards VFP9 crushes.
>
>I did exactly the same with Oracle view/DSN and it did happen few times at very beginning, but now it all works. Fox dbc via ODBC also works perfectly fine. MS Access as well;
>
>What could be the problem here with mySQL ?!?

Update;

Sad 'solution' :(
Apparently Fox have some kind of problem with mySql odbc driver 5.1
BTW it is not only VFP9, it will crush VFP6 as well.

So now I switched it to driver version 3.5.1 and it works up to now.
Anybody made it work with version 5.1 ??
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform