Hello,

A client of mine has a software that they were provided by a garment supplier company with whom they have a tie-up for selling garments.

This client is using my developed software for last 3 years. Now they want me to integrate the software with the one they are provided by the supplier product company as the software provided is not as per their requirements.

The twist starts here

It so happens that my client has a small LAN of 5 PCs. Their supplier company's technicians have installed MS SQL Server on the server PC in LAN and have installed the software in rest 4 PCs (nodes). This (supplier company's) software is able to connect to the server (MS SQL Server) and works properly but my developed software is not able to connect to MS SQL server from the nodes.

I have tried to connect using both modes Windows Authentication as well as Server Authentication modes but to no avail.

Here is the code that I am using to try to connect:
Code:
Dim adoCn As New Connection

'connect to SQL Server
adoCn.ConnectionString = "Provider=SQLOLEDB.1;Data Source=192.168.0.54\SQLEXPRESS;Initial Catalog=massretail;User Id=sa;Password=sa;"
adoCn.Open   '<== The connection fails always Why? :confused:
In case of above code I keep on getting Connection refused by Server.

But if my software is run on PC where SQL Server is installed it works with following code:
Code:
adoCn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=massretail;Data Source=.\SQLEXPRESS"
I don't know as to how to solve this problem. Can someone help me out please.

TIA

Yogi Yang