Connecting to the remote Sqlserver instance.
-
Hi Firends, I am trying to access remote Sqlserver instance using program, Can anyone tell me how to achieve this. I am having difficulty because My machine is having more that one instance of MSDE/Sqlserver instance how to provide exact information of the Sqlserver instance to which to connect. Please anyone tell me. Thanks n Regards, RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.
-
Hi Firends, I am trying to access remote Sqlserver instance using program, Can anyone tell me how to achieve this. I am having difficulty because My machine is having more that one instance of MSDE/Sqlserver instance how to provide exact information of the Sqlserver instance to which to connect. Please anyone tell me. Thanks n Regards, RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.
If you have more than one instance, you need to specify the machine and instance name to connect. i.e. instead of connecting to "server_name", you would connect to "server_name\instance_name".
-
If you have more than one instance, you need to specify the machine and instance name to connect. i.e. instead of connecting to "server_name", you would connect to "server_name\instance_name".
Hi, Since the server is on the remote machine in that case How to do this, Let me give an example suppose my server name is Foo and the instance name is Bar, IP address of the remote sever is ppp.qqq.rrr.sss Can anyone tell me what would be the connection string. RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.
-
Hi, Since the server is on the remote machine in that case How to do this, Let me give an example suppose my server name is Foo and the instance name is Bar, IP address of the remote sever is ppp.qqq.rrr.sss Can anyone tell me what would be the connection string. RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.
-
Hi, I have gone through that site but To connect to SQL Server running on a remote computer (via an IP address) oConn.Open "Provider=sqloledb;" & _ "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=myDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword" in this example it doesn't provide any information about what to do in the case where I have a named instance. Plz help?? RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.