Hyphen in SQL Database name
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17436
Printed Date: 02 May 2024 at 11:11am
Topic: Hyphen in SQL Database name
Posted By: aboody
Subject: Hyphen in SQL Database name
Date Posted: 28 Aug 2012 at 10:00pm
|
I am using Crystal Reports XI R1 11.0.0.2495 , trying to connect to SQL database that has hyphen in the database name , how can i do that
|
Replies:
Posted By: hilfy
Date Posted: 29 Aug 2012 at 3:34am
|
What type of connection are you using? I'm not sure that Crystal will connect using OLEDb because of the hyphen. So, I would try creating an ODBC connection that takes care of specifying the database connection and use that in your report. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: aboody
Date Posted: 29 Aug 2012 at 10:13am
Dear Dell
Thanks for your reply
The problem is solved by just clicking the following 2 options while creating the Data source ODBC which i use to connect to the database from Crystal Report .
Here are the 2 options :-
Use ANSI quoted Identifiers
Use ANSI Nulls , paddings and warnings
Once i ticked these 2 options , i successfully connected to the database from Crystal Report.
Aboody
|
|