SQL Anywhere database - Slow Connection Progress

Author

Slow Connection Progress

Thomas Kehl

2005-04-13, 8:23 pm

Hi.

I use the fallowing DSN-File to connect to a databaseservice (dbsrv9):
--------------------
[ODBC]
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
Compress=No
CommLinks=SharedMemo
ry,TCPIP{HOST=192.168.3.11,Serverport=2226}
DisableMultiRowFetch
=Yes
Debug=No
Integrated=No
AutoStop=No
EngineName=PPHEEB
DatabaseName=PPHEEB
------------------

The service-parameters are the fallowing:
--------------
-x tcpip{ServerPort=222
6}
-c 64m
-n PPHEEB
-ti 0
-tl 0
D:\APPS\PPHEEBDB\PPD
B\PROFIPLUS.DB -n PPHEEB
---------------
Server:
C:\Programme\Sybase\
SQL Anywhere 9\win32\dbsrv9.exe

Now, when I connect from the client with the dsn-file showing above, the
connectionprogress is very slow. Does I make anything wrong? Is there a
parametersetting to win performance at the connection progress?

I use ASA 9.0.2.2451

Thanks for your tips.

Best Regards
Thomas

Ian McHardy

2005-04-15, 11:23 am

DisableMultiRowFetch
=Yes can slow down performance in many cases.

Is dbping -d -c "dsn=<your dsn>" slow? If so, what kind of a network are
you connecting over? If you add -z to the dbping command line, which parts
of the connect are slow?

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Thomas Kehl" <t.kehl (at) heeb.com> wrote in message
news:425d8661$1@foru
ms-2-dub...
> Hi.
>
> I use the fallowing DSN-File to connect to a databaseservice (dbsrv9):
> --------------------
> [ODBC]
> DRIVER=Adaptive Server Anywhere 9.0
> UID=dba
> Compress=No
> CommLinks=SharedMemo
ry,TCPIP{HOST=192.168.3.11,Serverport=2226}
> DisableMultiRowFetch
=Yes
> Debug=No
> Integrated=No
> AutoStop=No
> EngineName=PPHEEB
> DatabaseName=PPHEEB
> ------------------
>
> The service-parameters are the fallowing:
> --------------
> -x tcpip{ServerPort=222
6}
> -c 64m
> -n PPHEEB
> -ti 0
> -tl 0
> D:\APPS\PPHEEBDB\PPD
B\PROFIPLUS.DB -n PPHEEB
> ---------------
> Server:
> C:\Programme\Sybase\
SQL Anywhere 9\win32\dbsrv9.exe
>
> Now, when I connect from the client with the dsn-file showing above, the
> connectionprogress is very slow. Does I make anything wrong? Is there a
> parametersetting to win performance at the connection progress?
>
> I use ASA 9.0.2.2451
>
> Thanks for your tips.
>
> Best Regards
> Thomas
>

Thomas Kehl

2005-04-17, 9:23 am

Hi Ian
Thanks for your tips.

I have tried dbping now. I see, that sybase makes a broadcast. But I give it
the IP-Adress and Portnumber in the dsn-name.
That are the results of dbping: - Can you say me whats wrong?

P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn"

Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
at address 192.168.3.11.
Ping database successful.

P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn" -z

Adaptive Server Anywhere Server Ping Utility Version 9.0.2.2451
Application information:
" HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
;PID=0xbcc;THREAD=0x
1a8;EXE=C:\Programm
e\Sybase\SQL Anywhere
9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
JUSTMENT=120"
Attempting to connect using:
UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11,Serv
erport=2226};COMP=NO

