Chapter 1 INTRODUCTION TO SQL SERVER 2000 29
Chapter 1 INTRODUCTION TO SQL SERVER 2000 29 Alias Tab In many organizations, several SQL Servers run simultaneously and each server is configured with different settings. For instance, one server may be running by having the TCP/IP net-library listen to port 1433. Another may be configured to listen to port 37337. Other servers have different settings for their client connections. In this case, you need to set server aliases. With an alias you have a method of assigning server-specific library configurations. The most common use of a server alias is to specify a particular network library to use to communicate with a specific server. In addition, an alias may be used to communicate with a SQL server that listens on a part other than the default. The DB-Library Tab SQL Server can be set up so that data can be retrieved using differ- WARNING Front End Development SQL ent tools. You can write T-SQL code by using the OSQL utility or Server 2000 does not include a the Query Analyzer, or you can also execute your custom-made pro- programming environment for DB- grams. DB-Library is an interface dll to SQL Server. You can define Library for Microsoft Visual Basic. applications using VB or C++ to call and use the functions inside The existing DB-Library for Visual the dll. The dll is an API that front-end programmers can access. Basic applications can run against The DB-Library API has not been enhanced beyond the level SQL Server 2000, but must be of SQL Server version 6.5. All DB-Library applications can work maintained using the software with SQL Server 2000, but only as 6.5-level clients. Features intro development tools from SQL Server duced in SQL Server 2000 and SQL Server version 7.0 are not version 6.5. All development of supported for DB-Library applications. new Visual Basic applications that access SQL Server should use the As SQL Server changes, the DB-Library will also be changed, and Visual Basic data APIs such as therefore you will need to upgrade your DB-Library at times. To ActiveX Data Objects (ADOs) and upgrade, you need to know information regarding the current Remote Data Objects (RDOs). DB-Library (version, size, date), which can be viewed from the DB-Library tab. Future Implementation DB-Library Network Libraries Tab is going to be de-implemented. OLEDB and ODBC, in that order, are the This tab displays the date and version number of all the network preferred interfaces. library files installed on your local system. Whenever files are outdated, you can upgrade then by installing the most recent service pack. You can check the readme file Microsoft provides with the service pack and compare it with the version numbers on this tab. NOTE
For reliable and cheap web hosting services please check tomcat web hosting website.