freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
- Date: Wed, 1 Dec 2010 09:07:29 +0100
2010/12/1 Boniforti Flavio <flavio AT piramide.ch>:
> Hello everybody.
>
> I'm trying to get my Linux Server connecting to my MSSQL 2005 Express
> database, and so far I got it only partially working.
> I followed the instructions I found here:
> http://blog.marcingil.com/2009/11/linux-odbc-to-mssql/
>
> When I use tsql, I get my connection working, instead by using isql I
> get:
>
> root@ticket:~# isql -v sqlexpress sa
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect
>
> My /etc/odbc.ini:
>
> [sqlexpress]
> Driver = FreeTDS
> Port = 1433
> Description = MS SQL Server 2005 Express
> Trace = Yes
> Servername = exchange.piramide.local
> Database = Piramide_Informatica
>
> My /etc/odbcinst.ini:
>
> [FreeTDS]
> Description = Free Sybase & MS SQL Driver
> Driver = /usr/lib/odbc/libtdsodbc.so
> Setup = /usr/lib/odbc/libtdsS.so
> UsageCount = 1
>
> Is there any way to get around this error? Where am I wrong?
>
cfr http://www.freetds.org/userguide/odbcconnattr.htm
Server, not servername in this case...
> Thanks and kind regards.
>
> Flavio Boniforti
>
> PIRAMIDE INFORMATICA SAGL
> Via Ballerini 21
> 6600 Locarno
> Switzerland
> Phone: +41 91 751 68 81
> Fax: +41 91 751 69 14
> URL: http://www.piramide.ch
> E-mail: flavio AT piramide.ch
bye
freddy77
-
[freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Boniforti Flavio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Frediano Ziglio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Boniforti Flavio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Peter C. Norton, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Boniforti Flavio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Peter C. Norton, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
James K. Lowden, 12/01/2010
- Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails, Boniforti Flavio, 12/02/2010
- Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails, Peter C. Norton, 12/02/2010
- Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails, Boniforti Flavio, 12/03/2010
- Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails, jklowden, 12/02/2010
- Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails, Peter C. Norton, 12/02/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
James K. Lowden, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Peter C. Norton, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Boniforti Flavio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Peter C. Norton, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Boniforti Flavio, 12/01/2010
-
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails,
Frediano Ziglio, 12/01/2010
Archive powered by MHonArc 2.6.24.