Re: CREATE DATABASE fails in DBD::ADO 2.75-2.83

Ed Belisle wrote: > 1. Yes. All I need to do is detect errors. If there's no error, > excecution continues. I hope for a discussion at dbi-dev: > My current workaround is to shell these commands to osql. Doesn't loc

Re: CREATE DATABASE fails in DBD::ADO 2.75-2.83

Ed Belisle wrote: > support for CREATE and DROP DATABASE appears to have stopped working > between DBA::ADO versions 2.74 and 2.75. I have tested with MDAC 2.7 > SP1 and MDAC 2.8 RTM, and all DBD::ADO Versions from 2.70 through 2.83. Sorry for the late reply! Indeed, 2.75 reports more errors. I

RE: Create database

$db is your database name. So how do you connect and talk to MySQL without an existing database with DBI? A > -Original Message- > From: Andrew Brosnan [mailto:andrew@;broscom.com] > Sent: Friday, October 18, 2002 1:54 PM > To: Hardy Merrill > Cc: Post; [EMAIL PROTECTED] >

Re: Create database

On 10/18/02 at 2:43 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote: > Andrew Brosnan wrote: > > Did you try it? This works for me (notice there's no database specified > in the connection): > > my $dbh = DBI->connect("dbi:mysql:"); > $dbh->do("CREATE DATABASE $new_db"); > $dbh->do("USE $new_d

Re: Create database

On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote: > What database are you using? Not sure why it would matter, but MySQL. I'm not talking about installing a db program here; just exectuing some SQL like I might from the shell: CREATE DATABASE DatabaseName; > Have you installed t

Re: Create database

What database are you using? Have you installed the DBI module and the DBD module for your database? Since you referred to "datasource", I'm guessing you're on a Windows platform - is that right? Some more info would be helpful. -- Hardy Merrill Senior Software Engineer Red Hat, Inc. Andrew

Re: Create database

On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote: > Andrew Brosnan wrote: > > > On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote: > > > >>What database are you using? > >> > > Not sure why it would matter, but MySQL. > > > Yes it matters. This works for me using

Re: Create database

Andrew Brosnan wrote: On 10/18/02 at 4:26 PM, [EMAIL PROTECTED] (Hardy Merrill) wrote: What database are you using? Not sure why it would matter, but MySQL. Yes it matters. This works for me using MySQL: my $existing_db = $your_old_db_here; my $new_db = $your_new_db_here; my

Re: Create database

Andrew Brosnan wrote: On 10/18/02 at 2:10 PM, [EMAIL PROTECTED] (Jeff Zucker) wrote: > ... > Yes Jeff, I thought the same thing. But that won't work for me in this > case. I need to be able to create a new db without assuming that there > is an existing one (or at least I might not know what it

RE: Create database

;y')"); > > $dbh->do("insert into db (host, db, user, select_priv, insert_priv, > update_priv, delete_priv, create_priv, drop_priv, grant_priv, > references_priv, index_priv, alter_priv) values > ('$ip','$database_name','$user',&

Re: Create database

What about $dbh->do() ? Brian McCain PageMasters Internet Group - Original Message - From: "Andrew Brosnan" <[EMAIL PROTECTED]> To: "Post" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 12:24 PM Subject: Create database | Hello List, | | I'm looking to *create

Re: Create database

Andrew Brosnan wrote: I was hoping the code could be database independent (excepting of course the driver) CREATE DATABASE is not part of either SQL92 or SQL99. They have a CREATE SCHEMA syntax. But, AFAIK, most implementations do have a CREATE DATABASE command anyway. -- Jeff

Re: Create database redux

Glen, > Whoops! Misspoke there the first time... > > I asked "Is it possible without using the ODBC administrator?" > > I meant, is it possible to create the databases in perl instead of > first creating them in Access? > > Glen I think the 'cheat' posted in response to your original post wa

RE: Create database

Here's a cheat. 1) create, using MS Access, and EMPTY MDB file, no tables, nothing. 2) to create the db on the fly, then copy that file to your file when you need to... 3) don't use a pre-configured DSN, just use the dsn-less approach. Example (using MS Access): my $DSN = 'driver=Micro