-   Programming (
-   -   unixODBC and sybase (

eantoranz 06-10-2005 03:06 PM

unixODBC and sybase
I'm trying to connect to a sybase DB, but i've been unable to.

This is my .odbc.ini file:

[ODBC Data Sources]
Smile=DB de Smile



When I try to connect with isql, I get this:

$ isql Smile -v
[08001][unixODBC][Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to connect to database server: Database server not found
[ISQL]ERROR: Could not SQLConnect

I know I've always had to setup JDBC connections giving the IP address and the port of the service, and that normally doesn't fail. This is the first time I try with ODBC, but haven't been able to.
Is there a way I can tell it to use a ip address and a port?
What are the things that I can setup in the ODBC file? I didn't get much information in the ASA Documentation.

Is there a way to ask isql (or unixODBC) to be more verbose on the things that are happening? I noticed that there is no traffic going to the DB server form my host (with tcpdump).

Maybe I can setup a ODBC DSN that uses a JDBC connection, which I know won't fail. Is this possible?

eantoranz 06-13-2005 10:22 AM

Well... I've been able to make a step forward (finally).

It turns out that the odbc driver is trying to stablish a remote connection through localhost. :scratch: Take a look at the log:


mon jun 13 2005 11:17:41
11:17:41 Application information:
11:17:41 "IP=;HOST=galileo;OS=Linux 2.6.3-7mdk #1 Wed Mar 17 15:56:42 CET 2004;PID=0xef3;THREAD=0x402962a0;VERSION=;API=ODBC;TIMEZONEADJUSTMENT=-240"
11:17:41 Attempting to connect using:
11:17:41 Attempting to connect to a running server...
11:17:41 Trying to start TCPIP link ...
11:17:41 My IP address is
11:17:41 My IP address is
11:17:41    TCPIP link started successfully
11:17:41 Attempting TCPIP connection (no .asasrv.ini cached address)
11:17:41 LDAP routines could not be found, LDAP support disabled
11:17:41 Looking for server with name
11:17:41 I am in a class A network
11:17:41 Sending broadcast to find server
11:17:41 Using broadcast address of:
11:17:41 I am in a class A network
11:17:41 Sending broadcast to find server
11:17:41 Using broadcast address of:
11:17:42 Resending
11:17:43 Resending
11:17:44 Resending
11:17:45 Resending
11:17:46    Server not found (no reply received)
11:17:46 Failed to connect over TCPIP
11:17:46 Not attempting to autostart server
11:17:46 Cannot connect to server

What's the missing point here? Why is it broadcasting the 127/24 segment? Shouldn't it realize I'm trying to reach 192.0.0/8? (look at the server address in the log file).

Maybe there's a way to force unixODBC to use my IP adress. Is there any?

eantoranz 06-13-2005 10:43 AM

was afiannly able to connect to the DB server.

I had to set some parameters at the CommLinks parameter:

CommLinks=tcpip(MyIP=;IP=; )

eantoranz 12-20-2005 01:54 PM

It's been quite a while since the last post... but I'm back in trouble. :'(

I have switched my box tu ubuntu (kubuntu, as a matter of fact) beezy. Just installed unixodbc, and have to make a little modification for the config file, but I only get this message when I run isql:


$ isql Smile -v
[ISQL]ERROR: Could not SQLConnect

And that's it. And not even the log is written, so I guess it's not a problem of the Driver but odbc itself. Any ideas what I'm doing wrong? :scratch:

All times are GMT -5. The time now is 07:29 PM.