SAP

I was getting the following error. ODBC Call <SQLDriverConnect> for data source <foo> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default Driver specified>. Notify Customer Support. (BODI-1112346) If you see this guy try installing the "Microsoft SQL Server 2008 Native Client". You can download it from Microsoft (http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&DisplayLang=en). Scroll about 1/2 way down the page and look for the version for your processor. . . . ...

It appears from some testing that one of the libraries that ships with the SAP .NET Connector doesn’t support hardened passwords. You might get the following error: “Name or password is incorrect (repeat logon)” To correct the problem you need to put the latest version of the librfc32.dll into the bin folder of your .NET Application. If you have the SAP client installed on your desktop you will find this dll in the c:\windows\system32\ folder.

My colleague, Jerome Nicolas, found a solution the problem outlined below and since he doesn't have a blog and we thought this was some great information we decided to post it to mine. Hope it helps. Scenario: adding a web reference in Visual Studio to an SAP web service that was created from a remotely enabled function module with a table parameter associated type BAPIRET2. Problem: The ABAP object BAPIRET2 is typically used to return messages when calling a BAPI, but it contains a field named “SYSTEM” which can conflict with the System namespace in .NET. If you...

Need to query SAP BW from your .NET application? This is a trivial task with XML\A and C#. XML\A is a specification that allows multidimentional datasources to be queried by applications. It is how Reporting Services talks to SAP BW (http://technet.microsoft.com/en-us/library/bb508810(SQL.90).aspx).
Step 1: Find out the path to your SAP BW XML\A service, Mine looks something like this "http://<Server>:<Port>/sap/bw/xml/soap/xmla"
Step 2: Open a .NET project and create a web reference to that service, I called mine MsXmlAnalysis
Step 3: Modify the WebService Proxy Class, When .NET generates the proxy class it declares the Execute Mehtod with two arguments the ExecuteCommand and a PropertiesType....