SqlCreateStatement - No Connection to database possible

Report SqlBase bugs and possible workarounds.
MajorWoody
Germany
Posts: 41
Joined: 17 Jan 2019, 12:02
Location: Berlin, Germany

SqlCreateStatement - No Connection to database possible

Post by MajorWoody » 20 Mar 2019, 20:28

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
Germany
Posts: 59
Joined: 07 Mar 2017, 08:51
Location: Germany

Re: SqlCreateStatement - No Connection to database possible

Post by memic » 21 Mar 2019, 08:06

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

MajorWoody
Germany
Posts: 41
Joined: 17 Jan 2019, 12:02
Location: Berlin, Germany

Re: SqlCreateStatement - No Connection to database possible

Post by MajorWoody » 21 Mar 2019, 11:13

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

MajorWoody
Germany
Posts: 41
Joined: 17 Jan 2019, 12:02
Location: Berlin, Germany

Re: SqlCreateStatement - No Connection to database possible

Post by MajorWoody » 24 Mar 2019, 11:03

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.

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests