xpressbrazerzkidai.blogg.se

How to trace sql anywhere client to database
How to trace sql anywhere client to database










how to trace sql anywhere client to database

The client attempts connections until it connects successfully or it has tried all the addresses. When multipleĪddresses are specified, the client attempts to connect to each address in the order that they are specified in the HOST protocol

how to trace sql anywhere client to database

The SQL Anywhere client attempts to connect over TCP/IP to the addresses specified in the HOST protocol option. See Step 4: Send out UDP find database server requests. If the HOST protocol option is not specified, the SQL Anywhere client attempts to find the Server using UDP find server Step 3: Attempt a TCP/IP connection to the address(es) specified in the HOST protocol option SQL Anywhere client and database server computers are configured to use an LDAP server. Step 2: Check the LDAP server for the server nameĪ SQL Anywhere client queries the LDAP server for an entry that matches the ServerName connection parameter when the

how to trace sql anywhere client to database

Then verifies that the connected server is named joey. The addresses match, so the client connects over TCP/IP to 10.25.13.5:49152 and Of the specified Host name with 10.25.13.5. Is running on this computer on port 49152.įor the connection string CommLinks=TCPIP(Host=kangaroo) ServerName=joey, the client finds an entry in its sasrv.ini file that matches the server name joey. When a matching cache entry is found, the client attempts a TCP/IP connection to the IP address listed in the cache.Īssume there is a computer with the host name kangaroo and the IP address 10.25.13.5. See Step 2: Check the LDAP server for the server name. If no matching cache entry is found, the client attempts to find the database server using LDAP. String also includes the HOST protocol option, then the cache entry must also match the host address specified. The client checks its sasrv.ini file for an entry that matches the database server name specified in the ServerName connection parameter. See Step 3: Attempt a TCP/IP connection to the address(es) specified in the HOST protocol option. That is, the SQL Anywhere client does not use the database server address cache or the LDAP server. Protocol option is set to YES, or the DoBroadcast protocol option is set to NONE, then the SQL Anywhere client attempts aĭirect TCP/IP connection. If the connection string includes the HOST protocol option but not the ServerName connection parameter, the LocalOnly Step 1: Check the database server address cache ( sasrv.ini)












How to trace sql anywhere client to database