Error while extracting data using ODBC 64 bit drivers

[Former Member]

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!

[former_member187605]

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.

[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.

[former_member198401]

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

[Former Member]

Thanks for your response Arun Sasi.

We are using Windows environment not Unix for our DS. I checked PAM for DS 4.2 and there is no explicit mention of PxPlus, but I found that ODBC to Generic Data Sources are supported as a general rule.

[former_member198401]

As Dirk suggested, you need to have the same DSN entry on Client and Server machine. On the Data Services job Server configure the DSN. make sure that you are able to ping the PxPlus Database on this server.

Regards

Arun Sasi

[Former Member]

Arun,

I have DSN with same name on the machine where designer is installed and Job Server. I am also able to ping database.

Thanks!

[former_member198401]

Try using 64 bit ODBC Driver on both the Client and Server machines

Also as per the link which I gave, are you using the Client-Server version of the PxPlus SQL ODBC Driver?

Regards

Arun Sasi

[Former Member]

Arun,

I am using 64 bit drivers. With 32 bit drivers, I am not able to see the DSN from BODS, so unable to create datastore.

Yes, I am using the following drivers from this link - http://www.pvxplus.com/pgsrvr.pvp?pg=dl_optional. Name of driver - PxPlus SQL ODBC Driver 6.00.0002. While installing I am picking "Server side licensing" option. Am I missing something here?

Thanks,

Sashi

[former_member198401]

Kindly follow the below links related to PxPlus

http://manual.pvxplus.com/PXPLUS/odbc/odbc_faq.htm

http://manual.pvxplus.com/PXPLUS/odbc/configuration_procedures/odbc_driver_configuration_windows.htm

It might be a silly issue. Try to troubleshoot it using above links

Regards

Arun Sasi

[former_member198401]

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