Crystal Reports Hyphen in SQL Database name

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: Hyphen in SQL Database name

Author	Message
aboody Newbie Joined: 28 Aug 2012 Online Status: Offline Posts: 2	Topic: Hyphen in SQL Database name 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
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	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 www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

aboody Newbie Joined: 28 Aug 2012 Online Status: Offline Posts: 2	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
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.