{"id":165,"date":"2013-03-20T01:18:35","date_gmt":"2013-03-20T01:18:35","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=165"},"modified":"2013-03-20T01:22:42","modified_gmt":"2013-03-20T01:22:42","slug":"business-objects-6-5-connection-or-sql-sentence-error-da0005-with-sql-server","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=165","title":{"rendered":"Business Objects 6.5 – Connection or SQL sentence error: (DA0005) with SQL Server"},"content":{"rendered":"

This is an issue with an older version of Business Objects, version 6.5.\u00a0 In 2007, SAP purchased Business Object, and the current version is now called<\/p>\n

\u201cSAP Business Objects XI R3.1\u201d.<\/p>\n

Again this is an issue with older software that I did not find a clear resolution for.\u00a0 From recently dated forums, this is problem is still happening.<\/p>\n

The symptom is that a SQL Server 2000 database was finally upgraded to SQL Server 2005.\u00a0 This is not my choice of an upgrade path, but certified by the vendor of the software we are using.<\/p>\n

When the user attempts to refresh their report, they would get the following error: \u201cConnection or SQL sentence error: (DA0005)\u201d :<\/p>\n

\u00a0\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

When clicking on the “Details>>” button, there error is something like \u201cnon-ANSI outer join operators (\u201c*=\u201d or \u201c=*\u201d)\u201d:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

The resolution is the ANSI92 parameter in the universe file needs to be changed from “no” to “yes”.\u00a0 The following is the steps to accomplish this.<\/p>\n

First, close the report in business objects application after getting this error.\u00a0 The universe file is going to need to be corrected before the report will correctly refresh.<\/p>\n

Next, open the report’s universe file in the Business Objects designer.<\/p>\n

Then click on the FILE drop down menu, and click on the PARAMETERS app.\u00a0 Once the Universe Parameters app opens, click on the last tab called PARAMETER.\u00a0 Highlight the parameter ANSI92.\u00a0 The properties box below will be auto filled with the current information.\u00a0 Change the value from NO to YES.\u00a0 Then click the REPLACE button to update the parameter. \u00a0Then click the OK button to close the app.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Now re-open your report.\u00a0 Your will see that it will refresh with out giving you an error, and you can move on to the next thing.<\/p>\n","protected":false},"excerpt":{"rendered":"

This is an issue with an older version of Business Objects, version 6.5.\u00a0 In 2007, SAP purchased Business Object, and the current version is now called \u201cSAP Business Objects XI … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":178,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-165","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/165"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=165"}],"version-history":[{"count":19,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions"}],"predecessor-version":[{"id":193,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions\/193"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/178"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=165"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}