Jaspersoft Server : How to connect sql server JDBC with database name containing space

[heri.susanto]

Hi,

I have succesfull connected my database to Jaspersoft Studio using curly braces, I also need to create data source in Jaspersoft server using the same database but problem using curly braces.

Url : jdbc:sqlserver://192.170.170.3:1433;databaseName={Astrindo Starvision [Operational]_tes}

Error : The JDBC URL contains invalid characters. You might have mistyped it

Please help

Thanks

[sadakar]

Choose the exact driver class ..

Below image will be helpful to you.

/sites/default/files/images/answer.png

After selecting the URL will generates in JDBC URL section.. give connection according to generated syntax and test it with your credentials.

The same works in Jasper Server.

 

Thank you