cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft SQL Connection Database Name with Space

0 Kudos

Hi Experts,

I'm trying to connect to a Microsoft SQL Server 2008 database through the DBCO in SAP. I have noticed that any database with a space in the name, I cannot connect to. I have tried with other database name which doesnot contains space , connection established sucessfully.

I have tried below :

Enclose name in []

Enclose name in {}

Enclose name in ``

It does not seem to work. Here is my connection string code:

DataBase Name : WIN-PAK PRO

Kindly advice to resolve these issue .

Waiting for reply..

Regards,

Saurabh Madurwar

9890486391

Accepted Solutions (1)

Accepted Solutions (1)

cherry_tian
Explorer
0 Kudos

Hi, Saurabh

The string of CON_ENV is

MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name> MSSQL_SCHEMA=

MSSQL_SCHEMA is a optional.

In the CON_ENV, a space is an identifier that the previous envirioment is definied and you will start  a new enviroment after the space.


I am afraid DBSL cannot handle the remote database name which contains a space.

Is it possible to change the remote DB name? If it is not possible or easy to do that, I suggest creating a new DB with a name without space using the backup file of database WIN-PAK PRO?

Best regards.

Cherry.

0 Kudos

Thank you Cherry.

You are right i need to request technical team to create new DB name without space using the backup

file of database WIN-PAK PRO.

Regards,

Saurabh

Answers (1)

Answers (1)

0 Kudos

I think, no need to change the database name, you can simply enter the database name without any [] or {} or ''

I have tried and its working perfectly for me