Designer - Problems with connection to SQLServer 2000

[wcsltd]

Newbie question regarding Designer:

I am trying to use B.O. Designer 5.1.4 to create a demo universe for some users, against tables held in a SQL Server 2000 database, and I am having problems when I use the table browser to insert a couple of tables. I can see the required tables in the browser, but not all the columns for the tables.

I have tried defining both OLE DB and ODBC connections which both test OK (see below) but neither works with the table browser. The only difference is with OLE DB I get an error message "Error in retrieving columns" with "UNV0020 Unknown error during fetch".

I am aware of 'external stragegy' files, but surely I should be able to use the built-ins as I'm not trying to do anything fancy.

Any suggestions would be gratefully received.


Regards,

John.

OLE DB Test details:
Database server version:
Provider Name: sqloledb.dll
Provider Friendly Name: Microsoft OLE DB Provider for SQL Server
Provider Version: 07.01.0961
OLE DB Version: 02.00
DBMS Name: Microsoft SQL Server
DBMS Version: 08.00.0534
Server Name: ABZAP14
User Name: dbo

BusinessObjects configuration:
Network Layer: OLE DB
DBMS Engine: MS SQL Server 2000
DLL: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\SQBOLE50.DLL
SBO: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\OLEDB\OLEDB
PRM: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\OLEDB\sqlsrv
RSS: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\OLEDB\msft2000


ODBC Test details:
Database server version:
Driver version: 03.70.0961
Driver API level: 03.51
ODBC Manager version: 03.52.6019.0000
ODBC Manager API level: 03.52.0000
DBMS name: Microsoft SQL Server
DBMS version: 08.00.0534

BusinessObjects configuration:
Network Layer: ODBC
DBMS Engine: MS SQL Server 2000
DLL: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\SQODBC50.DLL
SBO: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\ODBC\ODBC
PRM: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\ODBC\sqlsrv
RSS: C:\Program Files\Business Objects\BusinessObjects 5.0\Data Access 5.0\ODBC\msft2000

My client:
Windows 2000 Workstation (SP2)
Business Objects - Designer 5.1.4

 

[wcsltd]

Problem solved.

This is a know BO SP4 bug (#1055024), which is fixed in SP5 on.
(There is a very simple workaround for SP4 if anyone's interested)

Regards

John

 

[nimmy99]

How did you debug that error?
I am getting the same issue in my training lab