Well Iam afraid you cannot do the below using ADO. (creating database).

Why cannot you use Firebird API or use command shell (cmd invocation) and create a database using batch script.
See the gsec utility for more information.

Once you create a database, then you can make a connection.
The above is true for embedded databases.

Second option:
Try connecting to the security database using sysdba
And then use "create database 'localhost:d:\firebird\databases\mydb.fdb';" in the sql and execute.

I havent tried the second option but iam guessing it would work.

Thanks !
- Goutam

> -----Original Message-----
> From: Mª José Sempere [mailto:mjose@...]
> Sent: Wednesday, December 29, 2004 12:18 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support]
>
>
>
>
> Hello,
>
> I'd like to create a firebird database using ADO or ADOX libraries.
>
> First I tried with ADO (as I do when I work with SQL Server):
> If I'm working With SQL Server I do the following steps:
>
> 1 . Open an ADODB connection against the server (without
> opening any database in particular)
> 2. Execute a comand "Create Database ..."
>
> I can't do that with Firebird, because it doesn't let me open a
> connection without opening a database at the same time. And
> if a open a
> database, and try to execute a "create database ..." it
> answers me that
> a database is already openened.
>
> Second I tried with ADOX (as I do if I work with Access):
>
> I try to execute a ADOX.Catalog.Create instruction, but
> the provider
>
> (LCPI.IBProvider ) answers that "the interface is not
> compatible"
>
>
> Can anybody help me? I don't want to use a .net provider,
> because I'm programming unmanaged code.
>
> Thank you very much for your help
>
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Make a clean sweep of pop-up ads.
> Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.