How to connect to SQL SERVER ?

[addsd]

Dear All

Have developed a Front-end application (VB 6.0) using SQL SERVER 2000 as backed databse. Now I want to deploy this application on users PC.

We have head office and 2 branch offices in diffrent cities and we have 3 domain which 199.40.97.xxx for Head Office and 199.40.96.xxx for 'Branch 1' and 199.40.95.xxx for 'Branch 2'. All ther users are loggig to there local Domain.

I want to install my Fron-End application on ther Usres PC who is wotking in Head Office and Branches as well. My SQL Server 2000 located @ Head Office and it's IP is 199.40.97.200. I installed my application for some users in Head Office, where my SQL Server 200 located, as a test and it works well.

Now I want to install in 'Branch 1' and 'Branch 2'. I can ping my SQL Server IP from the any machine from the branchs. Could you please advise me as what are the SQL 2000 software shall I install on client's PC (Branch 1). What I have to do with User's Window's 'services and host' files ?. Shall I add any TCP Port number in 'services and host' file which is in WINNT/System32 folder.

REally appreciate any of your advise and help on this matter. Now the timne for me to deploy the application. So, I need your kind help. Looking forward to receive the responses. If above doesn't make sense, please don not hesitate ask me and I can provide any information required.

Thanks & regards,

Ahmed Jewahar
eMail: ajewahar@sa.dhl.com

 

[chiph]

No need to modify the hosts or services file -- you can ping the server which proves you can potentially connect. All you need to install at each client is the MDAC_TYP.EXE re-distributable file from Microsoft (msdn.microsoft.com/data). This will install the MDAC (includes ADO, DAO, and ODBC programming interfaces, but not JET), which is probably what you'll need.

Chip H.