| Author |
Message |
Mansso
Newbie
Joined: 25 Sep 2015
Location: Russian Federation
Online Status: Offline
Posts: 6
|
   Topic: Connect to SQL DB
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
|
 IP Logged |
|
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
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.
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
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
|
|
|
|
IP Logged |
|
Mansso
Newbie
Joined: 25 Sep 2015
Location: Russian Federation
Online Status: Offline
Posts: 6
|
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.
|
|
IP Logged |
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
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.
|
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
Posted: 07 Dec 2015 at 4:05am |
|
I believe it was available in 2008.
-Dell
|
|
|
|
IP Logged |
|
Mansso
Newbie
Joined: 25 Sep 2015
Location: Russian Federation
Online Status: Offline
Posts: 6
|
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?
|
|
IP Logged |
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
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.
|
|
IP Logged |
|
Mansso
Newbie
Joined: 25 Sep 2015
Location: Russian Federation
Online Status: Offline
Posts: 6
|
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
|
|
IP Logged |
|
|
|
