Space in JDBC connection string

[lachlanwwells]

Hi there,

Any ideas how to escape a space within the database name in the JDBC string?

utils.error.code.DYNAMIC_ERROR - Illegal character in opaque part at index 62: jdbc:sqlserver://

Have tried using /, '' , "", [] to no avail!

Any thoughts?

[ybl]

You should find what you need in the Admin >> Database Drivers page of QDC. Edit the detail of SQL Server driver and you'll get capabilities to manage escape char and other interesting parameters.

[lachlanwwells]

Hi there,

We have been trying a few options with that page, but the issue is still present, even when selecting the escape characters

We are currently liasing with Qlik Support to resolve the issue as their suggestions and use of underscore as escape characters are not working.

Thanks,

Lachlan

[eeh]

Hi Lachlan,

I've been able to connect to a database with a space in the name by using "+" in place of the space.

For example, 

   jdbc:postgresql://myhost/my db

would be replaced by

   jdbc:postgresql://myhost/my+db

in the case of a Postgres database name "my db". 

Hope that helps!

--

Allen Skees