Skip to Content.
Sympa Menu

freetds - [freetds] Problems connecting Sybase SQL Anywhere

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ystmio Gaona" <igaona AT stream.com.py>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Problems connecting Sybase SQL Anywhere
  • Date: Fri, 17 Jun 2005 14:38:41 -0400

Hi, i have install the latest version of FREETDS and UnixODBC.
I want to connect to Sybase SQL Anywhere 7.0.

odbc.ini
[medicaserver]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Servername = medicaserver
Server = 192.168.50.1
Port = 2638
TDS_Version = 5.0
Database = medist.db

[Default]
Driver = /usr/local/freetds/lib/libtdsodbc.so

odbcinst.ini
[SYBASE]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = TDS Sybase Driver
FileUsage = 1

[Default]
Driver = /usr/local/freetds/lib/libtdsodbc.so

freetds.conf
[medicaserver]
host = 192.168.50.1
port = 2638
tds version = 5.0


I have compiled freetds with the option --with-unixodbc=PATH, and as a result
this file was created "/usr/local/freetds/lib/libtdsodbc.so".

Testing the connection i get this error:
[root@esalud unixodbc]# isql -v medicaserver stream stream
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
[][unixODBC][FreeTDS][SQL Server]ASA Error -75: Request to start/stop
database denied
[ISQL]ERROR: Could not SQLConnect

I'm running Redhat linux 7.3, freetds 0.63, unixodbc 2.2.11, kernel version
2.4.18-3.

But, i can connect to another database (Sybase SQL Anywhere) on another
host.. :((

I hope you can helpme.

Sorry for my english :).

Ystmio




Archive powered by MHonArc 2.6.24.

Top of Page