From: "Doug Loud" <[email protected]> To: <[email protected]> Date: 12/16/2008 04:27 PM Subject: How Does The DBI Know Where The Database Is? Sent by: [email protected]
We are cleaning up some code that a no longer resident programmer created.
This code works:
$dbh = DBI->connect("DBI:ODBC:GreystoneActivity","$userid", "$userpw")||
die "Couldn't connect to database: " . DBI->errstr;
But we can't figure out how the DBI:ODBC knows where the GreystoneActivity
database (an old Access database being replaced with MySQL) resides. Is
there a utility that told it the database's location?
Thanks...
Doug
check the machine that the script is running on if it is a Windows
based system
there should be a user or system DSN called GreystoneActivity that has
the details of server and database
configured on the system.
U.S. BANCORP made the following annotations
---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank you
in advance for your cooperation.
---------------------------------------------------------------------
<<image/jpeg>>
_______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
