create failed for database error in c# smo database creation

Question

0.00/5 (No votes)

See more:

, +

hi friends I want to create sql database on client pc through coding using smo
I am using following code to create database on client pc but it gives me an error that "create failed for database "database name""
my code is

C#

string srvname = "MY-PC/SPARTAN";
Server srv;
srv = new Server(srvname);
Database db;
db = new Database(srv, "iji");

but at last line it gives above error .please help me.

Posted 25-Nov-11 2:49am

maheshpardeshi

Updated 25-Nov-11 3:59am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Geoff Williams · Answer 1 · 2011-11-25T03:18:00

Solution 1

You use a backslash to separate the server name from the SQL Server database instance name. Try

C#

string srvname = "MY-PC\\SPARTAN";

Posted 25-Nov-11 3:18am

Geoff Williams

Comments

maheshpardeshi 25-Nov-11 9:35am

DataTable dataTable = SmoApplication.EnumAvailableSqlServers(false);
I have use it it directly takes instance name & it is
"MY-PC\\SPARTAN" then also geting error

create failed for database error in c# smo database creation

1 solution

Solution 1

Add your solution here

Preview 0

create failed for database error in c# smo database creation

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us