Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can I use ADODB object in MDAC 2.5?
Message
De
26/08/2001 22:17:55
 
 
À
26/08/2001 22:06:39
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00549312
Message ID:
00549314
Vues:
17
Why use VB? VFP works just fine and data access and processing to the Fox tables will be much faster.


>We have an old system running FoxPro 2.5 For DOS. There is a need to exchange
>data with a MS SQL server (remote) real time. A program need to be developed to access both databases. I am thinking about using VB plus ADODB object in MDAC 2.5 to do the job. The FoxPro 2.5 database files are on a NT 4.0 server.
>
>I did the following test on a test manchine.
>1. Install FoxPro 2.5 on a NT 4.0 machine.
>2. Create ODBC data source on the same machine to the FoxPro database.
>3. Create a small Visual Basic Code using ADODB object and successfully access the table.
>
>My question is what will happen if other user are using the old DOS application
>accessing the same table files at the same time? Can I lock the table by using ADODB?
>
>Many thanks in advance,
>
>Dayang
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform