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

Manohar Reddy manu.reddy52 at gmail.com
Wed Aug 31 02:38:49 EDT 2016


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.

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.


More information about the FreeTDS mailing list