How create a new database using vbscript?

[seidel]

Hello!, How create a new database using vbscript, but with input user on filename?

Please helpme!
thanks

 

[alistairpaul]

What type of database? MS Access, SQL Server, other?

Some ways are below:

==== MS Access ====
Create a standard blank MS Access MDB file, named "DEFAULT.MDB"
When ready to create a new database, copy the "DEFAULT.MDB" file to the filename that the user provided, then use this database accordingly.


==== SQL Server ====
Whatever application/script you're using needs to have permissions to create databases on the server. Then simply call the CREATE DATABASE commands with your user-provided name, and any options you want, and use this database accordingly.

Hope it helps.

 

[seidel]

many thanks for your advice!, I need create an access database.

thanks

 

[jonscott8]

Use ADOX,

SET oCat = CreateObject("ADOX.Catalog&quot
oCat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ADOX.mdb"
oCat.ActiveConnection.Close
SET oCat = Nothing

or automate Access if it's installed,

SET oAccess = CreateObject("Access.Application&quot
oAccess.NewCurrentDatabase "C:\Access.mdb"
oAccess.CloseCurrentDatabase
oAccess.Quit
SET oAccess = Nothing Jon Hawkins

 

[seidel]

Many thanks! I will try!