on 10-04-2013 7:09 AM
Hi Experts,
We are trying to create a relational connection on SAP information Design Tool (IDT) to SQL server 2000 database. We have tried three different drivers to test the connection setup - ODBC, OLE DB and JDBC . The ODBC and OLEDB connections test successfully but when we go to the show values tab, we get errors and do not see the tables. We have made all parameters configurations changes on the .sbo files under the <install dir>\BO 4.0\dataAccess\connectionServer\<odbc><OLEDB><JDBC> folders to get the right drivers reflecting to create the connection.
Are we facing these issues as SQL server 2000 is out of support or are there any workarounds to overcome it? I did find out that the system tables on SQL server 2005 and SQL server 2000 are different and therefore we get invalid object name<table name> errors as it cannot find those tables. For ex. The new sql 2005 tables have sys.<table name> where as sql 2000 had sys<table name>.
Please provide if you have resolutions to get the connecting working. I am attaching some snapshots of the errors.
Thanks.
Rohini.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohini,
SQL Server 2000 database is out of support in BI 4.0.
Please check the 'database supported platforms' doc here: https://service.sap.com/~sapidb/011000358700001297402012E
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.