Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Client/Server Connectivity - SQL SERVER 2000

Status
Not open for further replies.

addsd

Programmer
Joined
Oct 12, 2001
Messages
33
Location
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top