FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Hi,

The ODBC Driver supports this via the Database option in the odbc.ini.  
With DBD::Sybase you can specify in the DBI->connect statement by saying 

DBI->connect("dbi:Sybase:server=myserver;database=mydb","user","password")

if memory serves.

Brian

On Tue, 29 Jan 2002, Patrick wrote:

> > 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
> 
> 
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>