Connecting instructions?

My host sent these instructions, think they will work?

To access your SQL Server you can use your choice of database management software, including Microsoft Access, Visual InterDev, or the SQL Enterprise Manager.

If you are using Microsoft Access or Visual InterDev you will be connecting to the SQL Server via an ODBC connection, which requires you to make a Data Source Name (DSN) on your local computer.

If you have a Microsoft Access database, and you use the Microsoft SQL Upsizing Wizard to export your database into SQL, the Upsizing Wizard will assist you in the process of creating your ODBC connection.

To create a SQL DSN:

1. Log on to your hosting account's control panel at

http://sahcinfo.org/admin 2. Click "Database Connectivity."

3. Choose "Create DSN."

4. Choose "Microsoft SQL Driver" from the Type drop-down list.

5. Enter a name for your DSN in the DSN field. It can be anything you want it to be, such as "Orders" or "MyDatabase." The Filename field is not required for SQL.

6. In the SQL IP Address field, enter the SQL Server name.

7. Enter your SQL user name in the SQL User Name field.

8. Click Submit.

To access the SQL Server using the SQL Enterprise Manager:

1. Open your SQL Enterprise Manager software. This is not supplied by Web.com.

2. Right-click on "SQL Server Group", then select "New SQL Server Registration"

3. Once the dialog box is open, fill in the fields. In the server field, type in your SQL Server name.

4. Type in the login information with your username and password.

5. Once all the information is entered click "Register." This will make contact with our SQL Server, and you will be able to add tables, manipulate your information and work on your database as you wish.

Please note that Web.com Technical Support will only troubleshoot connectivity to the SQL database, and cannot support issues with third-party software.

Web.com has also created a SQL 2000 User Guide to walk you through the process of setting up your account and database connections. To view or print it, go to

http://64.226.3.32/article.asp?article=14689&p=1001

think they will work for what?

those are standard isp type database connection instructions. What is your question exactly?

i would recommend going with Sql Server as opposed to access and a DSN type connection, but thats just my preference.

hth,
mcm

|||Hi Jerry, what's the problem here? I also vote for Enterprise Manager.