Please can you help me? I am New to SQL and come from an Access background and would like to known, How can you get SQL 6.5 to use a ODBC Data Source like what Access Does?

Many Thanks

-- Anonymous, September 27, 1999

Answers

Tony,

I presume you are asking how to create a Data Source that points to a SQL Server 6.5 database.

In that case, at the client machine:

1. Open the Control Panel.

2. Double click on the ODBC Data Sources icon.

3. Select the User DSN tab.

4. Click on the Add... button.

5. On the Create New Data Source dialog, scroll down, select the SQL Server driver, and click the Finish button.

6. Fill out the boxes for the rest of the creation dialog. If you select the "With SQL Server authentication" option you will be prompted for a Login ID and password.

If this was not quite the question you asked, please post again.

Hope this helps,

Eric

-- Anonymous, September 27, 1999