Cobol - Connecting to SQL Server w/ NT authentication

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Connecting to SQL Server w/ NT authentication

joshsackett

2005-02-04, 3:55 pm

Hi,
I have an old old old version of MicroFocus COBOL that uses ESQL and
DB-LIB to connect to SQL Server. Currently the username and password is
hard-coded in each .CBL build file and I want to change to NT
authentication.

This version cannot point to an ODBC or else I would do it that way. I
tried stripping out the username parameter and nothing was passed
through - SQL error:
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection."

Is there a switch to use within the COBOL program to tell it to pick up
the current user's NT information or am I stuck w/ SQL authentication
only?

Thanks,
Josh

Sponsored Links