Changes between Version 6 and Version 7 of Cookbook ODBC

Timestamp:

Jan 23, 2010 3:28:18 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook ODBC

@@ -11 +11 @@
 [[BR]][[BR]][[Image(source:EDA/data/Docs/trac/RODBC.jpg)]][[BR]][[BR]]
 [[Image(source:EDA/data/Docs/trac/RODBC2.jpg)]][[BR]][[BR]]
-the Data Source name will indicate your ODBC connection used in R (the one used in the xml file)
+The '''Data Source''' name will indicate your '''ODBC connection''' used in R (in the xml file as shown below).
 Test your connector, it should return connection successfull. If not check that your port is 5432 (it can be different if you have installled several postgres servers).
 Check also that your usernames and passwords are correct.
@@ -35 +35 @@
 Load init.r
 ''note : you are supposed to put the xml file where the R program can directly load it. In the case of EDA you will be at the root of the EDA project. In Eclipse, a variable working directory allows to start R directly at the right location.''
+to test your connection write
+{{{
+library(RODBC)
+odbcConnect(dsn=baseODBC[1],uid=baseODBC[2],pwd=baseODBC[3])
+> RODBC Connection 4
+> Details:
+> case=tolower
+> ...
+}}}
+The possible commands for RODBC are
+{{{
+help.search("ODBC") #returns the following
+RODBC::odbcUpdate       Internal RODBC functions
+RODBC::RODBC            ODBC Database Connectivity
+RODBC::odbcQuery        Low-level ODBC functions
+RODBC::odbcClose        ODBC Close Connections
+RODBC::odbcConnect      ODBC Open Connections
+RODBC::odbcDataSources
+                        List ODBC Data Sources
+RODBC::odbcGetInfo      Request Information on an ODBC Connection
+RODBC::odbcSetAutoCommit
+                        ODBC Set Auto-Commit Mode
+RODBC::sqlPrimaryKeys   Query Column Structure in ODBC Tables
+RODBC::sqlCopy          ODBC Copy
+RODBC::sqlDrop          Deletion Operations on Tables in ODBC databases
+RODBC::sqlFetch         Reading Tables from ODBC Databases
+RODBC::sqlQuery         Query an ODBC Database
+RODBC::sqlSave          Write a Data Frame to a Table in an ODBC
+                        Database
+RODBC::sqlTables        List Tables on an ODBC Connection
+RODBC::sqlTypeInfo      Request Information about Data Types in an ODBC
+}}}