IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Connecting to SQL Server (running on Windows platform) from WTX MAPs

    Posted Fri January 11, 2008 12:09 PM

    Originally posted by: SystemAdmin


    Hi Guys,

    I would appreciate your help on the following issue.

    I am trying to connect to SQL Server from WTX MAPs via MDQ file.

    • SQL Server running on Windows platform
    • WTX MAPs run's on unix Solaris server
    • I am using SQL Server adopter.

    I am getting the following error.

    <SourceReport card="1" adapter="DB" bytes="0" adapterreturn="-1027">
    <Message>Failed to load shared library</Message>
    <Settings>-MDQ AAA_BatchAdmin.mdq -DBNAME aaa -QUERY READ_SQLSRV_DATA -T</Settings>
    </SourceReport>

    </ExecutionSummary>
    Since I have very less experience in this area, I would appreciate a simple explanation.

    Thanks

    Mrm
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Connecting to SQL Server (running on Windows platform) from WTX MAPs

    Posted Fri January 11, 2008 12:28 PM

    Originally posted by: SystemAdmin


    PS: There are some knowledgeable women here also.

    =)

    Message was edited by: rep
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Connecting to SQL Server (running on Windows platform) from WTX MAPs

    Posted Fri January 11, 2008 12:28 PM

    Originally posted by: SystemAdmin


    Whether you'll have problem connecting must first be proceded by the maps being able to use the adapter by way of the libraries.

    I just completed the same issue from a Unix side.

    The paths are important, especially for the shared libs. In Unix, the enviroment varible is (SH_LIBS), but looking through that documentation, it should show something about Solaris.

    This has everything I know to try, except one thing that is in the release notes; in Datastage 7.5, we had to copy the lib4mora9i.sl into the lib4mora8.sl, because we were using 9.

    In 8.1, we had to copy the 10g library into 9i because we are using 10g.

    I would suggestion going through this link first, checking permissions and enviroment varibles like "PATH" and "SH_LIB". It say for Unix, but they include some solaris info:

    http://www-1.ibm.com/support/docview.wss?rs=0&context=SSVSD8&q1=%2b1027+%2bFailed+%2bto+%2bload+%2bshared+%2blibrary&uid=swg21245178&loc=en_US&cs=utf-8&cc=us&lang=all

    Let me know how it goes.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: Connecting to SQL Server (running on Windows platform) from WTX MAPs

    Posted Fri January 11, 2008 02:47 PM

    Originally posted by: jvanboga


    What did your trace file say? maybe you can post it here.

    Also, can you see the table when you are in DBID? If so, when you generated your type tree did you generate your update keys?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


Related Content