Skip to Content.
Sympa Menu

freetds - Re: [freetds] changing database- newbie question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Dan Wierenga <dan AT hornytoad.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] changing database- newbie question
  • Date: Wed, 21 Jul 2004 12:51:47 -0700

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




Archive powered by MHonArc 2.6.24.

Top of Page