IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only

  • 1.  Issue with SQL Driver in Linux

    Posted Thu June 10, 2021 06:15 PM
    Edited by System Admin Sun July 23, 2023 10:57 PM
    we are trying to load data into Microsoft SQL server using Database Adapter  in Linux 

    we added the  Microsoft sql client installation in LD_LIBRARY_PATH , But map is unable to load the library . Can we know if we are missing some thing.

    <3008-554579712-Wed Jun 9 12:56:00 2021>: Validating the adapter command...
    <3008-554579712-Wed Jun 9 12:56:00 2021>: Database type is MS SQL Server
    <3008-554312064-Wed Jun 9 12:56:00 2021>: Connecting...
    <3008-554312064-Wed Jun 9 12:56:00 2021>: Failed in connect to load library
    <3008-554312064-Wed Jun 9 12:56:00 2021>: Returned status: (-1027) Failed_to_load_shared_library
    <3008-554312064-Wed Jun 9 12:56:00 2021>: Connect returns rc=-1027

    I was able to test the same Map in Windows 

    we are using mdq on map

    ------------------------------
    Narendra Chimakurthi
    ------------------------------
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  RE: Issue with SQL Driver in Linux

    Posted Fri June 11, 2021 03:56 PM
    Edited by System Admin Thu July 27, 2023 06:37 PM
    The only SQL Server client drivers I know of for the Linux platform are ODBC/JDBC.  So you should be using either the ODBC or JDBC adapters.

    Can you be more specific about the software you have installed?

    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message


Related Content