RE: How to use perl dbi to create a database

2010-07-02 Thread Sharma, Sumit
Hello All, Thanks for your suggestions. I have following code written to list all available drivers along with respective data-sources. But, I get some errors for Oracle driver, can anybody please suggest the solution? Thanks === #!/usr/local/bin/perl use DBI; # for

Re: How to use perl dbi to create a database

2010-07-02 Thread Martin J. Evans
Sharma, Sumit wrote: Hello All, Thanks for your suggestions. I have following code written to list all available drivers along with respective data-sources. But, I get some errors for Oracle driver, can anybody please suggest the solution? Thanks ===

Re: How to use perl dbi to create a database

2010-07-02 Thread John Scoles
Sharma, Sumit wrote: Hello All, Thanks for your suggestions. I have following code written to list all available drivers along with respective data-sources. But, I get some errors for Oracle driver, can anybody please suggest the solution? Thanks === #!/usr/local/bin/perl

Re: How to use perl dbi to create a database

2010-06-29 Thread Darren Duncan
Owen wrote: On Mon, 28 Jun 2010 04:51:45 -0400 Sharma, Sumit sumit.sha...@aeroflex.com wrote: 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

Re: How to use perl dbi to create a database

2010-06-29 Thread Ashish Mukherjee
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#data_sources This is how you can check for existence of a database. - Ashish On Mon, Jun 28, 2010 at 2:21 PM, Sharma, Sumit sumit.sha...@aeroflex.comwrote: Hello, I am trying to use Perl to identify if a given database exists or not and if it

Re: How to use perl dbi to create a database

2010-06-29 Thread Martin Evans
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

How to use perl dbi to create a database

2010-06-28 Thread Sharma, Sumit
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

Re: How to use perl dbi to create a database

2010-06-28 Thread Owen
On Mon, 28 Jun 2010 04:51:45 -0400 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