Dear friends,
My Q is little bit confusing so pls read it twice.
Through a Client PC in a Windows NT domain named XYZ I am able to connect to a MS Sql Server named alfairho
installed in another Windows NT domain Server named PQR
by using Query Analyzer as well as Enterprise Manager.
But while connecting the VB 6 application using ADO by using the following string i am unable to get connectivity.
I have deployed the application by the setup file created through Package & Development Wizard
Set cn = New ADODB.Connection
cn.ConnectionString = "uid=;pwd=;driver={SQL Server};server=alfairho;database=inventory;dsn=, ,connection=adConnectAsync"
cn.ConnectionTimeout = 120
cn.Open
Pls note:-
Using MS Sql Server - Client Network Utility
The Network Library used is TCP\IP & the Server Alias is set to alfairho in the client from XYZ domain
& in the connection Parameter the Server Name is set to 192.5.2.99 (the IP address of the PQR domain Server)
& the port number is 1433.
Whereas the application runs fine for clients in the PQR domain.
Pls let me know whether any changes has to be done in the coonection string to enable users from domain XYZ to access the database in the Sql Server installed on domain Server PQR.
Thanx & regards
giyer
My Q is little bit confusing so pls read it twice.
Through a Client PC in a Windows NT domain named XYZ I am able to connect to a MS Sql Server named alfairho
installed in another Windows NT domain Server named PQR
by using Query Analyzer as well as Enterprise Manager.
But while connecting the VB 6 application using ADO by using the following string i am unable to get connectivity.
I have deployed the application by the setup file created through Package & Development Wizard
Set cn = New ADODB.Connection
cn.ConnectionString = "uid=;pwd=;driver={SQL Server};server=alfairho;database=inventory;dsn=, ,connection=adConnectAsync"
cn.ConnectionTimeout = 120
cn.Open
Pls note:-
Using MS Sql Server - Client Network Utility
The Network Library used is TCP\IP & the Server Alias is set to alfairho in the client from XYZ domain
& in the connection Parameter the Server Name is set to 192.5.2.99 (the IP address of the PQR domain Server)
& the port number is 1433.
Whereas the application runs fine for clients in the PQR domain.
Pls let me know whether any changes has to be done in the coonection string to enable users from domain XYZ to access the database in the Sql Server installed on domain Server PQR.
Thanx & regards
giyer