Crystal Reports Server 2011

[Former Member]

I have been working with Crystal Reports 2011 and have created many reports. Some reports have parameters (for example date range). I am using MS SQL server 2008. All the reports work fine on windows 2008 server and windows 7. However, we purchased crystal reports server 2011 and install it on MS server 2012 R2. I am trying to post the reports in the crystal reports server 2011 and all the reports with the parameters give me the following error.

crystal2011error.txt.zip

[Former Member]

I installed the native client 10 as you suggested and created ODBC connection. But still having the same issue.

[DellSC]

Ok, now that you have the correct driver installed, you need to go to the Business View Manager (BVM), which is where you manage the objects that are used to create dynamic prompts in Crystal.  Unfortunately, the Data Connections in BVM include information about which db driver is used in the connection.  So, all of them are pointing to the older version of the SQL Server client driver that isn't working. This is the pain-in-the-neck part of the process....

1.  Find each Data Connection (object name should end in "_DC".)  For each, create a new connection using the new client that you've installed.  This would be a good time to reorganize and create a single Data Connection for each database instead of having one for each prompt, which is what happens when dynamic prompts are created within Crystal instead of creating them in the BVM and then using them in Crystal.

2.  Find each Data Foundation (object name should end in "_DF").  Change the connection on the Data Foundation so that it points to the appropriate new Data Connection.

3.  Delete the old Data Connections as they will not be used again.

-Dell

[Former Member]

I am not using native client. I am using crystal reports 11 as a client and ODBC connection.

It is working fine on windows 7 clients and MS server 2008 R2.

[DellSC]

The "Native" client is not a native connection to Crystal.  There are a number versions of the SQL Server database drivers.  The plain "SQL Server" ODBC client that is automatically installed with Windows will not work correctly with Crystal and SQL Server 2008.  You need to go to MSDN and search for "SQL Server Native Client 10", install that, and then create your ODBC connection based on that in order to get Crystal to connect to your database.

-Dell

[DellSC]

Has the SQL Server Native Client 10 or 11 been installed on the server?  Are you using OLE DB or ODBC connections? If it's ODBC, have you configured the appropriate ODBC connections on the server?

-Dell