CR8.5 Microsoft SQL Server?

[heuresk]

Hi,

I just reinstalled Crystal Reports 8.5 on my local machine, which is running Win 2k Server and has SQL 2000 installed on it. It used to be that when I would go to Database > Data Explorer > More Data Sources, there was a directory called Microsoft SQL Server. Now that option is no longer available, there are only Active Data, NT Archived Event Log, and NT Current Event Log directories under More Data Sources.

I just uninstalled and reinstalled CR8.5 again, and Microsoft SQL Server connection option is still not there? What's going on? Your help would be very appreciated! Thanks very much in advance.

-HK

 

[synapsevampire]

Are you using the Crystal SQL Designer?

http://support.businessobjects.com/library/kbase/articles/c2010443.asp

Once you hit CR 9 and up you can't use it anyway because you need the ODBC driver for Unicode support.

Here's the DLL for CR 7 thru CR 8.5:

http://support.businessobjects.com/communityCS/FilesAndUpdates/p2ssql.zip.asp

-k

 

[heuresk]

Thanks very much. I copied the DLL to System folder and the SQL Server option is now back!

 

[synapsevampire]

Not sure if it's the latest though.

You might try applying the service pack now:

http://support.businessobjects.com/fix/hot/si75/default.asp

Glad it worked.

-k