General information
Title:
SqlPassthrough? Inserts? in a FoxPro DataServer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only