SQLDMO attachDB error with filenames including space character

[n33470]

Hey everyone!

I'm trying to use SQLDMO to programmatically attach a database. I
have a problem when the file name includes a space character, for
example: @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf"

Here's a sample of code:

string tmp = @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" +"," +@"C:\Program
Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking_log.ldf";

SQLDMO.SQLServer sqlDMOConn = new SQLDMO.SQLServer();

sqlDMOConn.Connect("(local)", "sa", "");

sqlDMOConn.AttachDB( "DM_0814_ABCTrucking", tmp );

When I do this, the AttachDB call raised the following exception
"Device Activation Error. The physical file name 'C:\Program' may be
incorrect."

I think what's happening is that SQLDMO doesn't like the space
character in the filenames. How can I formulate the file name
correctly?

--steve

 

[n33470]

I figured it out.

Here's a link to some additional info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_80j7.asp

The problem is that the string needs to be escaped in brackets in
order to correcly process the special characters in the filename. I
knew this had to be the solution, but I didn't know what the escape
sequence was!

--steve

 

[Guest]

Hey everyone!

I'm trying to use SQLDMO to programmatically attach a database. I
have a problem when the file name includes a space character, for
example: @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf"

Here's a sample of code:

string tmp = @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" +"," +@"C:\Program
Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking_log.ldf";

SQLDMO.SQLServer sqlDMOConn = new SQLDMO.SQLServer();

sqlDMOConn.Connect("(local)", "sa", "");

sqlDMOConn.AttachDB( "DM_0814_ABCTrucking", tmp );

When I do this, the AttachDB call raised the following exception
"Device Activation Error. The physical file name 'C:\Program' may be
incorrect."

I think what's happening is that SQLDMO doesn't like the space
character in the filenames. How can I formulate the file name
correctly?

--steve

User submitted from AEWNET (http://www.aewnet.com/)

 

[Guest]

Hey everyone!

I'm trying to use SQLDMO to programmatically attach a database. I
have a problem when the file name includes a space character, for
example: @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf"

Here's a sample of code:

string tmp = @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" +"," +@"C:\Program
Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking_log.ldf";

SQLDMO.SQLServer sqlDMOConn = new SQLDMO.SQLServer();

sqlDMOConn.Connect("(local)", "sa", "");

sqlDMOConn.AttachDB( "DM_0814_ABCTrucking", tmp );

When I do this, the AttachDB call raised the following exception
"Device Activation Error. The physical file name 'C:\Program' may be
incorrect."

I think what's happening is that SQLDMO doesn't like the space
character in the filenames. How can I formulate the file name
correctly?

--steve

User submitted from AEWNET (http://www.aewnet.com/)

 

[Guest]

Hey everyone!

I'm trying to use SQLDMO to programmatically attach a database. I
have a problem when the file name includes a space character, for
example: @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf"

Here's a sample of code:

string tmp = @"C:\Program Files\Microsoft SQL
Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" +"," +@"C:\Program
Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking_log.ldf";

SQLDMO.SQLServer sqlDMOConn = new SQLDMO.SQLServer();

sqlDMOConn.Connect("(local)", "sa", "");

sqlDMOConn.AttachDB( "DM_0814_ABCTrucking", tmp );

When I do this, the AttachDB call raised the following exception
"Device Activation Error. The physical file name 'C:\Program' may be
incorrect."

I think what's happening is that SQLDMO doesn't like the space
character in the filenames. How can I formulate the file name
correctly?

--steve

Hi,

You have jsut to put the string between [ and ] .
exp : yourstringPath = "[c:\\program files\\....]";
for more info go to this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_80j7.asp

Ahmed Akrour.





User submitted from AEWNET (http://www.aewnet.com/)