Print Page | Close Window

Connect to SQL DB

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=21702
Printed Date: 19 Apr 2025 at 12:02am


Topic: Connect to SQL DB
Posted By: Mansso
Subject: Connect to SQL DB
Date Posted: 27 Sep 2015 at 7:18pm
Hi. I have a problem.Can smbd help me? I try to connect to SQL-server,but don;t see mdf-files. Try to connect by XML-files and get error:
Query engine error:NO database DLL has been specified


Replies:
Posted By: kevlray
Date Posted: 28 Sep 2015 at 4:18am
First off how are you trying to connect (ODBC, OLE, etc.).  Second, I do not recall being able to 'see' the mdf files when connecting to an MS-SQL server.

Posted By: hilfy
Date Posted: 28 Sep 2015 at 2:41pm
If you're connecting to SQL Server, you will give it the server name, database name, and credentials. You won't ever connect to a specific file. So, you'll need to either set up an ODBC connection (32-bit only!) or use OleDB to connect to the database.

-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: Mansso
Date Posted: 07 Dec 2015 at 2:32am
Guys,i need to make Dataset XMl. I need XML-connection,but i don't see Ado.net in Create new connection.

Posted By: kevlray
Date Posted: 07 Dec 2015 at 4:01am
I know that ADO.Net (XML) is available in Crystal Report 2011.  Not sure when it was introduced.

Posted By: hilfy
Date Posted: 07 Dec 2015 at 4:05am
I believe it was available in 2008.

-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: Mansso
Date Posted: 07 Dec 2015 at 5:47pm
So..why dataset ADO.net xml is not in the options?Or,mb,i a, doing smth wrong?

Posted By: kevlray
Date Posted: 08 Dec 2015 at 4:07am
When you installed Crystal Reports.  Did you select all possible data sources to install.  By default Crystal Reports does not install all of them.

Posted By: Mansso
Date Posted: 08 Dec 2015 at 5:43pm
Originally posted by kevlray

When you installed Crystal Reports.  Did you select all possible data sources to install.  By default Crystal Reports does not install all of them.


Yes, the problem was due to the fact that not all the elements are installed


Print Page | Close Window