Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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: Fri, 14 Jan 2011 15:12:30 +0100

2011/1/14 Boniforti Flavio <flavio AT piramide.ch>:
> Back again...
>
> [cut]
>
>> Personally I execute it like
>>
>> $ perl odbctest.pl dbi:ODBC:sqlexpress user password
>> FREETDS\SQLEXPRESS
>
> My output:
>
> root@ticket:~# perl odbctest.pl dbi:ODBC:sqlexpress sa XXXXX
> EXCHANGE\SQLEXPRESS
> DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Could not
> find stored procedure 'EXCHANGESQLEXPRESS'. (SQL-42000) at odbctest.pl
> line 22.
>
> I tried removing the last parameter:
>
> root@ticket:~# perl odbctest.pl dbi:ODBC:sqlexpress sa XXXXX
> EXCHANGE\SQLEXPRESS
>

Ehmm... it was my result, not forth parameter :)
"EXCHANGE\SQLEXPRESS" is your server reply !! It's working !!

>> where sqlexpress is the same as DSN argument to isql
>
> Yes, "sqlexpress" is the same as in:
>
> root@ticket:~# isql sqlexpress sa XXXXX
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL>
>
> What's wrong with the (apparently) missing stored procedure?
>
> Thanks again,
> Flavio Boniforti
>

bye
freddy77




Archive powered by MHonArc 2.6.24.

Top of Page