“Error occurred while loading translation library” when connecting R to IBM Netezza

When connecting my R-2.15 client to IBM Netezza v7 (NZA 2.5.4) for the first time, I got the error above.  Here was the connect call:

>nzConnectDSN("NZSQL")
Error in odbcDriverConnect("DSN=VirtualNZ") : 
  (converted from warning) [RODBC] ERROR: state HY000, code 45, message Error occurred while loading translation library

Check to make sure you are running the 64bit version of R client.  Once I switched to that version the error went away.  It might be that installing the 32bit Netezza ODBC driver resolves this also.  In my case, I wasn’t interested in getting the 32bit client working.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s