FreeTDS Development Group

["Patrick" <pdennisau AT aol.com>]

> 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