Re: FreeTDS on Debian: connect to MSSQL with ODBC fails
"Boniforti Flavio" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected]