Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: changing database with DBI and DBD-ODBC

by mje (Deacon)
on Sep 24, 2012 at 20:25 UTC ( #995437=note: print w/ replies, xml ) Need Help??


in reply to changing database with DBI and DBD-ODBC

roboticus is correct as far as changing the database after you have connected. However another way is to use a DSN-less connection where you specify the database at connect time. For this you use a connect string like "DRIVER={SQL Server};Database=mydatabase;UID=username;PWD=password;" where "SQL Server" is the ODBC driver named shown in the ODBC Administrator drivers tab. This way you don't have to create a DSN beforehand and can connect to any database at connect time. If you search for SQL Server connection strings you'll find other attributes MS SQL Server can take.


Comment on Re: changing database with DBI and DBD-ODBC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://995437]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (9)
As of 2014-08-28 11:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (259 votes), past polls