| Author |
Message |
Anordlun
Joined: 13 Aug 2004 Posts: 12
|
Posted: Mon Aug 01, 2005 4:37 pm Post subject: Packetsize with library 2.1.2.15 |
|
|
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 |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Wed Aug 03, 2005 2:27 pm Post subject: |
|
|
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 |
|
 |
Anordlun
Joined: 13 Aug 2004 Posts: 12
|
Posted: Thu Aug 04, 2005 9:59 am Post subject: |
|
|
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 |
|
 |
Anordlun
Joined: 13 Aug 2004 Posts: 12
|
Posted: Fri Aug 05, 2005 9:32 am Post subject: Problem solved! |
|
|
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 |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Fri Aug 05, 2005 1:00 pm Post subject: |
|
|
Hello,
I'm sorry, I didn't understand...
How does it work ? |
|
| Back to top |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Sat Aug 06, 2005 2:13 am Post subject: |
|
|
| 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
Increase "max network packet size" configuration parameter. It must help. |
|
| Back to top |
|
 |
Anordlun
Joined: 13 Aug 2004 Posts: 12
|
Posted: Mon Aug 08, 2005 9:35 am Post subject: |
|
|
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 |
|
 |
|