How can I create an SQL Connection without specifying a DB?

[catsaremyfriends]

I am trying to create an installer which runs an SQL script to create an MySQL database.

When I leave the Catalogue: Database property of the SQL Connection empty and do a build, I get the following error:

You must enter a database name for this connection.

How can I specify a connection without specifying a database?

Thanks,

cats

[Cosmin]

Hi,

I'm afraid you need to specify a database when connecting through an ODBC driver. For your connection you can specify the database you want to create and use the "Create database if it does not exist" option. This way the connection creates the database and your SQL Script can work with it.

Regards,
Cosmin