Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sybase SQL Anywhere & Lockups
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00289514
Message ID:
00294881
Views:
38
Thanks, Lorne. I will print this for future reference. We're exploring some other issues right now. Being that it's the third-party software that's using Sybase, I'm hesitant to mess with the driver, especially since it's working on some stations and not on others. However, I will keep this in case. . .

JR

>I havent tried to build a full app into Sybase from VFP, but have used it set up data from several sources(FP 2.6, VFP 6, Access, Paradox, don't you hate almagamating user built dbs into one vendor supplied?) to Sybase. I found a few problems, and got around them with some effort.
>
>Use Sybase's driver. (driver=..\wod50w.dll, strt = ..\dbclienw.exe -x tcpip or app. for your version) The last switch locks it to only tcpip, and improves performance. It works much better than MS's (what doesnt?).
>
>I used remote views with share conection = .T.
>
>I kept my queries simple, Sybase seems to die (at least at the workstation) if the joins are too complex. Definitly avoid two outer joins, it takes forever or simply crashes the workstation.
>
>On the other hand, doing it to/from Oracle is easier, but increadably slow.
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com
(941) 743-0108
(800) 246-5488
Previous
Reply
Map
View

Click here to load this message in the networking platform