Gordon Hughes
asked on
Connection issue
What connection type to i use to connect Crystal Reports to an SQL express database?
Gordon
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Gordon Hughes,
You can use Microsoft OLE DB Provider for SQL Server.
Here is below two examples:
https://stackoverflow.com/questions/18354952/how-to-connect-crystal-report-in-vs-2012-to-sql-server-2008
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm
For SQL Server 2016:
you can Create New Connection, Please selected OLE DB (ADO). In OLE DB Provider, I selected Microsoft OLE DB Provider for SQL Server. In the Connection Information, I entered ServerName\SQLEXPRESS, checked Integrated Security and selected Database.
You can use Microsoft OLE DB Provider for SQL Server.
Here is below two examples:
https://stackoverflow.com/questions/18354952/how-to-connect-crystal-report-in-vs-2012-to-sql-server-2008
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm
For SQL Server 2016:
you can Create New Connection, Please selected OLE DB (ADO). In OLE DB Provider, I selected Microsoft OLE DB Provider for SQL Server. In the Connection Information, I entered ServerName\SQLEXPRESS, checked Integrated Security and selected Database.
ASKER
Sorted
Thanks for all the support
Thanks for all the support
mlmcc