Displaying 2 results from an estimated 2 matches for "dsnname".
Did you mean:
dsname
2002 Aug 02
1
R to Oracle via RODBC
...age On Linux
Red Hat 7.3.
Specs
R version 1.51
Driver: Easysoft ODBC - Oracle driver
Driver Manager: unixODBC
I get the following error when trying to executing RODBC commands. Can
anybody give me pointers as to what I'm missing or doing wrong
> library(RODBC)
> channel <- ("DSNName")
> sqlQuery(channel,"select * from tableX")
Error in odbcQuery(channel, query) : NAs in foreign function call (arg 1)
In addition: Warning message:
NAs introduced by coercion
> odbcTables(channel)
Error in odbcTables(channel) : NAs in foreign function call (arg 1)
In additio...
2005 Dec 20
9
Rails Configuration Question
...if I didn''t include
a manual connection with Model.establish_connection(...), but it went away
yesterday when I twiddled around with the database.yml file a bit.
#Database Configuration#
Here is a cleaned up snippet from database.yml:
production:
adapter: sqlserver
mode: odbc
dsn: DSNNAME
username: WINDOMAIN\user
password: ********
test, development, and production have identical entries. My database
models are wrappers for non-rails tables and include primary key
redefinition, table definition, and foreign key relationships.
#Unit Test Example#
This is code from a working un...