SQL2005
-
hi all, how can i run a windows client application that need to connect to an sql server 2005 while the sql server is installed into a server machine. plz i need a help regards. bye
etretyertyery
You need a sqlConnection object. In the connection string point it to the sql 2005 sql server. Often it is a good idea to store the connection string in the app.config file of your windows app. The connection string might look something like: "Data Source=yourservername;Database=yourdatabasename;Integrated Security=SSPI;" if you are using NT authentication. If you are using sql user and password then you have those items in the connection string instead of Integrated security Ben
-
You need a sqlConnection object. In the connection string point it to the sql 2005 sql server. Often it is a good idea to store the connection string in the app.config file of your windows app. The connection string might look something like: "Data Source=yourservername;Database=yourdatabasename;Integrated Security=SSPI;" if you are using NT authentication. If you are using sql user and password then you have those items in the connection string instead of Integrated security Ben
You can find more connection strings here: www.connectionstrings.com
-
You can find more connection strings here: www.connectionstrings.com
Giorgi Dalakishvili wrote:
You can find more connection strings here: www.connectionstrings.com
Darn, Giorgi, you beat me to it :laugh:
-
Giorgi Dalakishvili wrote:
You can find more connection strings here: www.connectionstrings.com
Darn, Giorgi, you beat me to it :laugh:
-
it is important to know that the client does not have an sqlclient in his machine 10x regards.
etretyertyery
If the client does not have SQL Server on his machine, I assume he can see SQL Server over his local network ? If so, it makes no difference. If not, how do you expect this to work ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
If the client does not have SQL Server on his machine, I assume he can see SQL Server over his local network ? If so, it makes no difference. If not, how do you expect this to work ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )