freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
- From: "Peter C. Norton" <spacey-freetds.org AT ssr.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:28:23 -0500
On Wed, Dec 01, 2010 at 09:23:31AM +0100, Boniforti Flavio wrote:
> Ciao Frediano,
>
> > cfr http://www.freetds.org/userguide/odbcconnattr.htm
> >
> > Server, not servername in this case...
>
> so following should be doing it, right?
>
> [sqlexpress]
> Driver = FreeTDS
> Port = 1433
> Description = MS SQL Server 2005 Express
> Trace = Yes
> Server = exchange.piramide.local
> Database = Piramide_Informatica
>
> Well, I still get no connection:
>
> root@ticket:~# isql -v sqlexpress sa
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [37000][unixODBC][FreeTDS][SQL Server]Accesso non riuscito per l'utente
> 'sa'.
> [ISQL]ERROR: Could not SQLConnect
>
> I noticed there is some more error output, but where am I still doing
> wrong?
>
> I have this one in my /etc/freetds/freetds.conf also:
>
> [sqlexpress]
> host = 172.16.16.254
> port = 1433
> tds version = 8.0
>
> Any help will be appreciated, thanks!
>
> Flavio Boniforti
Flavio,
Start by using the unixODBC tool "osql" which is a shell script which
tries to discover the correct parameters to pass to isql.
-Peter
-
[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, 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.