philipnaparan

SQL Server connection strings SQL ODBC connection strings

Posted by philipnaparan on 19 September, 2009
No comments yet
This item was filled under [ General Programming ]


SQL Server connection strings

SQL ODBC connection strings


Standard Security:

“Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;”

Trusted connection:

“Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;”

SQL OLE DB connection strings

Standard Security:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;”

Trusted connection:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”

SQL OleDbConnection .NET strings

Standard Security:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;”

Trusted connection:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”

SQL SqlConnection .NET strings

Standard Security:
1. “Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;” < br>2. “Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False”

Trusted connection:
1. “Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”
2.”Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;”






Rate this topic:
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Popularity: 368 views
Tagged with: [ ]
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Comment

« Professional Microsoft SQL Server 2008 Programming
MS Access connection strings MS Access ODBC connection strings »


SQL Server connection strings SQL ODBC connection strings Copyright: You should confirm all information about SQL Server connection strings SQL ODBC connection strings full version edition(freeware/shareware) before downloading or relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators or key gen, cd key, hacks, dvd rip is illegal and prevent future development of SQL Server connection strings SQL ODBC connection strings full version edition. Download links are directly from our publisher sites or from the link provided by users, torrent files or links from rapidshare.com, yousendit.com, megaupload.com, netload.in, storage.to or depositfiles.com are not allowed.