Skip to main content

Hi,

I created a stored procedure in sql server, and trying to call it from AcuCOBOL but getting this error:

Could not find stored procedure 'sp_test'    42000

It does exist in sql server, with all rights granted.

Calling code looks like this:

EXEC SQL

  DECLARE CURSOR-SP CURSOR FOR

    :ret-code = exec sp_test

END-EXEC

It's a bit confusing as 42000 means acuodbc driver expected, but I'm using the acusql driver, not ODBC


#AcuCobol
#SQLserver

Hi,

I created a stored procedure in sql server, and trying to call it from AcuCOBOL but getting this error:

Could not find stored procedure 'sp_test'    42000

It does exist in sql server, with all rights granted.

Calling code looks like this:

EXEC SQL

  DECLARE CURSOR-SP CURSOR FOR

    :ret-code = exec sp_test

END-EXEC

It's a bit confusing as 42000 means acuodbc driver expected, but I'm using the acusql driver, not ODBC


#AcuCobol
#SQLserver

Good morning, Mr. Bart .

Have you searched this Community for other situations like yours?

For example, there's an article here that may help you.

It's a bit aged, but it gives useful information.

If it does not help, please contact Customer Support, providing information about the version of AcuSQL you're using.

A local engineer will help you with the investigation of the error.

Terms & ConditionsAccessibility statement