Re: [R] Help Installing RODBC with custom header locations

Original Message- From: Marc Schwartz [mailto:marc_schwa...@me.com] Sent: Wednesday, February 01, 2017 10:31 AM To: Ivan Gomez <igo...@zencos.com> Cc: R-help <r-help@r-project.org> Subject: Re: [R] Help Installing RODBC with custom header locations > On Feb 1, 2017, at 8:11 AM, I

Re: [R] Help Installing RODBC with custom header locations

> On Feb 1, 2017, at 8:11 AM, Ivan Gomez wrote: > > Hi all, > > I'm trying to install.packages("RODBC") , but it is failing because it cannot > find certain required header files: > > > "configure: error: "ODBC headers sql.h and sqlext.h not found" > > I believe this

[R] Help Installing RODBC with custom header locations

Hi all, I'm trying to install.packages("RODBC") , but it is failing because it cannot find certain required header files: "configure: error: "ODBC headers sql.h and sqlext.h not found" I believe this is because my header files are in a custom location instead of the standard system

Re: [R] help with RODBC

Using HTML email is, as usual, obscuring what you are doing on this end of the communication. The error message indicates that you have single quotes around the BOS term, but they are not visible in the code you have presented. In addition, there is a syntax error in having the word 'from'

Re: [R] help with RODBC

Why do you have single quotes inside your single quotes? --- Jeff NewmillerThe . . Go Live... DCN:jdnew...@dcn.davis.ca.usBasics: ##.#. ##.#. Live Go...

[R] help with RODBC

I want to apply the following query to my database. P2-sqlQuery(ch1,'select *, TimeStamp_Local, ref_density, ref_dewpoint, ref_dir, ref_precip, ref_press, ref_rh, ref_snowfall, ref_snowdepth, ref_temperature_avg,

[R] Help for RODBC usage on mac

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

Re: [R] Help for RODBC usage on mac

Please ask about RDBMSs on R-sig-db. On 25/11/2011 06:34, Jeff Zhang wrote: 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 Hmm, iODBC is part of Mac OS X. driver in iODBC. And I found

Re: [R] Help with RODBC connection to multiple MS SQL Sever databases

On 16/07/09 00:13, Chris Anderson wrote: I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of

[R] Help with RODBC connection to multiple MS SQL Sever databases

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the