[TD 6.0 SP8] Applikation not running with MS SQLServer

[GuentherMe]

Simple SqlCommand in some cases not running with MS SQLServer

if SqlPrepareAndExecute(SqlHeader,sSql)
.. When SqlError
.... Call SqlGetStatementErrorInfo ( SqlHeader, n, s, sState )
.... Return FALSE
.. SqlFetchNext(SqlHeader,nRet)

->
n = -2147467262
s = "Schnittstelle nicht unterstützt; "

[Jeff Luther]

sSql

What's the SQL command, then? And is SqlPrepareAndExecute() what is not running in some cases on MS SS? If not, which other SqlXXX SAL function are you referring to?

OH! Maybe you mean: Call SqlGetStatementErrorInfo ( SqlHeader, n, s, sState )
since you added:
n = -2147467262
s = "Schnittstelle nicht unterstützt; "

German 's' won't help me, but I don't understand what the value 'n' means. According to TD F1 Help SqlGetStatementErrorInfo() the parameter:

Code: Select all

numErrorNumber    Number    The error number.

is an *input* value. You pass in a SQL error number for your Sql Handle 'SqlHeader' and you get returned the error description string.

LAST -- and maybe most important: TD help for SqlGetStatementErrorInfo also states:

Note that this function will work only with Sql Handles created either with SqlCreateStatement (OLEDB connections).

Is this how SqlHeader was connected?