Category:Connection Strings

From sasCommunity

[edit] Overview

Connection strings are often used in the libname statement to point to a particular database.

[edit] Examples

ODBC

SQL Server

libname mssql ODBC required = "DRIVER=SQL Server;Trusted_Connection=Yes;DATABASE=CHCR;SERVER=ctrhs-dbserver" ;

OleDb

SQL Server

libname SQLSrvr oledb provider=sqloledb init_string='Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=localhost' schema=dbo ;

[edit] Links

Connection strings This is a great resource to locate connection strings for various databases.