[freetds] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package

Frediano Ziglio freddy77 at gmail.com
Tue Aug 30 16:50:48 EDT 2016


Hi,
  some considerations:
- TDS_Version 9.0 was never implemented, see
http://www.freetds.org/userguide/choosingtdsprotocol.htm;
- the "Data source name not found and no default driver specified" in
this case means that the driver ("FreeTDS") is not installed
correctly. It could mean that you install the wrong bit version or
that you don't install it correctly. Where did you download/how do you
compile and install? Does it happen also with "SQL Server" driver?
- the "\n" before "Database" is an error, there should be no such
character before "Database" option;
- the "first argument is not an open RODBC channel" just indicate that
connection before failed;
- there are some not implemented option in the connection string, see
http://www.freetds.org/userguide/odbcconnattr.htm.

Frediano


2016-08-30 16:55 GMT+01:00 Manohar Reddy <manu.reddy52 at gmail.com>:
> Hi ,
>
> Thanks for looking into my request,based on available information freeTDS
> is also part of RODBC but in connection string we need to use driver name
> as freeTDS instead of sql server ,i tried this way only but no luck.I'm
> suspecting that the way that i did is not correct ,i may need to install
> freeTDS separately and need to configure it on my machine.
>     Attached is the screen shot for your reference,can you please help me
> to how to install and how to configure it on my machine(i'm running with
> windows 8).
>
> Thanks in advance ..
>
> Manu.
>
>
> On Tue, Aug 30, 2016 at 8:21 PM, Igor Korot <ikorot01 at gmail.com> wrote:
>
>> Hi,
>>
>> On Tue, Aug 30, 2016 at 12:53 AM, Manohar Reddy <manu.reddy52 at gmail.com>
>> wrote:
>> > Hi,
>> >
>> >
>> >
>> >    Can anyone guide me how to connect the Microsoft Sql server 2012/14
>> from
>> > R studio using freeTDS package instead of RODBC ,I can able to connect
>> the
>> > MS Sql server from R studio using RODBC.
>> >
>> >   Actually my requirement is I have developed webpage/report using Shiny
>> > package then I was deployed it on Shinyapps.io ,but after deploying I’m
>> > encountering error like “”ERROR:*first argument is not an open RODBC
>> > channel*” ,based on this error message I did searched in google and found
>> > that we need to use freeTDS drivers instead of RODBC but I found some
>> > articles regarding freeTDS but it’s not useful for me.
>> >
>> >
>> >
>> >  I was eagerly waiting for solution from someone since last month, but
>> not
>> > yet and this issue is not allowing me to further .Can anyone please help
>> me
>> > out me(how to install freeTDS and how to configure it) on same.
>>
>> What did you try and what doesn't work?
>> Which freeTDS version do you have?
>>
>> Thank you.
>>
>> >
>> >
>> >
>> > My environment details :
>> >
>> >
>> >
>> >     Os : windows 8
>> >
>> >     R version 3.3.1 (2016-06-21)
>> >
>> >
>> >
>> > Thanks in Advance .
>> >
>> > Manu.


More information about the FreeTDS mailing list