Skip to Content
0

Error while extracting data using ODBC 64 bit drivers

Jun 06, 2017 at 09:31 PM

78

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Arun Sasi Jun 07, 2017 at 05:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jun 07, 2017 at 05:09 AM
0

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

Show 6 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

0

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!

0

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

0

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

0

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

0
Dirk Venken
Jun 07, 2017 at 11:33 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0