Crystal Reports XI period in database name
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
Software/Hardware used:
Crystal Reports XI, VS 2008
ASKED:
February 2, 2011 12:12 AM
UPDATED:
January 13, 2012 8:27 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
