I have a Delphi program that uses an MSSQL Express database. The database should be created on installation or first startup of the Application, and here my problem starts. How can I Connect to the database server to run the "create database" script? A normal sql Connection requires a Connection string containing the DB name. Pluss i am not sure such a Connection could even do what I want.
I want to display a window to the user where he can enter the database Properties (db, username, pwd), and then i want to Connect to the server. If the database does not exsist, I want to create it.
Any suggestions?
|