Ashish Mukherjee wrote: > http://search.cpan.org/~timb/DBI-1.611/DBI.pm#data_sources > > This is how you can check for existence of a database. > > - Ashish
That won't help you with some DBDs e.g., with DBD::ODBC this returns a list of data sources and not databases. In DBD::ODBC a data source does not have to name a database. A data source is a means to connect to a database engine and it may contain multiple databases. Usually there is some meta table where you can select the list of databases and a method of changing from one to another. As an example, when you create an ODBC data source for MS SQL Server (via the GUI ODBC Administrator) you can choose any name you like for the data source and you can pick the database or leave it to the default database but there is no direct relationship between the data source name and the database (unless you use that convention yourself). Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com > On Mon, Jun 28, 2010 at 2:21 PM, Sharma, Sumit > <sumit.sha...@aeroflex.com>wrote: > >> Hello, >> >> >> >> I am trying to use Perl to identify if a given database exists or not >> and if it doesn't create the database and then connect to it. >> >> >> >> Is there any way using Perl DBI to first identify whether a given >> database exists or not if it doesn't create the database? >> >> >> >> Sumit >> >> >> Notice: This e-mail is intended solely for use of the individual or entity >> to which it is >> addressed and may contain information that is proprietary, privileged, >> company confidential >> and/or exempt from disclosure under applicable law. If the reader is not >> the intended >> recipient or agent responsible for delivering the message to the intended >> recipient, you are >> hereby notified that any dissemination, distribution or copying of this >> communication is >> strictly prohibited. If this communication has been transmitted from a U.S. >> location it may >> also contain data subject to the International Traffic in Arms Regulations >> or U.S. Export >> Administration Regulations and cannot be disseminated, distributed or >> copied to foreign >> nationals, residing in the U.S. or abroad, without the prior approval of >> the U.S. Department >> of State or appropriate export licensing authority. If you have received >> this communication >> in error, please notify the sender by reply e-mail or collect telephone >> call and delete or >> destroy all copies of this e-mail message, any physical copies made of this >> e-mail message >> and/or any file attachment(s). >> >> >
