[TD 6.0 SP8] Applikation not running with MS SQLServer

General discussion forum about all databases other than SqlBase.
GuentherMe

[TD 6.0 SP8] Applikation not running with MS SQLServer

Post by GuentherMe » 23 Jan 2013, 21:27

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

Re: [TD 6.0 SP8] Applikation not running with MS SQLServer

Post by Jeff Luther » 24 Jan 2013, 00:46

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?

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 5 guests