The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

(OLE DB-connection-arguments) specifies the data source-specific arguments that PROC SQL needs in order to connect to the data source, such as a relational DBMS. These arguments must be enclosed in ...

To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name and endpoint (such as a DNS name or IP address). For this article, we're only ...