Sql 2000 On A Net Ware Server example essay topic

Pervasive. SQL 2000 (Service Pack 1) September 1999 GENERAL RELEASE README. TXT Contents 1. General Information 2. Net Ware Specific Notes 3. New Features 4.

Installation Notes 5. Documentation Updates 6. Known Issues 7. Technical Support 8. Notices / Disclaimer 1. General InformationOverviewThis document provides information for all customers who have purchased this release of Pervasive.

SQL 2000. Supported Operating Systems Pervasive. SQL 2000 client / server and 32-bit workstation engines are available for: Windows NT 4.0 (Service packs 1-5) Windows 95 (Service Pack 1) Windows 98 (first and second edition) Net Ware 3.2, 4.11 and up, and 5.0 For a listing of all files in this release, see the file: PVSWDOCMANIFEST. TXT once the product is installed. 2. Net Ware Specific Notes The information contained in this section is specific to Net Ware platforms only.

However, you should read this entire read me document for other important Pervasive. SQL 2000 information that may pertain to you as well. IMPORTANT NOTE If you are installing on a Net Ware 4. x or 5. x server with NDS you MUST have your Bindery Context correctly set to the NDS context in which your Pervasive. SQL 2000 server resides. By default, this will be set correctly when you install Net Ware 4. x or 5. x, but it can be changed using the following command in either STARTUP. NCF or AUTO EXEC.

NCF: SET BINDERY CONTEXT = If you set an invalid context, or if you execute it with NULLs in the value, Pervasive. SQL 2000 will not be able to authenticate you in the NDS tree for engine configuration and monitoring. If you need to set multiple bindery contexts for the Net Ware server, the context containing the Pervasive. SQL 2000 server must be first in the list.

NOVELL NETWARE RIGHTS FOR PERVASIVE. SQL 2000: RIGHTS REQUIRED TO INSTALL: To install Pervasive. SQL 2000 on a Net Ware server you should be an administrator of the server object on which you are installing the database. Just having supervisor rights is not adequate.

This will allow you to configure, monitor, and set up DSNs for the server after installation. However, you can do an installation if you just have read / write rights to the root of the server, but you will NOT be allowed to configure, monitor, and add DSNs. SIMPLEST METHOD TO AUTHORIZE USERS TO ADMINISTER DATABASES: All other users that are administrators for the Net Ware server object where Pervasive. SQL 2000 is installed will have rights to perform administrative functions on the database too. This means the user must have Supervisor rights to the NDS Server object itself, not just Supervisor rights to the SYS: volume. This implementation is the easiest to set up and administer and is adequate if your users can be administrators for both the Net Ware server and the Pervasive.

SQL 2000 database. ALTERNATIVE AND MORE RESTRICTIVE METHOD TO AUTHORIZE USERS TO ADMINISTER DATABASES: After installation you can optionally add a group named Pervasive Admin and add members who have the right to administer only the database engine without giving them full administrative rights on the entire server. In order to add this group and add users to it, you must have the proper Novell Net Ware rights enforced by Net Ware to add objects into the NDS tree on Net Ware 4. x or later or create groups on Net Ware 3.2. On Net Ware 4. x or later, the Pervasive Admin group object must be set up in the same NDS container as the server (or servers) with Pervasive. SQL 2000 installed.

If all your Pervasive. SQL 2000 servers are installed at the same level in your NDS tree, then only one Pervasive Admin group is required for all of them. If you have multiple Pervasive. SQL 2000 servers at varying levels in your NDS tree, you must set up multiple Pervasive Admin groups, one for each NDS context level running a Pervasive. SQL engine. You do not need to have the same member list for each Pervasive Admin group.

On Net Ware 3.2, the group Pervasive Admin must be set up on the same server that has Pervasive. SQL 2000 installed. If you have additional questions on this topic or would like to review examples of NDS trees and user rights, please refer to the section 'Additional Information on Pervasive Admin and NDS' in the HTML file: web REQUIRED FOR CLIENT CONNECTIONS AFTER INSTALL: The Net Ware relational engine can accept connections from remote clients using only 1 homogeneous protocol at a time. Your NetWare Pervasive. SQL 2000 ODBC engine is by default configured to accept TCP / IP connections only. If you do not have an entry in your client's'hosts' file, or in your DNS server's tables, for the Net Ware server you are connecting to, you may receive connect errors such as a status 3103.

