3 Replies Latest reply: Nov 9, 2010 6:19 PM by Don Williams RSS

Crystal 2008 SQL OLE DB (ADO) connectivity errors to SQL Server 2008

Dan Kaminstein
Currently Being Moderated

I am not able to get Crystal 2008 connected to my SQL2008 database using OLE DB (ADO).  I have created the connection using the wizard -


Microsoft OLE DB Provider for SQL Server

specify server instance, login, password, and database name

Finish from the Advanced Information screen with no change


When I then try to get to the list of tables/views, once I click on dbo, I get the following:


Not implemented

Details: ADO Error Code: 0x800a0cb3

Source: ADODB.Connection

Description: Object or provider is not capable of performing requested operation


I am not sure if this is a Crystal thing or a SQL Server thing.  Does anyone have ideas for me?  Thank you