VISOCO Software  Home | Products | Services | Download | Order | Support | Forum | Resources | Search | About
  RSS feedRSS Feed  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  RegisterRegister   ProfileProfile    Log inLog in 
Packetsize with library 2.1.2.15

 
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE
Author Message
Anordlun



Joined: 13 Aug 2004
Posts: 12

PostPosted: Mon Aug 01, 2005 4:37 pm    Post subject: Packetsize with library 2.1.2.15 Reply with quote

Hi.
How do I change the packetsize by code (By the way, it's delphi 7.).
I've read the post regarding this, buy I haven't been able to do this anyway.

I'm using the TSQLConnection object to connect to the Sybase server.
Back to top
View user's profile Send private message
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Wed Aug 03, 2005 2:27 pm    Post subject: Reply with quote

Hi there,

try to use an external configuration file.
See "Custom String" configuration parameter

You have to use CS_PACKETSIZE configuration option.

Could you notice us about the result?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Anordlun



Joined: 13 Aug 2004
Posts: 12

PostPosted: Thu Aug 04, 2005 9:59 am    Post subject: Reply with quote

Hi there.
I did as you wrote, but with no luck. (Almost).
You solved another problem I had... The missing AppName parameter...

But when I add the CONFIG_FILE parameter, I always get the errormessage 191, severity 1: The connection failed because of invalid or missing external configuration data.
Back to top
View user's profile Send private message
Anordlun



Joined: 13 Aug 2004
Posts: 12

PostPosted: Fri Aug 05, 2005 9:32 am    Post subject: Problem solved! Reply with quote

Hi there.

I had to add the Default section in the file, and add the CS_SERVERNAME key/value like this:

[DEFAULT]
CS_SERVERNAME='Some text'
Back to top
View user's profile Send private message
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Fri Aug 05, 2005 1:00 pm    Post subject: Reply with quote

Hello,

I'm sorry, I didn't understand...

How does it work ?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Sat Aug 06, 2005 2:13 am    Post subject: Reply with quote

Anordlun wrote:

But when I add the CONFIG_FILE parameter, I always get the errormessage 191, severity 1: The connection failed because of invalid or missing external configuration data.


Hi there,

we've found the solution. You just need to reconfigure your server Very Happy
Increase "max network packet size" configuration parameter. It must help.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Anordlun



Joined: 13 Aug 2004
Posts: 12

PostPosted: Mon Aug 08, 2005 9:35 am    Post subject: Reply with quote

Hi.
It didn't matter what I wrote in the external config file.
Every time i tried to log on, the errormessage I described earliger, popped up.
I even tried with the example in the forum. (CS_TIMEOUT).

Another issue is that the APPNAME parameter is Case Sensitive, and no special character (like space) can exist in the string.

Byt when I added the DEFAULT section and the CS_SERVERNAME parameter, the client was enabled to log on.

Regarding the "max network packet size".
Yep you are right, this has to be changed before I can increase the value in my client, but this was already done.


If the config file contain this text, the log on fail:

Code:
[MyApp]
CS_PACKETSIZE=512


But is I add t CS_SERVERNAME section, the client is able to log on.

Code:
[DEFAULT]
CS_SERVERNAME='Financial database server'
[MyApp]
CS_PACKETSIZE=512
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE All times are GMT + 2 Hours
Page 1 of 1

 


©VISOCO Software. phpBB by phpBB Group