create database with asp.net

[Luis Esteban Valencia]

Hello. I want to create a sql server database with my asp.net program. It
will have a textbox for server , other for username and other for password,
after it the program must execute a .sql file. Is that possible?

[Marina]

Odds are, it won't be able to execute everything in your script. For
example, it won't handle GO statements too well.

You should use SQLDMO to run the script instead, this will be like using
query analyzer.

"Luis Esteban Valencia" <le********@avansoft.com> wrote in message
news:eg****************@TK2MSFTNGP15.phx.gbl...

Hello. I want to create a sql server database with my asp.net program. It
will have a textbox for server , other for username and other for
password,
after it the program must execute a .sql file. Is that possible?

[Luis Esteban Valencia]

but how! It must be done from the asp.net page as DOTNETNUKE installation
does.
"Marina" <so*****@nospam.com> escribió en el mensaje
news:#$**************@TK2MSFTNGP12.phx.gbl...

Odds are, it won't be able to execute everything in your script. For
example, it won't handle GO statements too well.

You should use SQLDMO to run the script instead, this will be like using
query analyzer.

"Luis Esteban Valencia" <le********@avansoft.com> wrote in message
news:eg****************@TK2MSFTNGP15.phx.gbl...

Hello. I want to create a sql server database with my asp.net program. It will have a textbox for server , other for username and other for
password,
after it the program must execute a .sql file. Is that possible?

[jasonkester]

Nothing stopping you from treating that .sql file as a "GO" delimited
list of SQL statements that you can run in series.

And for what it's worth, DNN does not actually call CREATE DATABASE.
It needs you to create a database and tell it the name. It just builds
the tables the first time you run it.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

[Marina]

I've had trouble doing that. There are still things ADO.NET chokes on, even
if you break things apart by GO statements.

"jasonkester" <ja*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Nothing stopping you from treating that .sql file as a "GO" delimited
list of SQL statements that you can run in series.

And for what it's worth, DNN does not actually call CREATE DATABASE.
It needs you to create a database and tell it the name. It just builds
the tables the first time you run it.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/