Search Results

Search found 553 results on 23 pages for 'sap sybase'.

Page 4/23 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

  • Sybase ODBC connection String with .net

    - by nitinkhanna
    Hi, I am having SYBASE 12.5 install on my server as well as my PC, I am unable to get the correct connection string. I have used the connectionstrings.com but unable to get the correct one. After runnig and making the connection Driver={Sybase ASE ODBC Driver};srvr=server_name;database=database_name;UID=user_name;PWD=pass; and some other combination of thic connection string I am getting the Datasource ="" Driver ="" DataBase="" ServerVersion = Invalid Operation. Connection is closed What am I suppose to correct in that. Please help. Thanks

    Read the article

  • OSB 11g & SAP – Single Channel/Program ID for Multiple IDOCs

    - by Shub Lahiri, A-Team
    Background This note is a supplement to the blog entry, SOA 11g & SAP – Single Channel/Program ID for Multiple IDOCs by Greg Mally. Greg has shown how a single SOA Suite composite can be used with iWay Adapters to receive multiple IDOC types via a single channel in the adapter, corresponding to a single programID on the SAP system. We will try to address the same requirements within the OSB framework here. Project Built - Design Time The basic build of an OSB project with iWay SAP Adapter, as seen in another entry in this blog, consists of working in OSB Design console and Application Explorer. OSB Design Time - Part 1 We will create a placeholder project first in OSB with a proper directory structure, so that we can export the WSDL, XSD and the JCA binding information from Application Explorer directly into this project. Application Explorer - iWay Design Time Tool Receiving IDOCs is classified as an inbound event within Application Explorer. For setting up events, a channel is first defined (e.g. iDoc_Channel) using the same PROGRAMID (RFC destination), as defined within SAP for the OSB server. Next, the same channel is used to export the JCA Inbound Event artifacts for the candidate IDOC, e.g. DEBMAS06 directly to the pre-created OSB project. Note that the validation for schema has been turned off. As a result, this will allow the adapter, at runtime, to use a single channel to receive multiple IDOC types from SAP and pass them on to the OSB runtime engine without any validation. In other words, we do not have to repeat the above step for each IDOC type. OSB Design Time - Part 2 Create 2 simple XML based Business Services to write to a file, e.g.  SAP_DEBMAS_File and SAP_MATMAS_File. Next, generate a Proxy Service using the JCA binding file exported from Application Explorer in the previous section. In the generated proxy service, edit the message flow and add a route node. Add a routing table in the route node with the following routing function. fn:local-name-from-QName(fn:node-name($body/*[1])) This function takes advantage of the fact that the XML payload at runtime, after translation by adapter, has the IDOC type as the top element. With the routing function in place, build the routing table to add 2 branches to route the IDOCs to the appropriate Business Service for writing the XML payload to files in separate directories. This completes the build of the OSB project. Testing - Run-Time After deployment and activation, the SAP adapter will wait to receive multiple types of IDOCs sent from the SAP system using a single channel. Upon receipt of the IDOCs, the OSB project will route them appropriately to save the corresponding XML payloads for different IDOC types in different directories.

    Read the article

  • Error while detecting start profile for instance with ID _u

    - by Techboy
    I am upgrading a SAP Java instance and am getting the error shown in the log below. There are not backup profile files in the profiles directory. The string _u does not exist in the default, start or instance profile for instance SCS01. Please can you suggest what the issue might be? Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.initializexAbstractPhaseType.javax758x [Thread[main,5,main]]: Phase PREPARE/INIT/DETERMINE_PROFILES has been started. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.initializexAbstractPhaseType.javax759x [Thread[main,5,main]]: Phase type is com.sap.sdt.j2ee.phases.PhaseTypeDetermineProfiles. Mar 13, 2010 12:09:01 PM [Info]: ...ap.sdt.j2ee.phases.PhaseTypeDetermineProfiles.checkVariablesxPhaseTypeDetermineProfiles.javax284x [Thread[main,5,main]]: All 4 required variables exist in variable handler. Mar 13, 2010 12:09:01 PM [Info]: ....j2ee.tools.sysinfo.AbstractInfoController.updateProfileVariablexAbstractInfoController.javax302x [Thread[main,5,main]]: Parameter /J2EE/StandardSystem/DefaultProfilePath has been detected. Parameter value is \server1\SAPMNT\PI7\SYS\profile\DEFAULT.PFL. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.j2ee.tools.sysinfo.ProfileDetector.detectInstancexProfileDetector.javax340x [Thread[main,5,main]]: Instance SCS01 with profile \server1\SAPMNT\PI7\SYS\profile\PI7_SCS01_server1, start profile \server1\SAPMNT\PI7\SYS\profile\START_SCS01_server1, and host server1 has been detected. Mar 13, 2010 12:09:01 PM [Error]: com.sap.sdt.ucp.phases.AbstractPhaseType.doExecutexAbstractPhaseType.javax862x [Thread[main,5,main]]: Exception has occurred during the execution of the phase. Mar 13, 2010 12:09:01 PM [Error]: com.sap.sdt.j2ee.tools.sysinfo.ProfileDetector.detectInstancexProfileDetector.javax297x [Thread[main,5,main]]: Error while detecting start profile for instance with ID _u. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.cleanupxAbstractPhaseType.javax905x [Thread[main,5,main]]: Phase PREPARE/INIT/DETERMINE_PROFILES has been completed. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.cleanupxAbstractPhaseType.javax906x [Thread[main,5,main]]: Start time: 2010/03/13 12:09:01. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.cleanupxAbstractPhaseType.javax908x [Thread[main,5,main]]: End time: 2010/03/13 12:09:01. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.cleanupxAbstractPhaseType.javax909x [Thread[main,5,main]]: Duration: 0:00:00.078. Mar 13, 2010 12:09:01 PM [Info]: com.sap.sdt.ucp.phases.AbstractPhaseType.cleanupxAbstractPhaseType.javax910x [Thread[main,5,main]]: Phase status is error.

    Read the article

  • Consuming SAP Web Service from ASP.Net

    - by mehmet6parmak
    Hi, Next week i am supposed to develop an asp.net application which will connect to SAP, retrieve some data, change them and send back to SAP. We decided to use web services to achieve this and now i just want to know what diffuculties may i face with? I have URL of WSDL of the Web Service, will it be enough for me to adding web reference and giving the WSDL's URL? How will i authenticate? And Will it be the same with consuming normal web services? Also i wonder is there anybody that can share a .NET dll that can be used in visual studio 2008? There are some articles relating how to create such a dll using SAP .Net Connector and visual studio 2003 but i could not find anybody sharing the resulting dll under their post. Thanks...

    Read the article

  • SAP Shortcut file - How to redirect to specific transaction screen in SAP?

    - by Kiru
    Problem : How to redirect the user to a specific executed transaction screen in SAP? Generated the SAP shortcut and able to redirect the user to specific transaction screen. It is also possible to prefill the required input parameters. The corresponding line in the shortcut is- Command=AB12 RIWO00-input1=200001212; where AB12 is the trasaction, and input1 is the input parameter. This will open that SAP screen, with AB12 transaction and the input parameter would be filled with values. But this mandates the user to clicks on enter explicitly/click on execute button explicitly after opening through the shortcut file. Is it possible to include that enter also in the shortcut file? Thank you :)

    Read the article

  • sybase trigger to find the deleted querry

    - by vinod
    hi , In my sybase server, some rows of a table (TBL_RESOURCE) are deleting from unknown source at random intervals.I tried a lot, but i cannot able to locate from which source/file/process this data is deleting.Is there any mechanism to locate this problem !! i need to find out who is deleting this rows.. how we can find out who is deleted it and from which file ... can we use triger to find the source of deletion ..?

    Read the article

  • Query on Vertical partitioning in Sybase

    - by Sairam
    hi, Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process? Please provide your valuable inputs in this. Thanks.

    Read the article

  • Future SAP RFC SDK

    - by Elmex
    Is the SAP RFC SDK (wdtfuncs.ocx, wdtlog.ocx respectively Interop.SAPFunctionsOCX.dll, Interop.SAPLogonCtrl.dll) an acceptable / recommended way to connect (Microsoft) applications via RFCs with SAP ? Will there be a support and maintenance of the SDK in the future (especially in ECC 6.0) ? Are there people who use these controls in .NET applications ?

    Read the article

  • Future of the SAP RFC SDK

    - by Elmex
    Is the SAP RFC SDK (wdtfuncs.ocx, wdtlog.ocx respectively Interop.SAPFunctionsOCX.dll, Interop.SAPLogonCtrl.dll) an acceptable / recommended way to connect (Microsoft) applications via RFCs with SAP ? Will there be a support and maintenance of the SDK in the future (especially in ECC 6.0) ? Are there people who use these controls in .NET applications ?

    Read the article

  • Future of the "SAP Java Connector"

    - by Elmex
    Is the SAP Java Connector still a good way to connect a Java Application with SAP ? Will there be a support and maintenance of the connector in the future (especially in ECC 6.0) or is the one and only good way the usage of the "Enterprise Services" in ECC 6.0 ?

    Read the article

  • Communicating to SAP XI through .NET - IDOC XML

    - by RAVI KOTA
    Hi Friends, I have a situation where in we need to send IDOC things to SAP XI from .NET application. It is like both sending and receiving. I guess that it is having something connected to translate IDoc to XML and vice versa and then communicate. Can you just some technical knowledge on how to achieve this communication between SAP XI and .NET for IDOCs Many thanks, Ravi Kota

    Read the article

  • .NET SAP Connection Authentication via WEB Service

    - by mehmet6parmak
    Hi, I am trying to connect to a web service served by SAP and i have authentication problem. I simply added the service by right clicking project, selecting add service reference, giving WSDL url for the service and clicking OK.(After clicking ok asked for credentials and i provided them) Then when i tried to call a method from the serviceclien object i got the error message below: The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP Web Application Server <hostname>"'. Web Config Related Part: <basicHttpBinding> <binding name="binding" closeTimeout="00:01:00" openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard" maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536" messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered" useDefaultWebProxy="true"> <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384" maxBytesPerRead="4096" maxNameTableCharCount="16384" /> <security mode="None"> <transport clientCredentialType="None" proxyCredentialType="None" realm=""> <extendedProtectionPolicy policyEnforcement="Never" /> </transport> <message clientCredentialType="UserName" algorithmSuite="Default" /> </security> </binding> Also, What problems will i face with? I do not want to use SAP .NET Connector. Thanks...

    Read the article

  • Constructing dynamic columns from parameters in Sybase

    - by Chapax
    Hi, I'm trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table. The below works: DECLARE @TEST VARCHAR(50) SELECT @TEST = "country" --print @TEST execute("SELECT DISTINCT id_country AS id_level, Country AS nm_level FROM tempdb..tbl_books INNER JOIN (tbl_ch2_bespoke_report INNER JOIN tbl_ch2_bespoke_rpt_mapping ON tbl_ch2_bespoke_report.id_report = tbl_ch2_bespoke_rpt_mapping.id_report) ON id_" + @TEST + "= tbl_ch2_bespoke_rpt_mapping.id_pnl_level WHERE tbl_ch2_bespoke_report.id_report = 14") but gives me multiple results: 1 1 row(s) affected. id_level nm_level 1 4376 XYZ 2 4340 ABC I would like to however only obtain the 2nd result. Do I need to necessarily use dynamic SQL to achieve this? Many thanks for your help. --Chapax

    Read the article

  • Oracle Database 11g Release 2: Optimized for SAP

    - by jenny.gelhausen
    With the release of Oracle Database 11g Release 2 Enterprise Edition, Oracle has further enhanced its long-standing commitment to joint Oracle and SAP AG customers. Get more details on the release. The Oracle Database Insider sat down with Gerhard Kuppler, senior director Corporate SAP Account at Oracle, to find out just how much Oracle Database 11g Release 2 can impact SAP customers. Check out the interview details.

    Read the article

  • Les dessous de la transaction SAP-Sybase, quelles sont les véritables motivations de ce rachat

    Mise à jour du 18.05.2010 par Katleen Les dessous de la transaction SAP-Sybase, quelles sont les véritables motivations de ce rachat L'annonce la semaine dernière du rachat de Sybase par SAP attise la curiosité des analystes financiers du monde entier. Beaucoup veulent comprendre pourquoi 5.8 milliards de dollars ont été mis sur la table dans cette affaire. Economiquement parlant, il s'agit d'une bonne nouvelle et d'un signe de reprise des activités pour SAP, après le recul des revenus de 8% que le groupe avait subi en 2009. Concernant Sybase, les derniers chiffres trimestriels montrent une hausse de 25% du chiffre d'affaires sur les licences de bases de données ; et de 23% pour celu...

    Read the article

  • SAP rachète TECHNIDATA , une société spécialisée dans les solutions de gestion des processus liés à

    SAP rachète TECHNIDATA , une société spécialisée dans les solutions de gestion des processus liés à l'hygiène industrielle SAP L'éditeur allemand d'ERP a acquis son partenaire TECHNIDATA, une société spécialisée dans le développement de solutions informatiques à destination des entreprises pour la gestion des processus liés à l'hygiène industrielle. [IMG]http://djug.developpez.com/rsc/tdlogo.gif[/IMG] Cette acquisition va permettre à SAP de renforcer sa position dans le domaine des solutions orientées EHS (environmental, health and safety),vu que TECHNIDATA dispose d'un catalogue riche qui contient des solutions permettant au entreprises d'être en conformer aux législations environnementale, sanitai...

    Read the article

  • Oracle’s Primavera Inspire for SAP: Aligning Business Priorities with Project Priorities

    Oracle’s Primavera Inspire for SAP integrates schedule, financial and resource information between Oracle’s Primavera project portfolio management applications and SAP’s enterprise resource planning solutions. Join Tracy Bowman, Principal Product Manager and learn how Primavera Inspire for SAP can help utilities and oil and gas companies’ complete projects on-time and within budget by providing them with a single access point for all project and portfolio related information.

    Read the article

  • SAP multiplie les annonces sur son Cloud, nouvel environnement de développement et nouvelles applications prévus

    SAP multiplie les annonces sur son Cloud Nouvel environnement de développement et nouvelles applications prévus Le Cloud Computing était au coeur du SAPPHIRE NOW 2011 et sera au centre des préoccupation de SAP France pour l'année à venir. L'éditeur allemand affirme clairement aujourd'hui qu'il s'agit, pour lui, d'un « changement de paradigme sur le marché, d'une façon orchestrée qui offre une véritable valeur métier aux entreprises ». Pour renforcer sa stratégie, SAP multiplie d'ailleurs les annonces. Comme par exemple celle du rach...

    Read the article

  • SAP annonce des pré-résultats records pour ses ventes de logiciels au 4ème trimestre 2010

    SAP annonce des pré-résultats records Pour ses ventes de logiciels au 4ème trimestre 2010 Malgré le départ de son PDG pour HP et l'affaire TomorrowNow qui l'oppose à Oracle, l'éditeur allemand de solutions professionnelles SAP se porte bien. La société vient d'annoncer des pré-résultats records pour le le 4ème trimestre de son année fiscale 2010, qui se terminait le 31 décembre 2010. . Ses revenus liés à la vente de logiciels s'élèvent à 1,5 milliards d'Euros, soit une progression de + 34 % (+ 24 à taux de change constant). SAP s'en félicite. « Nous sommes heureux d'annoncer le meilleur trimestre de ventes de logiciels de l'histoire de SAP. Nous avons réalisé une...

    Read the article

  • SAP ?????????ASM?????????

    - by ?? ?
    SAP????????????ASM(Automatic Storage Management)????????????? ?????????????Real Application Clusters???????????????Oracle Database 11g R2??????SAP?????(6.40??)???????????????????(???????????)? ?Patch Set Release 11.2.0.2?????? ????????BR*Tools???????????????7.20??????????????RMAN????????????????????????? ??????????????????????????????????????????????????????????????????????????????????ACFS?????????????????????????????????????????????????????????? ????SAP?????????????Oracle Database?ASM?????????????????????????????????????????????????? ???????ASM????????????????????? Oracle ASM ?1????

    Read the article

  • Sybase SQLAnywhere jConnect routines?

    - by jr
    I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn't provide the reports that they are looking for, but access to the data is available by connecting to this ASA database. The vendor of the software would likely prefer I not update the database and I am basically read-only as I am just doing some reporting. All is good, seal is not broken, warranty still intact, etc,etc.. My main problem is that I am using jConnect in order to read from the database, and jConnect requires some "jConnect Routines" to be installed into the database. I've found that I can make this happen by just doing an "Alter Database Upgrade JConnect On", but I just don't fully understand what this does and if there is any risks associated with it. So, my question is does anyone know exactly what jConnect routines are and how are they used? Is there any risk adding these to a database? Should I be worried about this?

    Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >