Graham writes "In answer http://www.4guysfromrolla.com/webtech/sqlguru/q080400-2.shtmlyou say that creating a database is as simple as executingCREATE DATABASE nameand that it's simple to port that SQL to ASP.
However, when I try to execute this SQL in ASP like so:
Set cmdFiltered = Server.CreateObject("ADODB.Command")cmdFiltered.CommandText = "CREATE DATABASE name"cmdFiltered.CommandType = adCmdTextcmdFiltered.ExecuteI get an error informing me that"Operation is not allowed on an object referencing a closed or invalid connection."
But I cannot give the command object an open connection to work with because that requires a filename and the file hasn't been created yet.
This seems to be a catch-22 that makes your SQL answer useless in ASP."