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

Igor Korot ikorot01 at gmail.com
Wed Aug 31 07:55:29 EDT 2016


Hi,

On Wed, Aug 31, 2016 at 2:38 AM, Manohar Reddy <manu.reddy52 at gmail.com> wrote:
> Hi ,
>
>   As per your suggestion i have made changes and ran it ,still i'm getting
> same error message,can you please guide me how to install freeTDS and how
> to configure it on windows 8 ,may be i will make a successful connection
> once if i have done with these changes.

You didn't answer Frediano' questions:

Where did you get the freeTDS driver?
How did you compile and install it?

And one more:
What happen if you try the Microsoft ODBC driver? It should be
installed by default
If not just go to microsoft.com and grab one.

Thank you.

>
> Thanks in advance..
>
> Manohar.
>
> On Wed, Aug 31, 2016 at 2:20 AM, Frediano Ziglio <freddy77 at gmail.com> wrote:
>
>> 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.
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
>
>
> --
>
>
> Thanks,
> Manohar Reddy P
> +91-9705302062.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list