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: "Boniforti Flavio" <flavio AT piramide.ch>
  • 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 11:54:45 +0100

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

> 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

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




Archive powered by MHonArc 2.6.24.

Top of Page