search for: iodbc

Dear All, As some of you in the archive, i am experiencing problems in using RODBC with IODBC on Mac OS X Panther. I am currrently facing two problems. The first one is apparently linked with IODBC (according to returned R error message) although testing the database access from IODBC manager seems to work fine. The second is by far more radical, R purely and simply reports an error ,...

"R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: >* checking package dependencies ... ERROR >Package suggested but not available: ?RODBC? > >The suggested packages are required for a complete check. >Checking can be attempted without them by setting the environment >variable _R_CHECK_FORCE_SUGGESTS_ to a false value.

Hello. It's possible to use IODBC instead UNIXODBC with realtime? As I see, the res Makefile load a odbcinst.h file, but in IODBC there's not this file. I change the res Makefile (iodbcinst.h instead odbcinst.h) and the make create the res_odbc.so. But when asterisk boot it don't start showing: [res_odbc.so]Oct 4 10:24:4...

I'm using RODBC to connect to a MS SQL server. I've been able to get it to work without much of a hitch in windows. However, I'm using OpenLink's iODBC drivers on the Linux side and I'm not sure how RODBC is able to find information about the dsn's (which is in the odbc.ini file?). I've tested the connection with the test program included by OpenLink and I've verified that it connects to the server correctly. I just need to g...

...Suggestions? > Thanks, > Spencer Graves Spencer, The RODBC related error is a common issue and is covered in the vignette for the RODBC package in Appendix A "Installation": https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf You are missing the two iODBC header files that are required to compile the RODBC package from source code. When I install RODBC on my Mac running 10.11.5 (El Capitan), I use: install.packages("RODBC", type = "source", configure.args = "--with-odbc-include=/Users/marcschwartz/R.Files...

Hi all, I try to use RODBC on my mac machine. I google a lot but could not find a very comprehensive tutorial. Finally, I install iODBC, but there's no driver in iODBC. And I found some commercial ODBC driver. Actaully I just want to learn it ,so free driver will be suitable for me. Does anyone how to use RODBC on mac environment ? And is there any comprehensive tutorial on it ? Thanks -- Best Regards Jeff Zhang [[altern...

...he following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) > channel = odbcDriverConnect('SERVER=mydsn;DATABASE=my_subdb;UID=myid;PWD=mypasswd') Warni...

...ontents/MacOS/R Version: 1.01 (1.01) PID: 507 Thread: 0 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x000001fc However, if I try it through an xterm (command line), I get the following: Warning messages: 1: [RODBC] ERROR: state IM004, code 0, message [iODBC][Driver Manager]Driver's SQLAllocEnv() failed 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) I'm reasonably sure the DSN is okay because I can use it to connect to the DB with other applications. Any suggestions? -Drew Specific Info: Machin...

Does anyone know of a libiodbc rpm for CentOS4? -Thanks

iODBC appears no longer to come standard with OSX, so I installed unixodbc and set it up following instructions here: http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/ I connected to my remote database with isql -v mydsn. No problem. Then I tried from R: > library(RODBC)...

Hi all, I am getting a problem in calling Stored Procedure from C++ application on macintosh using OpenLink. Exact scenario is that my stored procedure takes 6 parameters out of which 1 parameter is out parameter and other 5 are input parameters. So it uses 5 IN parameters as values for inserting a row in database and returns its max id as out parameter. Code Snippet is given below :--

Hi, I have tried to install.packages("RODBC"), but it balks: Installing source package `RODBC'' ... creating cache ./config.cache checking for library containing SQLTables... no configure: error: no ODBC driver manager found ERROR: Configuration failed for package `RODBC'' What am I missing? What and where should "SQLTables" be? In another package? What

Hi, I'm trying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4. On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning: > [doibook:~] dorme% /usr/bin/odbctest > iODBC Demonstration program > This program shows an interactive SQL processor > > Enter ODBC connect string (? shows lis...

I am trying to get access to a Microsoft SQL Server 2k installation on my network. To this point I''m not having any luck. I''ve followed the instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0001.0928 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM...

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the odbcConnect util and the odbcDriverConnect util. I am able to connect to the database through other non-odbc based database programs from the Mac, so I know it's not a Postgre...

...d everything seemed to work fine. However I''ve noticed that a particular model I''ve created always fails its tests and I can''t test it out in a browser due to the same error I''m getting which is: ActiveRecord::StatementInvalid (DBI::DatabaseError: S1090 (0) [iODBC][Driver Manager]Invalid string or buffer length: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 10 * FROM info_lists ) AS tmp1 ) AS tmp2) I''m connecting to a MS SQL Server 2000 via Freetds on a mac, which is probably something to do with my problem. It doesn''t matter if there...

This may be as much of a Linux Newbie question as an RODBC question. I've managed to get iODBC working on my RedHat 7.2 system. I can load the library and run it as root. However, I would like to be able to run it via Perl and Apache over the web. I'm not sure what I need to change in order to let "nobody" (the user running the scripts off of Apache) load the library. I can...

...orks with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against iODBC. I had to make quite a lot of internal changes, so would appreciate success/problem reports for other uses. There are several improvements in this version, some of which I had previously submitted to Michael Lapsley: see the ChangeLog. I am moving towards a 1.0 release which will be somewhat inc...

...orks with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against iODBC. I had to make quite a lot of internal changes, so would appreciate success/problem reports for other uses. There are several improvements in this version, some of which I had previously submitted to Michael Lapsley: see the ChangeLog. I am moving towards a 1.0 release which will be somewhat inc...

...ling list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing server name, port, or database name in call to CC_connect. (SQL-IM002) aka (iodbctest) SQLDriverConnectW = Unknown connect option (Set) (205) SQLSTATE=S1009 Figured it out, though: Leopard comes with iODBC installed, and many people install unixODBC additionally. Then then configure /sw/etc/odbc*.ini and unixODBC works, but iODBC doesn't. Even if you symlink the INI f...