create database for mssql

[CharlesMcAllister]

Please help!
I found it easy to connect TZConnection to a non-existent firebird database by specifying the 'CREATE DATABASE' sql in the TZConnection.Properties property.

However, how is this done with MSSQL 2005? (specifically i'm testing with the express edition).

How do i connect to MSSQL and create the database using ZLib?
Help is greatly appreciated.

[CharlesMcAllister]

I'm going to try using the ZPlainADO unit and create the database manually...

AConnection := CoConnection.Create;
AConnection.Open(...);
AConnection.Execute('CREATE DATABASE...');
AConnection.Close;

If someone knows a better way let me know. Thanks!

[mdaems]

Hi Charles,

You can execute this create right from a normal query component, so you don't have to use the ZPlainADO unit directly.
Query.Text:='Create...';
Query.ExecSQL
Or can't you connect to the database with a ZConnection if the database is not present? For mysql it should work this way.

Mark