Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problems connecting Sybase SQL Anywhere

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <brian.bruns AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems connecting Sybase SQL Anywhere
  • Date: Thu, 16 Jun 2005 21:39:35 -0400

Sybase ASA only supports TDS 5.0, please give that a try.

2005/6/16, Ystmio Gaona <igaona AT stream.com.py>:
> 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 = 4.2
> 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 = 4.2
>
> 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.
>
> I hope you can helpme.
>
> Sorry for my english :).
>
> Ystmio
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page