Skip to Content.
Sympa Menu

freetds - Re: FreeTDS/SQL Server 2000 Woes...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS/SQL Server 2000 Woes...
  • Date: Sun, 27 Jan 2002 00:46:29 -0500 (EST)



Ok, let's cut out ODBC and make sure the base package is working. Grab
SQSH (http://www.sqsh.org) and build it (instructions are in the users
guide, but basically just set $SYBASE and then './configure;make'). Let's
see if that will attach to your server.

Brian

On Sat, 26 Jan 2002, Casey Allen Shobe wrote:

> On Saturday 26 January 2002 22:49, Brian Bruns wrote:
> > The Servername field in the odbc.ini should refer to the symbolic name of
> > your database server in the freetds.conf (recommended) or interfaces file.
> > In your case this is 'pivotal'.
>
> I tried that. It is now set that way in the file.
>
> > The second thing is, you are using the default TDS version, and since you
> > didn't like the configure line used to build FreeTDS it would be 5.0 by
> > default which wont work with SQL Server 2000.
>
> I used --with-tdsver=4.2. Here is my installation log:
>
> unixodbc-2.1.1 installed with the following options on Sat Jan 26 19:56:11
> EST 2002
> ./configure --prefix=/usr --sysconfdir=/etc --enable-gui &&
> make &&
> make install
>
> freetds-0.53 installed with the following options on Sat Jan 26 20:49:12
> EST
> 2002
> ./configure --prefix=/usr --sysconfdir=/etc --with-tdsver=4.2
> --with-unixodbc=/usr &&
> make &&
> make install
>
> > You can either recompile freetds using the --with-tdsver flag, replace
> > "ether" with "4.2" (or "7.0" if you want to use that version), or switch
> > to using the freetds.conf file and set 'tds version = 4.2'.
>
> I've tried using freetds.conf, however had the same results. And the
> instructions that I found at unixodbc.org cover only interfaces, so I stuck
> with that for the time being. I'd be happy to try using freetds.conf
> again.
> Here's my current backup, does it look correct?:
>
> [global]
> tds version = 4.2
> initial block size = 512
> swap broken dates = no
> swap broken money = no
> try server login = yes
> try domain login = no
> cross domain login = no
> [pivotal]
> host = 192.168.24.182
> port = 1433
> tds version = 7.0
>
>





Archive powered by MHonArc 2.6.24.

Top of Page