5.2 and Sql Server

[FRBhote]

My application which runs fine in CTD 2.1 with Sql Server, does not accept long sql statements in TD 5.2.

What could the problem be?

Attached is the screen with the error. When I reduce the length of the statement to less than 1000 characters it works fine.

err52.JPG

[Jeff Luther]

Take a look at your SQL.INI file -- old 2.1 and new versions -- and see what the 'outmessage' value is set to. Here's a quote from sqldba.pdf:

outmessage
Sets the size (in bytes) of the output message buffer... This keyword is optional. Configure this keyword in any client router section of SQL.INI, except for Windows NT.
Default value The default value is 1000 bytes.

There's also SAL function for changing this: bOk = SqlSetOutMessage ( hSql, nSize ) so try changing that after you connect hSql.

[FRBhote]

Any help with this?

[ROUX Ch.]

Hello,

This error is known : DEFECT: TD-17834 "A SQL query passed to SqlPrepare longer than about 1,020 chars. fails with SQL Error #0 error".

you must install the pach EMP5437 for gupta 5.2 Sp5. This patch updates the following resources :
cbi52.exe, cdlli52.dll, gtlsi52.dll, ProfUIS283u_td.dll, ProfUIS283u-RDE.dll and sqlbapw.dll.

If you need this EMP patch see this forum msg: viewtopic.php?f=1&t=7129
for info. on how to request the patch. Be sure to also include this forum thread URL + details about the EMP patch/fix that you want.

BTW, ROUX, you'd already posted a msg. about this here: viewtopic.php?f=40&t=8820
and I gave you the same info. about getting EMP5427.


Best Regards.

Roux Ch.

[FRBhote]

Thanks a lot - but How do I access that post - the link is missing. Can you please re-post with the link?

[Jeff Luther]

You can always just copy/paste in that "viewtopic.php?f=40&t=8820" link to the full "support.gupta..." root in your browser to get the full link, like this:
support.guptatechnologies.com/supportfo ... =40&t=8820

[ROUX Ch.]

hello,

sorry, the links are :

https://support.guptatechnologies.com/supportforum/viewtopic.php?f=1&t=7129

and

https://support.guptatechnologies.com/supportforum/viewtopic.php?f=40&t=8820


Bye,

Roux ch.

[FRBhote]

Thanks.