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: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS (?) 0.52 problem
  • Date: Tue, 29 Jan 2002 21:10:27 -0500 (EST)


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')
>







Archive powered by MHonArc 2.6.24.

Top of Page