[RESOLVED] How to use other pc dsn

Quote:

---

I am also searching for a reliable solution

---

when u get the relaible solutinn then please tell me..
thanks

@ Shuja Ali

Do u got the relabile solution

No I did not. When I get one, I will post it here. Meanwhile you can check other threads in the Forum, you might get something that is more reliable.

@Shuja ali Thanks a lot

Plese when u got the solutin then send me............

this time i am resloving this thread

thanks

shakti, if your application is written correctly you can't do what you want to do. Consider these facts:

a) The only way to reliably do what you want is to see which client PC is connected to the database.

b) The proper way to code a database application is to do what you want to/from the database (execute a SQL statement), then disconnect. the connection may only exist for a fraction of a second.

Since (a) only exists for a very small time and at (relatively) great intervals, you'll almost never reliably know which PC is "using" the database. (Using, in your sense, means running your program.) You can know who's running the program, you can know who's connecting to the database, but they're not the same thing.

You could ... have your program renew its entry in the database periodically, say twice every second. If its entry isn't there it inserts it. If it's there it ignores it. Have the server delete these entries every, say, 2 seconds and check for them on the other seconds. (Like delete on even seconds and check on odd seconds.) If the entry is there at the check, the computer was using the database no more than a second ago.

This would eat a lot of server CPU and a lot of network bandwidth, but it would sort of do what you want.

But what happen when any pc get shut sown automatically.......
then it show in the database that user is using the database.......
Tell me

@Shuja Ali
Please check the post 45 what ....ur thinking about it...........
thanks

Can we delete record from the database before shut down.........?