If you want to connect using IP, you must do one of the following: Add the NW server's name / address into your DNS server's tables; Add the NW server's name / address into your local hosts file (32 for NT, windows hosts for 95/98); or Specify the actual IP address in the client DSN's 'Server Address " field. If you want to connect using SPX, you must either: Use Pervasive Control Center Configuration Utility to change the SQL engine's Supported Protocols; or Edit the file in says: . in on your Net Ware server and set: [SQL Manager] MgrUseTransport = SPX OTHER NETWARE PLATFORM NOTES Net Ware 3. x only: The Net Ware Loadable Module TLI. NLM must be loaded on the server before starting Pervasive. SQL 2000, in order for the products to function correctly.

Later versions of Net Ware should have loaded this module automatically; however, in any version of Net Ware, the module must be loaded for Pervasive. SQL 2000 to function correctly. All versions of Net Ware: Before starting Pervasive. SQL 2000, the NetWare Loadable Module appropriate to the communication protocol being used must be loaded before starting Pervasive.

SQL 2000. If the SPX communication protocol is being used, then SPX. SQL 2000. If the TCP / IP protocol (the default) is being used, then TCP / IP must be correctly configured on the server before starting Pervasive. SQL 2000.

Prior to installing Pervasive. SQL 2000, any existing Pervasive. SQL applications must be stopped on the client machines, and the Pervasive. SQL server engine must be stopped by performing the SQLSTOPand BSTOP commands from the Net Ware server console.

(Note: SQL STOP is the command entered on the Net Ware server console to stop the relational engine in previous versions of Pervasive. SQL. This command has changed to MGRSTOP in Pervasive. SQL 2000.) Please note that the command MGRSTOP may take up to a minute to unload the SQL Connection Manager.

This pause does not indicate that your system is hung, only that this module takes some time to unload. When creating an Engine DSN on a Net Ware 4. x or 5.0 server, the " Browse' button on the 'Create Database' dialog box may set up the Dictionary and Data File Locations incorrectly. This may happen if you are running the ODBC Administrator utility from a Windows 95 client using the Microsoft Service for NDS. If the locations a repopulated with a directory path starting '$NDS', you must manually overwrite them with the target server name, volume name and directory in this format: SERVER VOLUME: PATH For example, MYSERVERSYS: PVSWDEMODATANote that the ':' after the volume name is required.

This works fine if you are using the Novell client. #18371 The Net Ware Micro Kernel will now automatically unlink from BTRIEVE. NLM when you run BSTOP. It will prompt you before it does this, just to be sure you have closed all connections to the server. You must realize that doing this forced unload of the MicroKernelcan cause errors to be returned to any applications using it. They may get status 3's or 20's.

Because the Netware Operating System uses BTRIEVE. NLM, you will not be able to unload BTRIEVE. NLM without taking down the server. This just unloads NWMKDE. NLM. But this unload will allow new configuration settings to take effect when theMicroKernel is brought back up.

3. New Features For detailed information about all the New Features and Enhancements for Pervasive. SQL 2000, see What's New in Pervasive. SQL 2000, available in the Pervasive. SQL 2000 Documentation online help file, once the product is installed. Tech-in-the-Box The Pervasive.

SQL 2000 Tech-in-the-Box is an interactive tour of some of the new Pervasive. SQL 2000 features. System requirements for viewing the Tech-in-the-Box are: Win 32 operating system (Windows 95/98/NT) A sound card 32 MB of RAM 256 color video display The Tech-in-the-Box will run directly from the CD, so you do not need to install it on your computer. A shortcut will be installed if you ran the install from the CD. You can also run and view the file by launching the executable 'TechInTheBox. eye' on the CD in the directory TECH BOX.

4. Installation Notes BEFORE INSTALLING, READ THIS SECTION AND REVIEW 'KNOWN ISSUES' FOR INSTALLATION, LATER IN THIS DOCUMENT. Notes for Existing Pervasive Customers Pervasive IDS Server will not work after installing onto a Pervasive. SQL 2000 server until you have made some minor modifications. If you want to run these 2 products together, search the Pervasive Knowledge base for information on how to set this up.

If you need further help or information call Pervasive Technical Support. If you have any existing Pervasive products running on your PC, you should close them completely down before installing Pervasive. SQL 2000. The install will attempt to shut down the database services on NT, but if there are any active connections, it may fail. If you have Pervasive. SQL 2000 Beta or Technology Preview versions installed on your PC you must remove them before installing this version.

The best and most thorough way to do this is by running the Cleanup program that is part of your Beta CD image. This removes all components found on the machine, including registry entries and counts. If you choose to uninstall previous versions of Pervasive. SQL prior to installing Pervasive. SQL 2000 you should first uninstall your old Pervasive. SQL DSNs.

