[freetds] FreeTDS Digest, Vol 40, Issue 16

Philip Orleans philip_38 at hotmail.com
Mon May 29 16:33:37 EDT 2006


I get that error always when connecting to SQL 2005, but my application (Asterisk PBX) still works. Go figure.

> From: freetds-request at lists.ibiblio.org> Subject: FreeTDS Digest, Vol 40, Issue 16> To: freetds at lists.ibiblio.org> Date: Mon, 29 May 2006 12:00:06 -0400> > Send FreeTDS mailing list submissions to> freetds at lists.ibiblio.org> > To subscribe or unsubscribe via the World Wide Web, visit> http://lists.ibiblio.org/mailman/listinfo/freetds> or, via email, send a message with subject or body 'help' to> freetds-request at lists.ibiblio.org> > You can reach the person managing the list at> freetds-owner at lists.ibiblio.org> > When replying, please edit your Subject line so it is more specific> than "Re: Contents of FreeTDS digest..."> > > Today's Topics:> >    1. FreeTDS and SQL server 2005 (Pieter Rautenbach)> > > ----------------------------------------------------------------------> > Message: 1> Date: Mon, 29 May 2006 14:56:55 +0200> From: "Pieter Rautenbach" <parautenbach at gmail.com>> Subject: [freetds] FreeTDS and SQL server 2005> To: freetds at lists.ibiblio.org> Message-ID:> <b8ef333d0605290556q16e8c763wae22c67b01bbcc6a at mail.gmail.com>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed> > Hello Mailing List,> > I've been using FreeTDS 0.63 without problems with MS SQL server 2000.> I've just setup CentOS and configured FreeTDS with unixODBC and want> to connect to a MS SQL server 2005 database. I can connect to the DB> with both tsql and isql. However, if I set TDS_Version to 8.0 in my> odbc.ini, I get the following error:> > SQL> select getdate();> [ISQL]ERROR: Could not SQLPrepare> > If I change TDS_Version to 4.2 or 7.0 the above works.> > SQL> select getdate();> +-------------------------+> |                         |> +-------------------------+> | 2006-05-29 14:56:12.330 |> +-------------------------+> SQLRowCount returns 1> 1 rows fetched> > I would like to know whether anyone has experienced a similar problem> before or could perhaps point me to the relevent documentation if I> have missed something obvious.> > Any help would be greatly appreciated.> > Pieter Rautenbach> > > ------------------------------> > _______________________________________________> FreeTDS mailing list> FreeTDS at lists.ibiblio.org> http://lists.ibiblio.org/mailman/listinfo/freetds> > > End of FreeTDS Digest, Vol 40, Issue 16> ***************************************
_________________________________________________________________
Join the next generation of Hotmail and you could win the adventure of a lifetime
http://www.imagine-msn.com/minisites/sweepstakes/mail/register.aspx


More information about the FreeTDS mailing list