search for: sqlext

...ceived trying to install RODBC and how I can get around the problem. n.b. The error originally occurred then I was installing Rcmdr. I then tried to install RODBC separately and received the same error. checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' ** Removing '/usr/lib/R/library/RODBC' The downloaded packages are in /tmp/RtmpA1n...

If one attempts to install RODBC (via install.packages('RODBC')) without having an ODBC driver installed, this error message results: checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' * removing '/usr/lib/R/library/RODBC' Yes, the RODBC README describes the needed prerequisites, but for someone who j...

I'm a newcomer - obvioulsly I fear. Tried to install RODBC from CRAN mirror onto mahcine 64bit running suse10. terminal log below - it failed on "ODBC headers sql.h and sqlext.h not found" di i need anothe rpackage?? can someone help please? ta v much Prof R Gott Durham UNiv, UK > install.packages(c("RODBC")) trying URL 'http://cran.uk.r-project.org/src/contrib/RODBC_1.1-5.tar.gz' Content type 'application/x-gzip' length 69366 by...

Context:Pentium 4, FreeBSD 5.4, R 2.2.0 I updated the extra packages I had downloaded but the upgrading of RODBC failed complaining: checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' The two header files are present in my box under /usr/local/include; I tried to symlink...

...hecking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o ............. checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' ** Removing '/usr/local/lib/R/site-library/RODBC' The downloaded packages are in...

...hecking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' ** Removing '/usr/local/lib64/R/library/RODBC' The downloaded packages are in...

...hecking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' ** Removing '/home/user1/R-2.8.1/library/RODBC' The downloaded packages are in /tm...

...hecking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' * removing '/home/jorgehou/R/x86_64-unknown-linux-gnu-library/2.12/RODBC' The downl...

...king for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... yes checking sql.h presence... yes checking for sql.h... yes checking sqlext.h usability... yes checking sqlext.h presence... yes checking for sqlext.h... yes checking for library containing SQLTables... -lodbc checking for SQLLEN... yes checking for SQLULEN... yes checking for long... yes checking size of long... configure: error: cannot compute sizeof (long), 77 See `conf...

...hecking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ?RODBC? * removing ?/usr/local/david/R/RODBC? Details of my setup are: > R.version _...

...esn't give a complete piece of info. As a matter of fact, as well as setting $ODBC_INCLUDE=/usr/local/include and $ODBC_LIBS=/usr/local/lib I had also to put ** $LIBS=- L/usr/local/lib ** which wasn't in the README (and wasn't that intuitive, was it?). In so doing I solved the sql.h, sqlext.h headers problem and a successive problem with the SQLTables libraries. This set things straight and RODBC was compiled flawlessly. I think it would be worth your while adding this piece of information in the README file. Ciao Vittorio >----Messaggio originale---- >Da: vdemart1 at ti...

...hecking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' ** Removing '/home/luisridaocruz/R/x86_64-pc-linux-gnu-library/2.8/RODBC' The downl...

...-g -O2 -c RODBC.c -o RODBC.o ** Removing '/home/jcole/lib/R/library/RODBC' ** Restoring previous '/home/jcole/lib/R/library/RODBC' From rodbc.log it seems that the problem may be with an IBM-supplied header file: In file included from RODBC.c:24: /home/db2inst1/sqllib/include/sqlext.h:1681: error: parse error before "SQL_API" /home/db2inst1/sqllib/include/sqlext.h:1682: error: parse error before "hdbc" <More gory details available upon request.> Any thoughts would be very much appreciated. I have verified that my unixODBC installation is good by...

The RODBC installation failed, with the following message ( 2 missing c header files ): checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/home/hadoop/R/i686-pc-linux-gnu-library/2.15/RODBC’ Warning in install.packages :   installation of package ‘RODBC’ had non-zero exit status The downloaded s...

...without them by setting the environment >variable _R_CHECK_FORCE_SUGGESTS_ to a false value. Unfortunately, "install.packages('RODBC')" says it's only available in source form. When I attempt to install from sources, it fails as follows: >checking for sqlext.h... no >configure: error: "ODBC headers sql.h and sqlext.h not found" >ERROR: configuration failed for package ?RODBC? >* removing ?/Library/Frameworks/R.framework/Versions/3.3/Resources/library/RODBC? >Warning in install.packages : > installation of package ?R...

...king for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking sql.h usability... yes checking sql.h presence... yes checking for sql.h... yes checking sqlext.h usability... yes checking sqlext.h presence... yes checking for sqlext.h... yes checking for library containing SQLTables... -lodbc checking for SQLLEN... yes checking for SQLULEN... yes checking for long... yes checking size of long... configure: error: cannot compute sizeof (long), 77 See `conf...

...ent > >variable _R_CHECK_FORCE_SUGGESTS_ to a false value. > > > Unfortunately, "install.packages('RODBC')" says it's only available > in source form. When I attempt to install from sources, it fails as > follows: > > > >checking for sqlext.h... no > >configure: error: "ODBC headers sql.h and sqlext.h not found" > >ERROR: configuration failed for package ?RODBC? > >* removing > ?/Library/Frameworks/R.framework/Versions/3.3/Resources/library/RODBC? > >Warning in install.packages : > > in...

...--prefix=/usr/local/R-2.11.0 JAVA_HOME=$JAVA_HOME CPPFLAGS="-I/usr/local/unixODBC-2.3.0/include" I have compiled and installed unixODBC-2.3.0 (64-bit) in /usr/local and can connect to and query the database using isql. When I try to build RODBC, I get the following error: checking for sqlext.h... yes checking for library containing SQLTables... no configure: error: "no ODBC driver manager found" ERROR: configuration failed for package ?RODBC? * removing ?/usr/local/R-2.11.0/lib64/R/library/RODBC? The directory /usr/local/unixODBC-2.3.0/lib has the files libodbc.so and libodb...

...environment > >variable _R_CHECK_FORCE_SUGGESTS_ to a false value. > > > Unfortunately, "install.packages('RODBC')" says it's only available in source form. When I attempt to install from sources, it fails as follows: > > > >checking for sqlext.h... no > >configure: error: "ODBC headers sql.h and sqlext.h not found" > >ERROR: configuration failed for package ?RODBC? > >* removing ?/Library/Frameworks/R.framework/Versions/3.3/Resources/library/RODBC? > >Warning in install.packages : > > installation...

...sqlcode; struct { /* ub2 */ unsigned short sqlerrml; /* ub1 */ char sqlerrmc[70]; } sqlerrm; /* ub1 */ char sqlerrp[8]; /* b4 */ int sqlerrd[6]; /* ub1 */ char sqlwarn[8]; /* ub1 */ char sqlext[8]; }; In rh-postgresql-devel-7.3.6-1 package, it defines sqlca in /usr/include/sqlca.h, as: #define SQLERRMC_LEN 70 struct sqlca { char sqlcaid[8]; long sqlabc; long sqlcode; struct { int sqler...