Attempting to connect to a running server...
Trying to start SharedMemory link ...
SharedMemory link started successfully
Attempting SharedMemory connection (no asasrv.ini cached address)
Failed to connect over SharedMemory
Trying to start TCPIP link ...
Loading wsock32.dll
Loading ws2_32.dll
TCP using Winsock version 2.0
My IP address is 192.168.3.10
My IP address is 127.0.0.1
TCPIP link started successfully
Attempting TCPIP connection (no asasrv.ini cached address)
Looking for server with name ppheeb
Trying to find server at address 192.168.3.11
TCP/IP link, function connect(), error code 10061
Trying to find server at address Serverport=2226
No IP address found for Serverport=2226
I am in a class C network
Sending broadcast to find server
Using broadcast address of: 192.168.3.255:2638
I am in a class A network
Sending broadcast to find server
Using broadcast address of: 127.255.255.255:2638
No IP address found for Serverport=2226
Found database server at address 192.168.3.11:2226
Found database server ppheeb on TCPIP link
Connected to server over TCPIP at address 192.168.3.11:2226
Writing server address 192.168.3.11:2226 to asasrv.ini cache
Connected to ASA Engine version 9.0.2.2451
Connected to the server, attempting to connect to a running database...
Connected to database successfully
Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
at address 192.168.3.11.
Client disconnected
Ping database successful.

********************
***************

When I work withoud sharedmemory, this is the result:

P:\PPHEEB\PPWin>dbping -d -c
" filedsn=P:\PPHEEB\PP
Win\profiplus.dsn;pwd=citroen"
-z
Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
Application information:
" HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
;PID=0x360;THREAD=0x
f24;EXE=C:\Programm
e\Sybase\SQL Anywhere
9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
JUSTMENT=120"
Attempting to connect using:
UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=TCPIP{HOST=192
.168.3. 11,Serverport=2226};

COMP=NO
Attempting to connect to a running server...
Trying to start TCPIP link ...
Loading wsock32.dll
Loading ws2_32.dll
TCP using Winsock version 2.0
My IP address is 192.168.3.10
My IP address is 127.0.0.1
TCPIP link started successfully
Attempting TCPIP connection (address 192.168.3.11:2226 found in asasrv.ini
cache
)
Trying to find server at cached address 192.168.3.11:2226 without
broadcasting
Found server, verifying server name
Found database server at address 192.168.3.11:2226
Found database server ppheeb on TCPIP link
Connected to server over TCPIP at address 192.168.3.11:2226
Connected to ASA Engine version 9.0.2.2451
Connected to the server, attempting to connect to a running database...
Connected to database successfully
Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
at address 192.168.3.11.
Client disconnected
Ping database successful.

Best Regards
Thomas

"Ian McHardy" < mchardy_no@spam_iany
where.com> schrieb im Newsbeitrag
news:425fe6d8$1@foru
ms-2-dub...
> DisableMultiRowFetch
=Yes can slow down performance in many cases.
>
> Is dbping -d -c "dsn=<your dsn>" slow? If so, what kind of a network are
> you connecting over? If you add -z to the dbping command line, which
> parts of the connect are slow?
>
> --
>
> Ian McHardy (iAnywhere Solutions)
>
> Please reply only to the newsgroup.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
> "Thomas Kehl" <t.kehl (at) heeb.com> wrote in message
> news:425d8661$1@foru
ms-2-dub...
>
>

Breck Carter [TeamSybase]

2005-04-17, 11:23 am

Is is slow without the sharedmemory? It *looks* faster without it,
simply because it's doing fewer steps. You do not want or need
sharedmemory if the server is on a different computer from the client.

Breck

On 17 Apr 2005 05:52:31 -0700, "Thomas Kehl" <t.kehl (at) heeb.com>
wrote:

>Hi Ian
>Thanks for your tips.
>
>I have tried dbping now. I see, that sybase makes a broadcast. But I give it
>the IP-Adress and Portnumber in the dsn-name.
>That are the results of dbping: - Can you say me whats wrong?
>
>
>P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn"
>
>Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
>Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
>at address 192.168.3.11.
>Ping database successful.
>
>P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn" -z
>
>Adaptive Server Anywhere Server Ping Utility Version 9.0.2.2451
>Application information:
>" HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0xbcc;THREAD=0x
1a8;EXE=C:\Programm
>e\Sybase\SQL Anywhere
>9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
>JUSTMENT=120"
>Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

>in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11,Serv
> erport=2226};COMP=NO

