SQL CLI HELP! I've got 2 SQLConnect calls fighting with each other -- MIDRANGE-L

Subject: SQL CLI HELP! I've got 2 SQLConnect calls fighting with each other
From: James Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Date: Fri, 02 May 2008 16:51:36 -0800
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

I have 2 programs that have the following SQLConnect call

SQL_SUCCESS = SQLConnect( hdbc:'*LOCAL'
:SQL_NTS :*null
:SQL_NTS :*null:SQL_NTS)

where "hdbc" is declared as "10I 0 inz"

Either program works fine by itself, but when I run both programs in the same job, only the SQLConnect in the first program executed works. The other program fails at that point, with an SQL0950:

Message . . . . : Relational database not in relational database directory.
Cause . . . . . : A request for relational database was made. However the relational database name was not found in the relational database directory.

Clearly, the two calls are fighting with each other.

Why, and what do I do about it?

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: SQL CLI HELP! I've got 2 SQLConnect calls fighting with each other , Scott Klement

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.