constructing an sql connection with out sql support.
-
hello people, I have an sql connection like the following. it works perfectly fine. I am using sql server'05.
SqlConnection conn = new SqlConnection("Data Source=" + Environment.MachineName + "\\WINCC;Integrated Security=SSPI;Initial Catalog=Logger; Packet Size = 32766;");
However, i want to have a connection so that my application runs on any machine, that does not have the sql server. thanks
Keshav Kamat :) India
-
hello people, I have an sql connection like the following. it works perfectly fine. I am using sql server'05.
SqlConnection conn = new SqlConnection("Data Source=" + Environment.MachineName + "\\WINCC;Integrated Security=SSPI;Initial Catalog=Logger; Packet Size = 32766;");
However, i want to have a connection so that my application runs on any machine, that does not have the sql server. thanks
Keshav Kamat :) India
Keshav V. Kamat wrote:
i want to have a connection so that my application runs on any machine
Activate TCP/IP and the "Server Browser Service" in the SQLServer's configuration dialog. Locally, the SQLServer uses Named Pipes fpor comminucation with clients. To talk to remote clients, it needs CP/IP. To find the instance "WINCC" by name, the clients need the browsing service.
____________________________________ There is no proof for this sentence.
-
Keshav V. Kamat wrote:
i want to have a connection so that my application runs on any machine
Activate TCP/IP and the "Server Browser Service" in the SQLServer's configuration dialog. Locally, the SQLServer uses Named Pipes fpor comminucation with clients. To talk to remote clients, it needs CP/IP. To find the instance "WINCC" by name, the clients need the browsing service.
____________________________________ There is no proof for this sentence.
Thanks. But still, I want the connection to work when there is no SQL installed on a machine. instance "WINCC" is fine. i could let an open file dialog or a simple text box do the job. But I feel creating a database without any data source would be impossible. thanks anyways.
Keshav Kamat :) India
-
Thanks. But still, I want the connection to work when there is no SQL installed on a machine. instance "WINCC" is fine. i could let an open file dialog or a simple text box do the job. But I feel creating a database without any data source would be impossible. thanks anyways.
Keshav Kamat :) India
SQLServer can run on any remote machine. The client application finds the server by servername\instancename in the connection string. Activate TCP/IP and Browser Service on the remote server and your clients will run fine.
____________________________________ There is no proof for this sentence.