To connect to you database and start working on it, you will need:
a. SQL Server IP Address
b. SQL Server UserID and Password
c. SQL Server database Name
Step 1.
Click on Start / Settings / Control Panel / ODBC (32 bit).
Step 2.
Click on System DSN tab and then click on the Add button
Step 3.
Highlight SQL Server and click on the Finish Button
Step 4.
Enter the DSN name you wish to use and the server IP as the server
name.
b>Step 5.
Type your Login ID and Password, and click on Client Configuration
Step 6.
Click on "Client Configuration", select TCP/IP. Then click
on OK button.
Step 7.
Select "change the default database to:" Scroll down and
select your database. Click on Next Button.
Step 8.
Click Finsih.
Step 9.
Click on Test Data Source, to make sure it is setup correctly.
| |
|
|
