RODBC system error 193

Database
Fan

RODBC system error 193

Good afternoon.

I've been connecting Teradata and RStudio with RODBC on a windowsXP (32 bit) laptop for a while.  Example code is at the bottom of this post.  

I am not able to run this code on a Windows 7 64 bit laptop.  I receive a message of "[RODBC] ERROR: state IM003, code 160, message Specified driver could not be loaded due to system error  193:  (Teradata, C:\Program Files (x86)\Teradata\Client\13.10\ODBC Driver for Teradata\Lib\tdata32.dll)."

As far as I can see there are a couple of differences between the 2 setups:

1. WindowsXP is 32 bit with 32 bit drivers and the Windows 7 is 64 bit with 32 bit drivers.

2. The DSN (e.g. "_Prod") on the XP laptop is a system DSN.  The Win7 laptop uses a user dsn since I don't have administrator rights on this laptop.

Any suggestions of how to resolve?  Can I go an alternative route like JDBC?  Thank you - Brian

library(RODBC)

myconn <-odbcConnect("_Prod",uid="xxxxx",pwd="zzzzz")

sqlStr <- "Select * from databasex.tablez;"

sqlQuery(myconn, sqlStr, believeNRows = FALSE);

1 REPLY
Supporter

Re: RODBC system error 193

try 

http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package

You need to download the JDBC driver and set the correct path.

Ulrich