|
-
Select
Start -> Settings -> Control Panel and Double-click the ODBC
Data Sources (32 - bit). This will enable you to create a new data
source so that your SSW database can connect
to SQL Server.
-
Click the tab named "System DSN", and click the "Add" button
-
Select the SQL Server Driver in the "Create New
Data Source" window and click the "Finish" button.
-
In
the first "Microsoft SQL Server DSN Configuration" Page, Enter the Data
as above. But ask your System Administrator for the name of the server
where the SQL Server database resides, and input this into the Server
field if it is not listed in the drop-down list. click the "Next"
button.
-
Enter
the information as below - selecting the option button "With Windows NT
authentication using the Network Login ID"
-
Ensure
that the information is entered in as below, and click the
"Finish" button.
-
Enter the information as below. However, you will
need to ask the System Administrator about the name of the Database on
the Server, and select this option in the drop-downbox titled "Change
the default database to:". click the "Next" button.
-
You
will then click the "Test Data Source" button on this screen, where it
will say "Test completed successfully. Click OK and OK again. You have
now successfully enabled your computer for connectivity to SQL Server.
- Start up Tennis PRO! or TimePRO! and it will detect that you need to
link to the database.
- Select SQL Server Option button if it is not already selected.
- Enter the information as above in to the "Enter DSN:" text
box.
- click the open button on the attachment screen, and you will be presented
with a dialog box entitled "Data Link Properties" as below. Select the
"Microsoft OLE DB Provider for SQL Server" as highlighted below. Click the "Next button".
-
Enter
the server name as per step 4 into the "1. Select or enter a server
name:" drop down list (as seen below). Also select the Database Name as
per step 7 in the Select
the database on the server: drop-down list.
-
Click
"Test Connection" button, and it will respond with "TEST COMPLETED
SUCCESSFULLY". click the "OK" button.
-
Click
the "Link to Database" button on the main attachment screen. The
program will then proceed to link the tables to your
computer.
|
