Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sybase SQL Anywhere & Lockups
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00289514
Message ID:
00293273
Vues:
44
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
Fil
Voir

Click here to load this message in the networking platform