How To Creating a Connection to SQL Server Without a Datasource

MORE INFORMATION

   Server Name = SQL1
   Logon User ID = USER
   Logon Password = password
   DATABASE = pubs
				

Creating the Connection Programmatically

1. Open a database in which to store the connection.
2. Enter the following command in the Command window:

         CREATE CONNECTION CONNECT1 CONNSTRING "DRIVER={SQL Server};
            SERVER=SQL1;UID=USER;PWD=password;DATABASE=pubs"
   								

   NOTE: You should enter this command on one line.

Creating the Connection Using the Connection Designer

1. Open a database in which to store the connection.
2. From the File menu, click New.
3. Specify a new connection.
4. In the Connection Designer, select the "Connection String" option button.
5. Enter the following for the Connect String:

         DRIVER={SQL Server};SERVER=SQL1;UID=USER;PWD=password;DATABASE=pubs
   								

6. Close the Connection Designer, and save the connection as CONNECT1.

   ?SQLConnect('CONNECT1')