FreeTDS Development Group

["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

> 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