Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlPassthrough? Inserts? in a FoxPro DataServer
Message
From
06/09/2001 23:58:19
Lemuel Vellez
Augustinian School
Biñan, Philippines
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SqlPassthrough? Inserts? in a FoxPro DataServer
Miscellaneous
Thread ID:
00553575
Message ID:
00553575
Views:
61
Im neophite in VFP client/Server Development. Here's my problem: I have a Project Evaluation System that my boss needs me to run in an NT Server so multiple clients can access and evlute the project at the same time. So i placed my Data to the NTSErver but i didn't upsize it to SQL SERVER first co'z i dont know how an second i dont hav much time left to study SQLSERVER for now co'z of the Deadline, So wht i did is install A VFP in NT and test a client if it can access the data. It work, i use ODBC then connection in my GUI. I didn't use remote view's instead i used SQLPassthrough inside the init event of my form in the client computer.

Now here's my question

1. could i Access the Same Database(VFP) in an NT Flatform when 2 client is accessing the data at the same time? would there be conflicts. if so how could i handle that.
2. Can i Do inserts in the same table, when he insert request is comming from 2 clients at the same time.If not, how could i do that.

Thank's Nancy for the tips.:)
Next
Reply
Map
View

Click here to load this message in the networking platform