All Forums Database
bkj123 3 posts Joined 11/09
18 Mar 2013
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);

ulrich 816 posts Joined 09/09
19 Mar 2013

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
 
 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.