SqlCreateStatement - No Connection to database possible

[MajorWoody]

Hi,

we have working code to connect to a database (oracle/tns or sql server/odbc) under td 7.1.1. Now we updated to 7.1.2, same code, same configuration but we get the sql error 999 on SqlCreateStatement:

Code: Select all

On SAM_AppStartup
	Set SqlDatabase = 'db'
	Set SqlUser = 'USER'
	Set SqlPassword = 'PASSWORD'
	If SqlCreateSession( hSession, STRING_Null )
		Call SqlCreateStatement( hSession, hSql )
		Call SalMessageBox( 'all fine', 'Info', MB_IconInformation|MB_Ok )
On SAM_SqlError
	Call SqlExtractArgs( wParam, lParam, hSqlError, nSqlError, nErrorPos )
	Call SalMessageBox( 'Error: ' || SalNumberToStrX( nSqlError, 0 ), 'Error', MB_IconHand|MB_Ok )

Can anyone reproduce this problem?

Andreas

[memic]

I can confirm, your code produces Error 999. But a normal SqlConnect() does work.

[MajorWoody]

Thanks for testing. I opened a ticket at opentext support.

[MajorWoody]

For anyone who runs into this issue, opentext delivered a workaround, by keeping sqlbapw10.dll from version 7.1.1 in the runtime. This workaround works for me.