Castelle FAXPRESS PREMIER, Administrator'S Manual

Page: 566 / 639

Admin Guide > 32-Bit ODBC Data Sources
550
Select SQL Server.
3. The next screen will display the new data source. Click Finish to complete this por-
tion and proceed to configuring the connection.
4. The next wizard prompts you to configure the connect string.
For the new DSN, enter:
„
Name: The name of your new DSN.
„
Description: This is an optional field.
„
Server: The is the name of the SQL server.
Click Next>.
5. Select either Windows NT or SQL server authentication method from the next
screen.
Note: The method you select will depend on how the database is configure.
Check with your Database Administrator if you are not sure.
„
With Windows NT authorization using the network login. If the authen-
tication is by NT, then the current user logged into the workstation is used for
authentication and the UserID and password fields near the bottom of this
screen are grayed out.
„
With SQL Server authorization using a loginID and password entered
by the user. If the authentication is by SQL server, then a user name and
password are required in the text boxes near the bottom of this screen.
Note: In either case, the user must have permission to create tables on the
database.
„
Click the Client Configuration button and select the appropriate protocol.
6. The next screen allows you to specify the default database and when to cleanup
temporary stored procedures.
a. Select
Change the Default Database To and select the your database from
the scroll down list.
For the rest of the setting in this dialog box, we recommend that you select the
following:
b. Select
Create temporary stored procedures for prepared SQL state-
ments and drop the stored procedures.
c. Select When you disconnect and as appropriate while you are connect-