Direct Access to CTRL-M Sybase DB

[DaveM]

Hello,

I'm trying to get access to the Sybase server to view the tables and maybe run some queries.

I've tried to use SQL Anywhere and also Advanced Query Tool because I am finding iSQL quite hard to use.

I am getting this error when setting up the ODBC connection :

Tue Oct 30 2007 16:58:06
16:58:06 Attempting to connect using:
UID=ctrlm;PWD=********;DBN=CTRLM;DBF=/var/ctlmserv/sybase;ENG=unspecified;CON=SQL_DBC_3bc4ae0;LOG=C:\testcon50240.tmp;LINKS='tcpip{IP=172.17.xxx.xxx;Port=7102;verify=no;dobroadcast=none}'
16:58:06 Attempting to connect to a running server...
16:58:06 Trying to start TCPIP link ...
16:58:06 TCP using Winsock version 2.2
16:58:06 My IP address is 127.0.0.1
16:58:06 My IP address is 172.17.xxx.xxx
16:58:06 TCPIP link started successfully
16:58:06 Attempting TCPIP connection (address 172.17.xxx.xxx:7102 found in sasrv.ini cache)
16:58:06 DoBroadcast=NONE specified, ignoring cached address
16:58:06 DoBroadcast=NONE specified, skipping LDAP check
16:58:06 Looking for server with name unspecified
16:58:06 Trying to find server at address 172.17.xxx.xxx
16:58:06 Found server, not verifying server name
16:58:06 Found database server at address 172.17.xxx.xxx:7102
16:58:06 Found database server unspecified on TCPIP link
16:58:06 Connected using client address 172.17.xxx.xxx:2687
16:58:06 Connected to server over TCPIP at address 172.17.xxx.xxx:7102
16:58:06 Communication function ApplicationConnect code 3
16:58:06 Client disconnected
16:58:06 Cannot connect to server

I'm not sure what I am doing wrong.

Can anyone offer advise on direct connection to database, and maybe with some other tool?

Many thanks.[/b]

[DaveM]

Here are the version numbers for extra info :

Ctrl-M : 6.0.03
Sybase : Adaptive Server Enterprise/11.9.2.4

[philmalmaison]

you must install the corresponding version of sybase client to set environment odbc etc ...
regards
Philmalmaison