NOTICE: Significant community changes coming soon
The header menu and the home page on our community will be changing soon. Get more information HERE.
Absent Member.
Absent Member.
381 views

Visual COBOL not connecting to Sybase

We are migrating Workbench 4.3 COBOL to Visual COBOL 2.3 using Native Project. The programs have been in production since 2001. We are using the Sybase precompiler COBSQL/COBPRE and have the database connection information in SQL.INI file.  I successfully tested connection to Sybase with ISQL command including a table selection. However VC does not seem to identify the use of SQL.INI for connection.

I am thinking this is a configuration issue. Any thoughts would be appreciated.

The program uses the following syntax. Host variables do get set properly.

           EXEC SQL
              CONNECT :CA-SYB-LOGIN-ID
                 IDENTIFIED BY :CA-SYB-PASSWORD
                 USING :CA-SYB-SERVER-NM
           END-EXEC.
           EXEC SQL
              DECLARE @DBNAME VARCHAR(32)
              SELECT @DBNAME = RTRIM(:CA-SYB-DB-NM)
              USE @DBNAME
           END-EXEC.
                                                                                

0 Likes
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.