Re: CREATE DATABASE via ADO/OLEDB/ODBC

Pedro, I haven't try this but throwing out as a suggestion. Try connecting to sysmaster@dbserver and once you have established your ADO connection you can execute sql statement on the connection to create another database@dbserver database instance. You could then close the original connection and connect to new database or depending upon your application architecture you could just use the original connection always and reference tables in the new database prefixed with the new database name. Hope this helps, Gregg Walker "Pedro Mendoza" <pedro.mendoza@adpclearing.com> wrote in message news:f27d7edb.0308271119.39bac849@posting.google.com... > Hello everybody, > > Is it possible to do a CREATE DATABASE via ADO using IFX OLEDB or IFX > ODBC ?, apparently there is a connection string parameter named > connectdatabase that allow to establish server-only (not database) > connections (connectdatabase=NO), but it does not work for me (work=NO > ??? ;-) ...) > > TIA, > Pedro

Gregg/Jonathan, Thank you both for your answers, I had tried your suggestions, but unfortunately without success ADO/IFX OLEDB/IFX ODBC will not let you connect to a database server without specifying a database, and will not, neither, let you issue a "create database ..." statement on a connection, so I have not choice but asking tha DBA to sun the initial script Thanks again, Pedro "Gregg Walker" <gregg@rrmca.com> wrote in message news:<qJ44b.229263$cF.74766@rwcrnsc53>...