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: "Thomas, Christopher (LLU)" <cwthomas AT llu.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MSSQL2005 with FreeTDS problem
  • Date: Thu, 14 Jun 2007 15:46:19 -0700

Look in your $HOME/rpmbuild/RPMS directory and install all the rpms in
there. I would guess you would have problems with the rpm from
opensuse.org because it was built for Fedora 5.

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 2:54 PM
To: FreeTDS Development Group
Subject: Re: [freetds] MSSQL2005 with FreeTDS problem

http://software.opensuse.org/download/home:/rkwasny/Fedora_Extras_5/i386
/freetds-unixodbc-0.64-3.1.i386.rpm

This is the only one I found, I hope it's ok to use it.

>-----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 2:29 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] MSSQL2005 with FreeTDS problem
>
>
>Make sure you have the freetds-unixodbc-0.64-1 rpm installed. This is
>the rpm that contains the /usr/lib/libtdsodbc.so file. When I compiled
>FreeTDS, I just installed all the FreeTDS packages in my
>$HOME/rpmbuild/RPMS directory so I wouldn't have to worry about missing
>files and stuff.
>
>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 2:19 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] MSSQL2005 with FreeTDS problem
>
>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
>>
>_______________________________________________
>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
>
_______________________________________________
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