Code for Building a New SQL Database.

[ac4ge]

I would like to Build a new SQL Database through VB 2005 code. I will not have the Server Name until run time. Any help on how to start the connection with a Server using a TextBox. Only items on the form is a TextBox asking for the Server Name and a build Button. Thanks for any help.

 

[cjard]

What youre looking for is a DDL tutorial

http://www.google.co.uk/search?sour...ls=GGLG,GGLG:2006-25,GGLG:en&q=SQL+Server+DDL

You can also build your database in VB2005, and then ask it for the create scripts necessary for all your tables..

 

[ac4ge]

I'am aware of that what I need is the VB code to connect to a MS-SQL server that has no Database defined and Mixed mode Security. I need to have the installer's enter in the server-name or IP address of the SQL server and go from there. Everything I have found so far has built the Connection string with known values, I will know the database-name and security but not Server-name. Thanks.

 

[cjard]

it'#s merely a matter of putting the correct connection string into the app.config file. I dont know how you would program an installer so that it creates a config file that is targeted to the server in use.. Try asking in the Deployment forum..

 

[ac4ge]

Thanks

I think that is what i'm lokking for.