Create database from asp.net
-
i have to create database(create database dbname) from asp.net into sqlserver 2005, i m accepting server ip/name, uid, pwd to connect. How to do that ? need help Thanks in advance.
-
i have to create database(create database dbname) from asp.net into sqlserver 2005, i m accepting server ip/name, uid, pwd to connect. How to do that ? need help Thanks in advance.
You need to have permission for creating database Then, all you need to do is to execute the correct instructions to create the database and structure CREATE DATABASE ... Just script out any of your exiisting databases to see the syntax
Alexei Rodriguez
-
i have to create database(create database dbname) from asp.net into sqlserver 2005, i m accepting server ip/name, uid, pwd to connect. How to do that ? need help Thanks in advance.
dream_liner_7e7 wrote:
i have to create database(create database dbname) from asp.net into sqlserver 2005,
you can create using CREATE DATABASE command.
dream_liner_7e7 wrote:
i m accepting server ip/name, uid, pwd to connect. How to do that ? need help
Why you are trying to do so? means each client will able to create database in server ?:confused: X| or what ?
cheers, Abhijit
-
dream_liner_7e7 wrote:
i have to create database(create database dbname) from asp.net into sqlserver 2005,
you can create using CREATE DATABASE command.
dream_liner_7e7 wrote:
i m accepting server ip/name, uid, pwd to connect. How to do that ? need help
Why you are trying to do so? means each client will able to create database in server ?:confused: X| or what ?
cheers, Abhijit
Basically i m creating a web based installer where users will create database and execute sqlscript on there hosting server, that y i need hosting server ip, uid, pwd. The create database dbname will run for the first time to create the database then executing sqlscript will create structure in that database. thats y i was confused how to create DB on the fly.