Connecting to an SQL database can be accomplished using a variety of different methods and tools. Section one will address how you may use Visual Interdev and ASP, section two will provide a step by step tutorial on how to use the Microsoft SQL Server 7.0 client tool, Enterprise Manager, and section three provides a step by step tutorial on how to use Access 2000 to connect to and update your SQL Server database.
1. You may make use of Visual Basic in ASP scripts or Perl scripts using WIN32::ODBC that is located in your Web site to issue SQL commands that will access and make updates to your database. You may also use Visual Interdev, a powerful and useful developer’s tool, to connect directly to the SQL Server database or design ASP pages that can perform interaction with your SQL Server database. ASP or Perl scripts can be written that will retrieve, add, delete and update information in the various tables of your database. We support the use of DSN and DSNless connections to connect to your SQL Server database, and when using system DSN connection, a connection is established via the ODBC software installed in the Microsoft SQL server. Helpful links on how to use ASP to interact with your MS SQL database can be found in our links section below!
2. You may also connect your computer to your SQL Server using SQL Enterprise Manager or a transactional SQL client, such as Query Analyzer, to manage your SQL Server database. These client side tools are part of Microsoft’s SQL Server 7.0 distribution an included on the SQL Server distribution. A trial version of Microsoft SQL server 7.0 can be downloaded at the Microsoft site, or you may purchase the trial CD for a small fee. Both of these trial versions of SQL Server contain the Enterprise Manager. Instructions on how to use this tool should be included with the Microsoft documentation, however we have added step by step, screen shot instructions on how to use SQL Enterprise Manager to connect to your MS SQL database below.
Before you use the SQL Enterprise Manager to connect to your SQL database, you will need to set up a user DSN on your local computer.
Once you have installed Microsoft SQL Server 7.0 on your NT machine using either the Microsoft SQL server 7.0 download files or the trial CD, launch the SQL Enterprise Manager by clicking on Start -> Programs -> Microsoft SQL Server 7.0 Enterprise Manager.
Below is an empty SQL Server Enterprise Manager screen. Begin by registering a new SQL Server by right-clicking on “Microsoft SQL Servers” and selecting “New SQL Server Registration…”.
The following window will be generated to launch the wizard that will help you set up a connection profile to your SQL database. Click “Next” to proceed.
Under “Available servers” select sql1.onlinecorp.com and click “Add” so that sq1.onlinecorp.com is moved to the “Added servers” column on the right as shown below. Click “Next”.
Select the bottom radio button as shown below and then click “Next”.
Type in your MS SQL user account username and password in the fields below and click “Next”.
Accept the dafault settings as shown below and click “Next”.
Click on “Finish” to complete the set up of your connection to your SQL database on sql1.onlinecorp.com
Click “Close” to officially end the wizard set up process.
You should be returned to the following screen. Expand the “Microsoft SQL servers” and “SQL Server Group” icons.
Double click on “SQL1.ONLINECORP” icon.
Click on “Yes” when the following window is generated to connect to the SQL server.
You should now be connected to the SQL Server and able to work on your SQL database using the Enterprise Manager tools. You will be able to find your database by expanding the “Databases” folder as shown below.
3. Another way to connect to and administer your SQL Server database is through Microsoft Acesss 2000. Additional information on using Access to manage your Access database can be found at the Microsoft site, though we have included some step by step, screen shot instructions below for your convenience.
Begin by launching Access 2000 and clicking on File à New to generate the following window. Click on “Project (New Database)” to create a new MS Access 2000 database project.
The following window will be generated to prompt you to save the project in a directory on your local drive. Choose a directory and file name and click “Create”.
If the “Microsoft SQL Server Database Wizard” pops up (shown below), cancel the window – it will attempt to create a new database on the SQL server. This is not necessary since we have already done this for you. Cancel the screen below.
Once the wizard is cancelled, an empty Access project will be shown below. Click on File à Connection…
In the window that is generated below, type the SQL Server name, your user account username and password (uncheck the “Blank password” check box), and the name of your database. Click on the “Test Connection” button to verify your connectivity. Once the connectivity is verified, click “OK” on the window below.
You are now connected to your MS SQL Server database on sql1.burlee.com. From the interface below you can manage your SQL Server database by creating tables, indexes, modifying content and the data stored within your database tables. For additional information on database management, please visit http://www.microsoft.com/access.