Crystal Reports XI period in database name

35 pts.
Tags:
Crystal Reports
Crystal Reports XI
SQL Server 2005
SQL Server 2005 Database
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

Software/Hardware used:
Crystal Reports XI, VS 2008
ASKED: February 2, 2011  12:12 AM
UPDATED: January 13, 2012  8:27 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

We ran into the same problem and the only fix we could find was to recreate the database without the “.’ In the name. It is a bad DBA practice to use special characters in the database name.

The best solution would be to rename the database. You don’t need to delete and then create it again. I would guess that is not an option in your case. If it is, then do it.

Usually, you can solve the problem of special characters in database or object names by enclosing the name in square brackets. For example, [data.12].

I agree that it is bad design to use special characters in database or object names. However, sometimes we are left with other people’s design and must work around it.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following