Skip to Content.
Sympa Menu

freetds - Re: [freetds] MSSQL2005 with FreeTDS problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Vaughan" <dvaughan AT am-a.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MSSQL2005 with FreeTDS problem
  • Date: Thu, 14 Jun 2007 14:18:43 -0700

Do you know if "libtdsodbc" was replaced with "libtds.so" in the FreeTDS 0.64
package? I just installed FreeTDS 0.64 and this is the only library file I
see that is close to the older version I had been using. Not sure if this is
the file I should be looking for to connect to MSSQL 2005.

This is what I had been using to access our MSSQL 7 db, before we move to
MSSQL 2K.
[TDS]
Description = FreeTDS 7.0
Driver = /usr/lib/libtdsodbc.so
FileUsage = 3

>-----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
>




Archive powered by MHonArc 2.6.24.

Top of Page