>Attempting to connect to a running server...
>Trying to start SharedMemory link ...
> SharedMemory link started successfully
>Attempting SharedMemory connection (no asasrv.ini cached address)
>Failed to connect over SharedMemory
>Trying to start TCPIP link ...
>Loading wsock32.dll
>Loading ws2_32.dll
>TCP using Winsock version 2.0
>My IP address is 192.168.3.10
>My IP address is 127.0.0.1
> TCPIP link started successfully
>Attempting TCPIP connection (no asasrv.ini cached address)
>Looking for server with name ppheeb
>Trying to find server at address 192.168.3.11
>TCP/IP link, function connect(), error code 10061
>Trying to find server at address Serverport=2226
> No IP address found for Serverport=2226
>I am in a class C network
>Sending broadcast to find server
>Using broadcast address of: 192.168.3.255:2638
>I am in a class A network
>Sending broadcast to find server
>Using broadcast address of: 127.255.255.255:2638
> No IP address found for Serverport=2226
>Found database server at address 192.168.3.11:2226
>Found database server ppheeb on TCPIP link
>Connected to server over TCPIP at address 192.168.3.11:2226
>Writing server address 192.168.3.11:2226 to asasrv.ini cache
>Connected to ASA Engine version 9.0.2.2451
>Connected to the server, attempting to connect to a running database...
>Connected to database successfully
>Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
>at address 192.168.3.11.
>Client disconnected
>Ping database successful.
>
> ********************
***************
>
>When I work withoud sharedmemory, this is the result:
>
>P:\PPHEEB\PPWin>dbping -d -c
>" filedsn=P:\PPHEEB\PP
Win\profiplus.dsn;pwd=citroen"
> -z
>Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
>Application information:
>" HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0x360;THREAD=0x
f24;EXE=C:\Programm
>e\Sybase\SQL Anywhere
>9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
>JUSTMENT=120"
>Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

>in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=TCPIP{HOST=192
.168.3. 11,Serverport=2226};

>COMP=NO
>Attempting to connect to a running server...
>Trying to start TCPIP link ...
>Loading wsock32.dll
>Loading ws2_32.dll
>TCP using Winsock version 2.0
>My IP address is 192.168.3.10
>My IP address is 127.0.0.1
> TCPIP link started successfully
>Attempting TCPIP connection (address 192.168.3.11:2226 found in asasrv.ini
>cache
> )
>Trying to find server at cached address 192.168.3.11:2226 without
>broadcasting
>Found server, verifying server name
>Found database server at address 192.168.3.11:2226
>Found database server ppheeb on TCPIP link
>Connected to server over TCPIP at address 192.168.3.11:2226
>Connected to ASA Engine version 9.0.2.2451
>Connected to the server, attempting to connect to a running database...
>Connected to database successfully
>Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
>at address 192.168.3.11.
>Client disconnected
>Ping database successful.
>
>
>Best Regards
>Thomas
>
>"Ian McHardy" < mchardy_no@spam_iany
where.com> schrieb im Newsbeitrag
> news:425fe6d8$1@foru
ms-2-dub...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Mark Culp

2005-04-18, 3:23 am

FWIW: Checking for a connection to an engine using sharedmemory is
almost instantaneous, so you need not worry about that part.

What is causing your issue is the broadcast - there is a 5 second delay
while the client waits for a response.

What you need to do is specify not only links=tcpip and the host of the server
but also that you do not want to do the broadcast. i.e.
dbping -d -c
"uid=dba;pwd=<***> ;eng=PPHEEB;links=tc
pip{host=192.168.3. 11;serverport=2226;d
obroadcast=no}

Of course, you can add the dobroadcast=no to your DSN as well.
--
Mark Culp
SQLAnywhere Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

Thomas Kehl wrote:[color=darkred
]
>
> Hi Ian
> Thanks for your tips.
>
> I have tried dbping now. I see, that sybase makes a broadcast. But I give it
> the IP-Adress and Portnumber in the dsn-name.
> That are the results of dbping: - Can you say me whats wrong?
>
> P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn"
>
> Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Ping database successful.
>
> P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn" -z
>
> Adaptive Server Anywhere Server Ping Utility Version 9.0.2.2451
> Application information:
> " HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0xbcc;THREAD=0x
1a8;EXE=C:\Programm
> e\Sybase\SQL Anywhere
> 9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
> JUSTMENT=120"
> Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

> in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11,Serv
> erport=2226};COMP=NO

