Skip to Content.
Sympa Menu

freetds - Re: FreeTDS (?) 0.52 problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Patrick" <pdennisau AT aol.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: FreeTDS (?) 0.52 problem
  • Date: Tue, 29 Jan 2002 01:47:20 -0500


> Brian Bruns wrote:
>
> > On the sql server your user has a 'default database' set. If one is not
> > set then you are put in the master database and must 'use' the desired
> > database, so in answer to your question the problem is in the user set up
> > on the SQL Server, not freetds, dbd::sybase, or dbi.
>
> OK. Thanks!

I am having similiar problems and I had a question about this. I have a
single user that several jobs run as that one user. These jobs connect to
several different databases on the same server. My question is, can you
setup the DSN to specify a database to login into that is not the default
database for that user? I don't want to have all of my scripts select the
database in a do statement, that kinda defeats the purpose of having
multiple DSN entries in your conf file.

I want the freetds.conf file to look like this but it doens't work:

[foo]

host = 10.0.0.1
database = not_default_db
port=1433
tds version = 7.0

Any ideas?

BTW, I have FreeTDS version 0.53 built on Redhat 7.2 and I use DBD::Sybase
to connect to a SQL Server 7.0 on a Win 2K box.

Thanks in advance.

-Patrick








Archive powered by MHonArc 2.6.24.

Top of Page