Skip to Content
0
Former Member
Nov 11, 2009 at 12:33 PM

'Error 42S02, Vendor Code: 208' Dialog box

762 Views

Good afternoon,

I have a query regarding data sources and Crystal reports XI / 2008:

We have a SQL test db named 'TEST' and a live SQL db named 'LIVE'. Each is hosted on a different MS SQL 2005 server.

I setup an ODBC connection to both SQL servers on the user's PC (Windows XP SP3) using Admin. tools. I created a 'System DSN' and a 'User DSN' for testing purposes.

In CR 2008 (version 12.2.1.412) I created a new connection using ODBC (RDO) to the SQL servers using the previously configured ODBC data sources. These logged on successfully.

However, when a report's data source is changed from the TEST db to the LIVE db, a 'database connector error: '42S02: [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name 'TEST.dbo.vRepPeople'.[Database Vendor Code: 208 ]' error dialog box pops up.

To troubleshoot this problem, we created a very basic report based on a few fields from a single view that exists in both SQL db. The error occured.

I have resolved the problem by setting CR to access the SQL servers via the CR OLE DB (ADO) connector - using the 'Microsoft OLE DB Provider for SQL Server' provider.

Could someone advise why this would resolve the problem? Is this due to OLE DB having improved software components compared to the older ODBC?

Also, this problem does not occur on CR 9 - it does occur on CR XI and 2008.

Regards

Edited by: kevin osborne on Nov 11, 2009 1:33 PM