Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Feb 27, 1997

16 and 32 Bit Server Access

Question:
I run 16- and 32-bit applications on my Windows 95 laptop and they both need to access the same databases. Is there any way to allow the 16- and 32-bit applications to talk to the same local SQLBase server?

Answer:
Before SQLBase for Windows 95 became available, the local 16-bit SQLBase engines (DBWSERVR.EXE and DBWINDOW.EXE) were fairly straightforward and easy to get up and running. The database engines and the applications were both 16-bit and they were aware of each other in that the server would launch automatically when needed.

With SQLBase for Windows 95 (DBNT1SV.EXE), there are a few more considerations to take into account:

  • SQLBase for Windows 95 is a 32-bit server, which means it can address more memory that was possible with the 16-bit engines.

  • 16-bit applications can only connect to SQLBase for Windows 95 via the 16-bit WinSock TCP/IP DLLs.

  • SQLBase for Windows 95 does not launch automatically upon database or server connection requests from 16-bit client applications.
Configuring TCP/IP for Windows 95 on a machine that does not have any network adapters can be tricky and is not altogether straightforward. The steps listed below are designed to help you install and configure TCP/IP for Windows 95 so that the SQLBase Server for Windows 95 can be accessed by both 16- and 32-bit applications.

There are several ways to do this operation, but the steps listed in this document are the most streamlined based on the information available at the time this document was published.

If you have already installed TCP/IP on your Windows 95 machine and it is working properly, use the steps in this section to configure SQLBase. The following steps assume you are familiar with SQLEdit; (if you aren't, please refer to the SQLBase Starter Guide):

  1. Use SQLEdit to configure the Windows 95 Server ([dbnt1sv]) to support both Anonymous Pipes (SQLAPIPE.DLL) for 32-bit client applications and WinSock TCP/IP (SQLWSOCK.DLL) for 16-bit client applications. Additionally, set the server name to be "LOCAL32".

  2. Use SQLEdit to configure the Windows 95 client ([win32client]) to connect with Anonymous Pipes.

  3. Use SQLEdit to configure the Windows 3.X client ([winclient]) to connect with TCP/IP (WinSock). Additionally, you need to set the serverpath parameter value to "LOCAL32,localhost/*".

  4. Launch SQLBase Server for Windows 95.

  5. Now you are ready to connect to the server from either the 16- or 32-bit versions of SQLTalk for Windows.

If you have not installed TCP/IP, use the following steps to configure TCP/IP for Windows 95:

  1. From the Network dialog (accessed via the Control Panel), press the Add button. The Select Network Component Type dialog is displayed.

  2. Select Network Component Type; select Protocol and press the Add button. The Select Network Protocol dialog is displayed.

  3. Select Network Protocol; select Microsoft as the Manufacturer and TCP/IP as the Network Protocol and press the OK button. The Select Device dialog is displayed.

  4. Select Device; If you don't have a NIC in your PC, select Microsoft as the Manufacturer and Dial-Up Adapter as the Model. Otherwise, select the Manufacturer and Model for the NIC that is installed and press the OK button. The Network dialog is displayed again with the currently installed network components.

  5. Network; If you are performing this install so that you can communicate with a local 32-bit SQLBase engine, it is important to note that the only components that are required are Dial-Up Adapter and TCP/IP. To remove unnecessary network components, select any of the components you wish to exclude and press the Remove button.

  6. Network; Once you are satisfied with the installed network components, press the OK button. At this point you may be prompted to insert the Windows 95 distribution media. Once the changes have been made, the System Settings Change dialog will be displayed.

  7. System Settings Change; Pressing the Yes button will restart your computer with the new network settings.

  8. After the computer resets, complete the SQLBase and SQLTalk configuration steps as listed above.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date