Failure to do so will result in an inability to remove those DSNs after uninstalling. Notes for All Pervasive Customers Note: All ODBC applications and ODBC services (e.g. SNMP) should be terminated before Install is attempted. If Install indicates that you need to 'free locked ODBC files', exit Install, reboot your system and attempt Install again. If Install continues to detect locked ODBC files, call Pervasive Technical support. 1. Read Chapter 2 (Installation) of the Pervasive.

SQL 2000 Getting Started to make sure you have the correct hardware configuration and to familiarize yourself with the installation process. 2. Run the setup program for the Server, Client, or Workstation components. o You may encounter installation failures (insufficient disk space) if your system is low on virtual memory or if the directory specified by the %TEMP% environment variable has very limited disk space available. Solution: Quit all programs except the installation. Makes ure that the file system containing your %TEMP% folder has at least 10 MB of free disk space, and your target installation directory has at least the amount of free space shown during the installation procedure. If the failed installation created an Uninstall program item, run it before re-starting the installation.

Note: if you are using a 'temporary' Windows swap file (seethe Virtual Memory section of the 'System' controls in the Windows Control Panel), the required free space must still be available after the swap file has consumed the maximum amount of disk space that it is allowed. A temporary swap file may be small at startup, but is allowed to grow to its maximum size setting. What appears as 'free's pace may actually be reserved by the temporary swap file. 5. Documentation Updates This section provides corrections or additions to the documentation shipped with the product.

You may encounter Gps in Win hlp 32. eye if you attempt to print topics of Windows help files from the Contents menu. Workaround: None. #14056 6. Known Issues The most noteworthy issues are listed here. An up to date list of additional issues can be found on the Pervasive web site: web If you are an existing Pervasive customer upgrading a Scalable SQL application, be sure and see the section titled BACKWARDS COMPATIBILITY ISSUES FOR SRDE in the above referenced html file on the Pervasive website. Also see READ DOS.

TXT installed with this product. This document will provide more information on configuring the DOS client components. GENERAL Using SPX as a transport protocol to the SQL Relational Database Engine (SRDE) requires that the client workstation be attached to at least one Net Ware server. This is true for both the Net Ware SRDE and the Windows NT SRDE. If you plan to use Pervasive's Java or ActiveX interfaces with Pervasive. SQL 2000, you must upgrade these interfaces to use the latest features shipping in the Pervasive.

SQL 2000 SDK, available from Pervasive Software in July 1999. The older interfaces will not recognize new features of Pervasive. SQL 2000 like true null support and multiple variable length columns but should continue to work with old data tables that do not exercise these new options. If your DB Names. cf g file is read-only, you will not be able to add DSNs or update or add named databases. Workaround: Remove the read-only flag. #18715 If you stop your Pervasive database engine while database utilities are running and connected to the engine on the same machine, you will not be able to restart the database until you have closed these utilities.

If you receive errors when creating tables that are named greater than 8 characters, first make sure that both the client and server you a reusing can support greater than 8.3 filenames. If you develop an application with Pervasive Tango you must use the default setting to put double quotes around all keywords or reserved words used in a table definition statement. You may experience slow responses running the Pervasive. SQL 2000 NT Server on a PC or laptop that is not connected to a network. Workaround: Bring up the Pervasive Control Center and double-click on the Configuration Utility. Select Expand Server Settings, and then chose Communications Protocols.

The second setting is for Supported Protocols. Microsoft SPX II will be in the Selected Column. Highlight it and move it to the Available side and click Apply. INSTALL You will not be able to read online documentation on Windows 3. x until you install the 16 bit Acrobat reader.

The Pervasive. SQL 2000 install does not do this for you. The 16 bit Acrobat Reader is located at: on the Net Ware and Windows NT server CDs. If you do not have any icons for the Pervasive. SQL 2000 utilities after installing you may need to shut down the machine and restart the OS. This is related to the version of Windows Explorer and / or Active Desktop you have on your PC.

#18306 UTILITIES SQL Data Manager IMPORTANT NOTE: It is highly recommended that you backup all your files before you perform functions through SQL Data Manager such a salter and create table, null conversion, or import of an external file. This powerful tool is designed to give you the ability to modify your database schema and data. If you inadvertently set the options incorrectly or enter incorrect data you could change your files in an irreversible manner. Full recovery will be possible if you have performed a backup.

SQL Data Manager Utility will not be able to connect locally to a Pervasive. SQL 2000 NT server if no user count licenses are available. #18208 The default statement separator in SQL Data Manger is the '#'character. This can be changed to the ';' by selecting Tools - Properties.

