5.2 and Sql Server

General discussion forum about all databases other than SqlBase.
FRBhote
India
Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

5.2 and Sql Server

Post by FRBhote » 14 Mar 2015, 12:33

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
You do not have the required permissions to view the files attached to this post.

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2370
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: 5.2 and Sql Server

Post by Jeff Luther » 16 Mar 2015, 16:33

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.
Jeff Luther @ PC Design
Palm Springs, California

FRBhote
India
Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: 5.2 and Sql Server

Post by FRBhote » 17 Mar 2015, 10:56

Any help with this?

ROUX Ch.

Re: 5.2 and Sql Server

Post by ROUX Ch. » 19 Mar 2015, 13:27

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
India
Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: 5.2 and Sql Server

Post by FRBhote » 20 Mar 2015, 10:52

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

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2370
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: 5.2 and Sql Server

Post by Jeff Luther » 23 Mar 2015, 18:09

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
Jeff Luther @ PC Design
Palm Springs, California


FRBhote
India
Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: 5.2 and Sql Server

Post by FRBhote » 25 Mar 2015, 06:18

Thanks.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest