HCI - SQL database name with special character

[Former Member]

Hi all,

In HCI, I am trying to configure a connection to a SQL database, its name is "DB_S&OP".

Here is my configuration :

When I test the connection, I receive an error message :

"Test failed for the default configuration 'default' of datastore: 'SQL_SOP': XML parser failed: See previously displayed error message."

I have tested this configuration for other database names on the same SQL server and it works fine.

The only difference is that this database contains the special character "&".

I have tried to use the escape character "\" in the database name : "DB_S\&OP" ; but it doesn't work either.

Can someone help me with this issue please ?

Thanks a lot,

Pierre

[Former Member]

Hi Pierre,

Try database name as "DB_S&ampOP".

Thanks, Nikhil

[Former Member]

Hi Nikhil,

I have tried with the name you propose but it doesn't work.

Thanks,

Pierre

[Former Member]

Pierre,

See if it works: DB_S&OP

Thanks, Nikhil