Displaying 4 results from an estimated 4 matches for "dsn_name".
Did you mean:
dns_name
2009 Feb 26
0
[cdr_odbc] error: Cannot insert the value NULL into column 'calldate'
...[uniqueid] [varchar] (32) NOT NULL ,
[userfield] [varchar] (255) NOT NULL
)
How can I make sure that my insert commands reflects my database schema?
I have attached details of all my config files below.
I can connect using isql.
isql -v DSN_NAME sa password
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
|...
2009 Feb 27
1
Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available
...Asterisk Event Logger Started /var/log/asterisk/event_log
3 modules will be loaded.
Connecting sqlserver
Asterisk Dynamic Loader Starting:
== Parsing '/etc/asterisk/modules.conf': == Found
== Parsing '/etc/asterisk/res_odbc.conf': == Found
res_odbc: Connected to sqlserver [DSN_NAME]
Registered ODBC class 'sqlserver' dsn->[DSN_NAME]
res_odbc loaded.
res_odbc.so => (ODBC resource)
Registered Config Engine odbc
2012 Aug 02
1
Joining R Local Dataset with Table from Database
Hi All,
I want to join a table (Dataset) that is created in R with a table that is
in oracle database. Can some one help me in accomplishing this task in R?
Example Code:
library(RODBC)
DB_CONNECT <- odbcConnect("DSN_NAME")
TABLE_JOIN <- sqlQuery(DB_CONNECT, "SELECT * FROM DB_TABLE WHERE COL_1 NOT
IN (SELECT COL_1 FROM DATA_SET_R) ")
Regards,
Madana
--
View this message in context: http://r.789695.n4.nabble.com/Joining-R-Local-Dataset-with-Table-from-Database-tp4638967.html
Sent from the R hel...
2002 Sep 19
1
How to call stored procedure from RODBC?
Hi,
Does anyone know how to call stored procedure from RODBC? Thanks.
Lingyun
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch