FreeTDS Development Group

["David Vaughan" <dvaughan AT am-a.com>]

Thank you Christopher. I will install FreeTDS 0.64 and see where that gets 
me. 

>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of Thomas,
>Christopher (LLU)
>Sent: Thursday, June 14, 2007 12:27 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] MSSQL2005 with FreeTDS problem
>
>
>Hello,
>
>I don't have a SQL Server 2005 box but I bet you are running a FreeTDSS
>that's too old. It probably came out before MSSQL Server 2005 was out.
>Try a newer version. v0.62.1, eh? Did you use the rpms from the ftp
>site? If you used the rpms, then I bet you are afraid to compile stuff.
>But don't be afraid to compile FreeTDS on Fedora because it is real
>simple. I'm thinking about writing an article or something so people
>will know how to do it.
>
>Here are the steps:
>
>1) make sure you have the development stuff (gcc, rpmbuild, etc.)
>installed on your system.
>2) make sure you have the unixodbc-devel package installed on your
>system.
>3) if you don't have a build environment setup, here is how to create
>one:
>
># mkdir -p $HOME/rpmbuild/{BUILD,RPMS,SOURCES,SPECS,SRPMS}
># echo "%home %(echo $HOME)" >> $HOME/.rpmmacros
># echo "%_topdir     %{home}/rpmbuild" >> $HOME/.rpmmacros
>
>4) download the latest stable version of FreeTDS from their website.
>5) rename the download file from freetds-stable.tgz to
>freetds-0.64.tar.gz
>6) compile the code and make rpm packages:
>
># rpmbuid -tb freetds-0.64.tar.gz
>
>
>
>Now you should have the freetds rpms sitting in your 
>$HOME/rpmbuild/RPMS
>directory. I would uninstall the old freetds rpms before installing the
>new ones. I hope these instructions help.
>
>
>Chris
>
>
>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of David Vaughan
>Sent: Thursday, June 14, 2007 11:08 AM
>To: freetds AT lists.ibiblio.org
>Subject: [freetds] MSSQL2005 with FreeTDS problem
>
>We just moved our database from MSSQL 7 to MSSQL 2005 and my ability to
>connect to the db is gone. My Freetds version is 0.62.1 and my UnixODBC
>version is 2.2.8. I've changed the odbc.ini and freetds.conf to reflect
>the new server/db info and I've been able to connect though 
>TSQL but not
>ISQL. I'm wondering if it's a driver issue I should be looking to
>upgrade both FreeTDS and UnixODBC or if it's just FreeTDS that 
>needs the
>upgrade (to 0.63). 
>
>---------------------------
>
>[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>[ISQL]ERROR: Could not SQLConnect
>
>-------------------------
>
>
>Thank you all very much!
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>