[R-sig-DB] failing to connect to ODBC

[Thierry Onkelinx]

Dear Binita,

What OS are you on? Windows? Make sure that "schema" is correctly defined
in the datasources on your machine. Another option is to use
odbcDriverConnect() to which you can pass the entire connection string.
That makes things more portable because you don't rely on the settings of
the current machine.

Best regards,


ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature and
Forest
team Biometrie & Kwaliteitszorg / team Biometrics & Quality Assurance
Kliniekstraat 25
1070 Anderlecht
Belgium

To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to say
what the experiment died of. ~ Sir Ronald Aylmer Fisher
The plural of anecdote is not data. ~ Roger Brinner
The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of data.
~ John Tukey

2016-02-17 4:30 GMT+01:00 Binita Nair <binitasnair using gmail.com>:

> Hi,
>
> I am trying to connect to ODBC using the following query
>
> channel<-odbcConnect("schema",uid="",pwd="",believeNRows=FALSE)
>
> Error-State IM002 ,code0, message[Microsoft] [ODBC Driver Manager] Data
> source name not found and no default driver specified
>
> ODBC connection failed.
>
> Please advise.
>
> Regards
> Binita
>
>         [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

	[[alternative HTML version deleted]]