#17574 Some of the shortcut keys designed specially for SQL Data Manager do not work. These include Ctrl-F to bring up the FIND window; Ctrl-Ato run all statements; Activate Database, table, column, or template; and Activate SQL Text or Results windows. Some integer data fields will accept values outside of the range for that data type in the display grid. These data types are: , u integer, , and integer. Inserting a number too large or too small will result in the binary value being pruned internally to fit the column size.

You must be careful when entering values in these fields to not exceed the acceptable range. Entering a SQL query that does this will fail with an appropriate error message. #18620 The Table Statistics tool allows a user to manipulate the definitions of an existing data table in one of two modes 'Linked' and " Unlinked'. Linked mode will cause any changes in the database table definitions to replicate the changes in the actual data file. Unlinked mode allows the user to change the database definitions to fit a table data file without altering the contents of the file.

' Unlinked' mode is the default. Table modification modes are for experienced developers and tech support. Pervasive Control Center Before you can view your local user DSNs through Pervasive Control Center's name space you must add at least one System DSN on your local machine. Also, the default setting in PCC is to not display Client Engine DSNs used for Client / Server connections.

If you want your local client DSNs listed in your name space you must change the setting for this under View - Options. #18173 If one of the servers in your name space is down or unresponsive, several utilities that check for the existence of available database DSNs will respond very slowly. To improve response time, simply right click on the problem system in the name space and select disconnect until the network availability improves. Other Utilities User count licenses in use in the Monitor utility for an NT server tracks only applications accessing the Pervasive.

SQL 2000 NT engines through the transactional interface. It does not show the relational interface users. They are being tracked internally by the database. So, if you get an error that you are out of licenses, you cannot rely on the number in Monitor if you have ODBC applications accessing the database.

This is not the case when monitoring a Netware server engine. Both relational and transactional are monitored in the total licenses in use. #18658 If you try to connect with the Monitor utility to a server that is running the transactional service but not the relational service, it will take a long time to connect. This is because it is waiting for a time-out period to elapse for the relational service to respond.

#18256 TRANSACTIONAL ENGINE (MODE) When using the Workgroup Engine to process remote databases, applications may experience delays on the initial database connection as the client requester attempts to connect on all supported protocols to a server engine before starting a work group engine. Performance maybe improved by configuring the client requester to use a single supported protocol appropriate to your network. If you are using NetBIOS to access the work group engine running on a Windows NT 4 workstation or server, you must have Windows NT 4 Service Pack 4 or later installed. NetBIOS on earlier versions of Windows NT 4 may result in dropped connections to the work group engine.

If you a rerunning NetBIOS on Windows 95 you must have Service Pack 1 and Winsock II. The most recent version can be downloaded from the Microsoft website at: web / w 95 sockets 2/default. as pSQL RELATIONAL ENGINE (SRDE) The ODBC interface relies on the ODBC cursor library to provide support for SQLExtendedFetch and Row set Scrolling when connecting via a front-end application such as Microsoft Visual Basic. The connect string property should be set to 'Use ODBC' or 'UseIfNeeded'. See the Microsoft documentation for more information. Schema changes are not allowed from within a stored procedure. A'syntax unsupported' error is returned rather than a 'driver not capable' error.

Limited error detection / checking is performed when Stored Procedures and Triggers are created. Therefore, it is possible to create a Stored Procedure or Trigger that will not execute properly. Full SQL level checking and validation is performed when they are executed. Income cases the SP or Trigger will return only error's 1000' rather than a more detailed error to be used in debugging.

Repeated relational queries from a Delphi application may exhaustMicroKernel resources, resulting in Btrieve error 87. Workaround: Recycle the relational and transactional services. #15709 Timestamp with decimal is documented, but NOT supported in this release. #18496 GRANT ALL on to User does not give that user CREATE TABLErights. It is necessary to specifically do a GRANT CREATETAB to Users well as a GRANT ALL before they can create tables. Even though GRANT ALL gives Reference Rights they cannot be utilized without CREATE TABLE rights.

This is expected behavior. Also, only the " Master' can grant rights to users. The user that created the table does not have grant rights. It is necessary to specifically do a GRANT CREATETAB to User as well as a GRANT ALL before they can create tables. Subtraction on time stamp data types does not work correctly. Example: create table time 1 (c 1 time stamp, c 2 time stamp) insert into time 1 values ('1999-09-26 00: 00: 00', '1999-09-2500: 00: 01') select c 1-c 2 from time 1 Result 1 Expected Incremental Values#17495 While huge chunks of data (on the order of MBs) can be inserted or columns, it is recommended that you insert data in chunks of.