SQL Express Database Connection

[Former Member]

New to this community and Crystal Reports. I have done some pretty straight forward reports with either Access database's or excel files, but now i am working on connecting into a SQL database. I have been told to connect via SQL Server Native Client 11.0 via OLE DB (ADO). However when I get to screen to select SQL Server Native Client it is not an option within the provider field. I have searched all over to see if it is something i have miss installed. I have updated to CP2013 SP7 and I am running Windows 10 Pro. The database I am trying to connect to is on a Server 2012 running SQL Express 2012. Sorry if this is a newbie question, I am at my whitts end but I appreciated any help. Thanks

[abhilash_kumar]

Hi Jay,

You'd need to install the SQL Server Native Client 11.0 client software:

Download Microsoft® ODBC Driver 11 for SQL Server® - Windows from Official Microsoft Download Center

Make sure you install the 64-bit version as it installs the 32-bit version too - CR can only connect via the 32-bit driver.

-Abhilash

[Former Member]

Once I have downloaded and installed the driver is there another step I need to take as it is still not showing up in as an option in the provider field? I even rebooted just to make sure that wasn't the problem.