Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: changing database with DBI and DBD-ODBC

by roboticus (Chancellor)
on Sep 24, 2012 at 19:52 UTC ( #995435=note: print w/replies, xml ) Need Help??


in reply to changing database with DBI and DBD-ODBC

BeneSphinx:

I generally do this:

$DB->do("use new_database");

after the connection is successful to move to the other database.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Replies are listed 'Best First'.
Re^2: changing database with DBI and DBD-ODBC
by BeneSphinx (Acolyte) on Sep 24, 2012 at 20:14 UTC
    roboticus: That worked for me. Thanks! I tried this earlier and for some reason it didn't work for me, but I must not have done it properly. It now works for me both with do() and also with prepare()/execute() (my favorite approach).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://995435]
help
Chatterbox?
[stevieb]: I went on my merry way writing a cross-platform, network-aware system that works across Perlbrew and Berrybrew systems and runs unit tests for Perl dists on all installed versions, with the ability to manage *brew commands themselves
[stevieb]: That worked out exceptionally well, as when I started that project, I hadn't delved into hardware development yet.
[stevieb]: found a issue in MetaCPAN::Client though today for my revdep tests. At least I think it's an issue
[stevieb]: I'm working on hiding the fact the software needs MetaCPAN::Client, as I often have a hell of a time installing it. I'm going to change it to let the user know if they do revdep that it needs to be installed, and remove that distribution ..
[stevieb]: ...from being a prereq

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2017-06-25 23:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (572 votes). Check out past polls.