server/client connection of sql 2000 in 2 computers

[lightyagami]

how to connect 2 pc in sql server,1 is server and 1 is client...?
and also my question is,is it ok if the server runs in windows xp?or we need a windows NT?
pls help me with my thesis...Thanks

[debasisdas]

What is the problem you are facing ?

Are you trying to access database present in another system ?

[lightyagami]

yes we are trying to access the database with the same system we made from vb6 and connect/access it in another computer...one pc was server and the other pc was client...now, how to do it step by step...?can u help me with my thesis...?thank s...

[ck9663]

You mentioned you made a VB6 system. Did you managed to connect to a sql-server that's on the same computer on that system? If you have, that would mean you just have to point from the local machine to the new server, either by name or IP. If you have not, you can try DAO or ADO.

If it's just for your thesis, I'd say a Windows XP would be sufficient enough. Unless you need something specific from Win NT.

-- CK

[lightyagami]

yes we've connected our system and the server but only in 1 computer,our judges want us to network it so...how can i connect to the database of the server from the client using our system...?what will i do?is it from the sql or in vb6 to connect...?than ks for helping us...