on 12-28-2015 12:48 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.