Re: FreeTDS on Debian: connect to MSSQL with ODBC fails
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2011/1/14 Boniforti Flavio <[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 > 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds