SQL Links - Informix Connection

Company

SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index

Borland SQL Links 3.5 READLINK.TXT
Borland SQL Links 4.0 READLINK.TXT
Connection requirements (from SQLINK32.HLP) Configuring IDAPI 32-bit Engine to Informix servers Server requirements Description Database server software Informix version 5.01, 6, or 7.x [ Informix SE is not tested or supported ] Network protocol software TCP/IP or SPX network protocol software compatible with both the database server and the client workstation network protocol. Software and related files that should already be installed and running at the client workstation. Client requirements Description BDE application(s) Supported BDE application, installed as required by the product documentation. Informix PC client software Informix ESQL/C 7.2 (minimum ESQL/C 7.20.TD1) for Windows 95 and NT Requirements 1.5 MB of free disk space. Hardware and operating system that meets the requirements of your Borland desktop product. Access rights (For desktop products installed on the network server only.) If your Borland desktop product is installed on a network file server, make sure your network user account has Read and Write access rights to the product's BDE files, including the BDE Configuration Utility (BDECFG.EXE) and the BDE configuration file (IDAPI.CFG). This directory is modified during SQL Links installation. Network protocol software TCP or SPX network protocol software compatible with both the server network protocol and the client workstation communication driver. Informix database access requirements Accessing the INFORMIX-SQL database requires a valid user identification and password on the Informix server, and at least Read (SELECT) access privileges. If you are a Netware user, you should also belong to the Network group "Informix" on the server where the Informix database resides. To obtain these privileges, see your database administrator. EXAMPLE CONFIGURATION FOR INFORMIX I*NET CLIENT PC: The steps below are examples only. Please consult your Informix server database administrator or IS department for specific information regarding the setup and configuration of your PC with the Informix I*Net client software.) INFORMIX: INSTALL - Run the Informix I*Net setup program. - At the options screen, set the install location to C:\INF32 (optional) - Follow the setup instructions and select or un-select options as needed. - In NT, the install process will add the Informix BIN directory to your path; for Win95, you have to do it yourself and reboot. i.e. (C:\INF32\BIN) - CONFIGURATION: - Run the SETNET32 utility from the INFORMIX group. - SERVER INFORMATION - Informix Server is "myserver" (if you are adding an additional server, just delete the existing name in this box) Host Name is "myserver" (or "myserver.mycompany" or try the IP address: "xxx.xxx.xxx.xxx") ProtocolName is "olsoctcp" (example protocol) Service Name is "sqlexec2" (example port) Click the "Make Default Server" button (optional). Click Apply / OK - HOST INFORMATION - Current Host is "myhost" User Name is "myusername" (optional) Set PassWord Option PassWord is "mypassword" (optional) Click Apply / OK. - ENVIRONMENT - check that INFORMIXSERVER has been set to myserver (optional) - Edit the SERVICES file (NT - \\system32\drivers\etc\services, Win95 - \services) to add the line "sqlexec2 3071/tcp" (example services port setting) TEST THE CONNECTION. - Run the ILOGIN demo utility from the INFORMIX group (or the Informix\bin directory). Choose File|Run and hit the OK button on the Login Parameters screen. If you see a box "Database 'Stores7' not found on the server" (the sample database may not have been installed) - it WORKED! (If error -931 check the SERVICES file for sqlexec2 (example port) entry) - Add an alias in your config utility, and run Database Desktop 7.0 (or above) or run the Database Connection Checker (look for "32-Bit Utilities") to verify that the BDE can connect to your Informix database.