Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building remote view on MySql crushes VFP
Message
From
25/07/2008 10:26:06
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
25/07/2008 09:59:13
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:
01334070
Views:
17
>>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 ??

Didn't even know they had a 5. Worked fine with 3.5.1 last time I tried... some time last year, I think.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform