Skip to Content
avatar image
Former Member

Error while extracting data using ODBC 64 bit drivers

Hi all,

I have created an ODBC 64 bit DSN to connect to our database. When I create a datastore in BODS 4.2 SP6 designer, I am able to browse through the tables and import table successfully into the datastore. But when I am trying to extract data from the source, I am getting following error.

ODBC data source <DSN Name> error message for operation <SQLFetch>: <[PxPlus][ODBC Driver][PXPIO]Network error>.

Any ideas to resolve this issue would be greatly appreciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 07, 2017 at 05:09 AM

    From the error message it seems that the Database which you are using is PxPlus database. Make sure the database is supported with Data Services according to the PAM.

    PxPlus ODBC works only on Windows platform, so if your platform is Unix it wont support.

    http://manual.pvxplus.com/PXPLUS/PxPlus%20User%20Guide/Data%20Integration/PxPlus%20ODBC/Overview.htm

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07, 2017 at 05:09 AM

    From the error message it seems that the Database which you are using is PxPlus database. Make sure the database is supported with Data Services according to the PAM.

    PxPlus ODBC works only on Windows platform, so if your platform is Unix it wont support.

    http://manual.pvxplus.com/PXPLUS/PxPlus%20User%20Guide/Data%20Integration/PxPlus%20ODBC/Overview.htm

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07, 2017 at 11:33 AM

    Do you run DS Designer from the server?

    If not, make sure to configure exactly the same DSN on the server, too.

    You always need exactly the same connectivity on client and server platforms. At design time, you access the database from the client . At runtime, your DS jobs access it from the server.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your answer Dirk.

      Our DS job server and designer are on two different servers, so I have created DSNs with same names on both servers.