SQL Anywhere Help - Connection String Error?

[Former Member]

I'm trying to connect to an SQL Anywhere database on the network.

Any help is appreciated.

Thanks

Here is the connections string:

MICROS&Provider=SAOLEDB.11;UID=custom;PWD=custom;ENG=sqlmicros1;CON=SQL_DBC_190f07d8;LINKS='TCPIP(IP=10.4.0.40;PORT=2638)'

Here is the error I'm getting.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException (0x80040E4D): Connection error: Found server but communication error occurred
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

[Breck_Carter]

More diagnostic information might help; see http://dcx.sybase.com/index.html#1201/en/dbadmin/network-s-3532726.html

[jeff_albion]

Generically, "Connection error: Found server but communication error occurred" means just what the message implies - the connection library was able to find the targeted server name via UDP broadcasting (e.g. "sqlmicros1"), but couldn't make an active TCP connection to it (over "10.4.0.40:2638").

Are you sure that the "sqlmicros1" database server is running on that IP/port? Can you check dblocate 10.4.0.40 to see if it can see this server as well? Can you add the connection option "LOG=c:\\connlog.txt" to the connection string, and review the resulting log to check how the client is attempting to contact this server?