Contact Form

Name

Email *

Message *

Wednesday, September 18, 2013

Connection to SQL Server 2012

.NET Framework Data Provider for SQL Server

   | Server=myServerAddress;Database=myDataBase;User Id=myUsername;

   | Password=myPassword;

SQL Server Native Client 11.0 OLE DB Provider

   | Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;

   | Pwd=myPassword;

If  you using SQL Server 2012 Express, don't miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server 2012 Express installation resides.

SQL Server Native Client 10.0 OLE DB Provider

   | Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;

   | Pwd=myPassword;

SQL Native Client 9.0 OLE DB provider

   | Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername;

   | Pwd=myPassword;

Microsoft OLE DB Provider for SQL Server

   | Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;

   | User Id=myUsername;Password=myPassword;

SQL Server Native Client 11.0 ODBC Driver

   | Driver={SQL Server Native Client 11.0};Server=myServerAddress;

   | Database=myDataBase;Uid=myUsername;Pwd=myPassword;

SQL Server Native Client 10.0 ODBC Driver

   | Driver={SQL Server Native Client 10.0};Server=myServerAddress;

   | Database=myDataBase;Uid=myUsername;Pwd=myPassword;

SQL Native Client 9.0 ODBC Driver

   | Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;

   | Uid=myUsername;Pwd=myPassword;

Microsoft SQL Server ODBC Driver

   | Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;

   | Pwd=myPassword;

0 comments:

Post a Comment