> Attempting to connect to a running server...
> Trying to start SharedMemory link ...
> SharedMemory link started successfully
> Attempting SharedMemory connection (no asasrv.ini cached address)
> Failed to connect over SharedMemory
> Trying to start TCPIP link ...
> Loading wsock32.dll
> Loading ws2_32.dll
> TCP using Winsock version 2.0
> My IP address is 192.168.3.10
> My IP address is 127.0.0.1
> TCPIP link started successfully
> Attempting TCPIP connection (no asasrv.ini cached address)
> Looking for server with name ppheeb
> Trying to find server at address 192.168.3.11
> TCP/IP link, function connect(), error code 10061
> Trying to find server at address Serverport=2226
> No IP address found for Serverport=2226
> I am in a class C network
> Sending broadcast to find server
> Using broadcast address of: 192.168.3.255:2638
> I am in a class A network
> Sending broadcast to find server
> Using broadcast address of: 127.255.255.255:2638
> No IP address found for Serverport=2226
> Found database server at address 192.168.3.11:2226
> Found database server ppheeb on TCPIP link
> Connected to server over TCPIP at address 192.168.3.11:2226
> Writing server address 192.168.3.11:2226 to asasrv.ini cache
> Connected to ASA Engine version 9.0.2.2451
> Connected to the server, attempting to connect to a running database...
> Connected to database successfully
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Client disconnected
> Ping database successful.
>
> ********************
***************
>
> When I work withoud sharedmemory, this is the result:
>
> P:\PPHEEB\PPWin>dbping -d -c
> " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn;pwd=citroen"
> -z
> Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
> Application information:
> " HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0x360;THREAD=0x
f24;EXE=C:\Programm
> e\Sybase\SQL Anywhere
> 9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
> JUSTMENT=120"
> Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

> in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=TCPIP{HOST=192
.168.3. 11,Serverport=2226};

> COMP=NO
> Attempting to connect to a running server...
> Trying to start TCPIP link ...
> Loading wsock32.dll
> Loading ws2_32.dll
> TCP using Winsock version 2.0
> My IP address is 192.168.3.10
> My IP address is 127.0.0.1
> TCPIP link started successfully
> Attempting TCPIP connection (address 192.168.3.11:2226 found in asasrv.ini
> cache
> )
> Trying to find server at cached address 192.168.3.11:2226 without
> broadcasting
> Found server, verifying server name
> Found database server at address 192.168.3.11:2226
> Found database server ppheeb on TCPIP link
> Connected to server over TCPIP at address 192.168.3.11:2226
> Connected to ASA Engine version 9.0.2.2451
> Connected to the server, attempting to connect to a running database...
> Connected to database successfully
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Client disconnected
> Ping database successful.
>
> Best Regards
> Thomas
>
> "Ian McHardy" < mchardy_no@spam_iany
where.com> schrieb im Newsbeitrag
> news:425fe6d8$1@foru
ms-2-dub...

Greg Fenton

2005-04-18, 3:23 am

Mark Culp wrote:
>
> What you need to do is specify not only links=tcpip and the host of the server
> but also that you do not want to do the broadcast.

Just to add to Mark's comments, the only reason for the broadcast is to
allow the client to "find" a server given just its name. If you know
the IP address and port that the database engine is running on, then you
almost certainly want it disabled.

SQLAnywhere has some great defaults for people just getting started with
the database or for people who want minimal configuration, but once you
start using the database beyond a typical single-user "embedded"
application, many of those defaults should be overriden. Broadcast is
one of them.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Ian McHardy

2005-04-18, 1:23 pm

From the dbping -z output:
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11,Serverport=2226}
Since you used a comma after the host parameter, this is interprated as two
host addresses "192.168.3.11" and "Serverport=2226". Attempting to connect
to 192.168.3.11:2638 will be slow, and attempting to resolve the incorrect
hostname "Serverport=2226" may be slow.

This should be:
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11;Serverport=2226}

Make sure there is a semicolon in this option in the DSN.

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Thomas Kehl" <t.kehl (at) heeb.com> wrote in message
news:42625c0f@forums
-1-dub...
> Hi Ian
> Thanks for your tips.
>
> I have tried dbping now. I see, that sybase makes a broadcast. But I give
> it the IP-Adress and Portnumber in the dsn-name.
> That are the results of dbping: - Can you say me whats wrong?
>
>
> P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn"
>
> Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Ping database successful.
>
> P:\PPHEEB\PPWin>dbping -d -c " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn" -z
>
> Adaptive Server Anywhere Server Ping Utility Version 9.0.2.2451
> Application information:
> " HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0xbcc;THREAD=0x
1a8;EXE=C:\Programm
> e\Sybase\SQL Anywhere
> 9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
> JUSTMENT=120"
> Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

