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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement