FreeTDS Development Group

[Dan Wierenga <dan AT hornytoad.com>]

AFAIK, the usual way to set the DB in a Perl script is via the DBI->connect 
method:

my $dbh =  DBI->connect("dbi:Sybase:server=MyServerName;database=MyDBName", 
'username', 'password');

MyServerName is a server entry defined in the freetds.conf file.

Bort, Paul wrote:
> I never did get the configuration for this right, so I forced it. All of my
> Perl scripts that use FreeTDS start with this:
>
>   $dbihandle->do( "use $dbname;" );
>
> It's probably not the right way, but it works.
>
>
>
>
> > -----Original Message-----
> > From: Nicki Handy [mailto:nhandy AT assumption.edu]
> > Sent: Wednesday, July 21, 2004 3:26 PM
> > To: freetds AT lists.ibiblio.org
> > Subject: [freetds] changing database- newbie question
> >
> >
> > Hi- I've got everything running - dbd, dbi for sybase etc. 
> > But I know along
> > the way I set the database somewhere and I can't remember 
> > where I did it. I
> > tried to just edit the odbc.ini file to the database I want 
> > to be hitting
> > but that's not working- still hitting the old one. I'm 
> > thinking during the
> > dbi installation I set the database and user name and 
> > password and I'm not
> > sure what it does with that info but where ever it goes I 
> > need to change it.
> > Any ideas?
> > Thanks so much,
> > Nicki
> >
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

--
Dan Wierenga
IT Manager
HornyToad Inc.
mailto:dan AT hornytoad.com