Marco,
There are different ways you can state the connection string. The strings
below are taken from the website;
http://www.connectionstrings.com
cheers!
Steve
Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=Aron1;Database=pubs;User
ID=sa;Password=asdasd;Trusted_Connection=False"
(booth connection strings produces the same result)
a.. Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(booth connection strings produces the same result)
(use serverName\instanceName as Data Source to use an specifik SQLServer
instance, only SQLServer2000)
a.. Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is
the port to use (1433 is the default))
a.. Declare the SqlConnection:
C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();
VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()
--------------------------------------------------------cut
here------------------------------------------------------------------------
-----------------------------------
Hi everyone,
is there any way to conect to SQL Server by using Windows Autentication,
but providing the
user and password? I mean, the user need to type the same windows user login
and password.
How could I write the connection string?
Regards,
Marco