> in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=SharedMemory,T
CPIP{HOST=192.168.3.11,Serv
> erport=2226};COMP=NO

> Attempting to connect to a running server...
> Trying to start SharedMemory link ...
> SharedMemory link started successfully
> Attempting SharedMemory connection (no asasrv.ini cached address)
> Failed to connect over SharedMemory
> Trying to start TCPIP link ...
> Loading wsock32.dll
> Loading ws2_32.dll
> TCP using Winsock version 2.0
> My IP address is 192.168.3.10
> My IP address is 127.0.0.1
> TCPIP link started successfully
> Attempting TCPIP connection (no asasrv.ini cached address)
> Looking for server with name ppheeb
> Trying to find server at address 192.168.3.11
> TCP/IP link, function connect(), error code 10061
> Trying to find server at address Serverport=2226
> No IP address found for Serverport=2226
> I am in a class C network
> Sending broadcast to find server
> Using broadcast address of: 192.168.3.255:2638
> I am in a class A network
> Sending broadcast to find server
> Using broadcast address of: 127.255.255.255:2638
> No IP address found for Serverport=2226
> Found database server at address 192.168.3.11:2226
> Found database server ppheeb on TCPIP link
> Connected to server over TCPIP at address 192.168.3.11:2226
> Writing server address 192.168.3.11:2226 to asasrv.ini cache
> Connected to ASA Engine version 9.0.2.2451
> Connected to the server, attempting to connect to a running database...
> Connected to database successfully
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Client disconnected
> Ping database successful.
>
> ********************
***************
>
> When I work withoud sharedmemory, this is the result:
>
> P:\PPHEEB\PPWin>dbping -d -c
> " filedsn=P:\PPHEEB\PP
Win\profiplus.dsn;pwd=citroen"
> -z
> Adaptive Server Anywhere Server Ping Utility Version 9.0.0.1108
> Application information:
> " HOST=SRVDATA;OS=Wind
ows 2003 Build 3790
> ;PID=0x360;THREAD=0x
f24;EXE=C:\Programm
> e\Sybase\SQL Anywhere
> 9\win32\dbping.exe;VERSION=9.0.0. 1108;API=DBLIB;TIMEZ
ONEAD
> JUSTMENT=120"
> Attempting to connect using:
> UID=dba;PWD=********
;DBN=PPHEEB;ENG=PPHE
EB;ASTOP=NO;INT=NO;F
ILEDSN=P:\PPHEEB\PPW

> in\profiplus. dsn;DBG=NO;DMRF=YES;
LINKS=TCPIP{HOST=192
.168.3. 11,Serverport=2226};

> COMP=NO
> Attempting to connect to a running server...
> Trying to start TCPIP link ...
> Loading wsock32.dll
> Loading ws2_32.dll
> TCP using Winsock version 2.0
> My IP address is 192.168.3.10
> My IP address is 127.0.0.1
> TCPIP link started successfully
> Attempting TCPIP connection (address 192.168.3.11:2226 found in asasrv.ini
> cache
> )
> Trying to find server at cached address 192.168.3.11:2226 without
> broadcasting
> Found server, verifying server name
> Found database server at address 192.168.3.11:2226
> Found database server ppheeb on TCPIP link
> Connected to server over TCPIP at address 192.168.3.11:2226
> Connected to ASA Engine version 9.0.2.2451
> Connected to the server, attempting to connect to a running database...
> Connected to database successfully
> Connected to ASA 9.0.2.2451 server "PPHEEB" and database "PPHEEB"
> at address 192.168.3.11.
> Client disconnected
> Ping database successful.
>
>
> Best Regards
> Thomas
>
> "Ian McHardy" < mchardy_no@spam_iany
where.com> schrieb im Newsbeitrag
> news:425fe6d8$1@foru
ms-2-dub...
>
>

Sponsored Links