Create a sql server database from a vb program
Posted on 2005-02-28
I am trying to write an installation program in vb6 that will create a SQL database with a new name, tables, etc. Until today I was using DAO, now I want to make the databases more useful through network. So I decided to use the SQL Server. I am using SQL Server 7 and 2000. I am having a database on my computer where I was writing my application. I created database using MS SQL Server 7 Enterprise Manager. Now as I have developed my application to my other computer (not plugged to network) with installed SQL Server 2000, without any database on it. I would like my application to ask me if I want to create a database (because there's no database as I install my application) on this computer and to create it for me automaticly. Is it possible with small code as with DAO?? Please help!