FreeTDS Development Group

["Philip Orleans" <philip_38 AT hotmail.com>]

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