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

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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

heri.susanto's picture
Joined: Apr 28 2015 - 6:56pm
Last seen: 7 years 1 month ago

Choose the exact driver class ..

Below image will be helpful to you.

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

sadakar - 7 years 1 month ago

0 Answers:

No answers yet
Feedback