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

Manohar Reddy manu.reddy52 at gmail.com
Thu Sep 1 12:44:32 EDT 2016


Thank you for sharing binaries files ,now i can able to make the connection
.

Manu.

On Thu, Sep 1, 2016 at 4:09 PM, Frediano Ziglio <freddy77 at gmail.com> wrote:

> 2016-08-31 18:51 GMT+01:00 Igor Korot <ikorot01 at gmail.com>:
> > Hi,
> >
> > On Wed, Aug 31, 2016 at 11:59 AM, Manohar Reddy <manu.reddy52 at gmail.com>
> wrote:
> >> Hi,
> >>
> >>   My  MS sql server and R environment running on my local machine and
> the
> >> respective port was opened, from this link (http://www.freetds.org/
> >> userguide/osissues.htm.) i didn't get much information ,can you please
> help
> >> out  me is there any way that can i download it and configured it on
> >> widnows 8.
> >
> > Frediano will correct me if I'm wrong, but I don't think there is a
> > binary distribution file
> > you can just download and install.
> > You need to grab the source code, get either MSVC or MinGW compiler and
> compile
> > the software yourself.
> >
>
> About installer you are right, about binaries I would download
> https://ci.appveyor.com/project/FreeTDS/freetds/build/
> 643/job/ct9rf92mw0vcyv3l/artifacts
> or
> https://ci.appveyor.com/project/FreeTDS/freetds/build/
> 643/job/h5h5h2oekntgaqg3/artifacts
> (32 or 64 bit) and register tdsodbc.dll with regsvr32 utility.
> You should download and install OpenSSL from
> https://slproweb.com/products/Win32OpenSSL.html before.
>
> In win32 directory there is an old source for a NSIS installer but
> probably would require some additional library (MSVC/OpenSSL).
>
> > Then just place the resulting binary in the Windows folder somewhere
> > and create the
> > DSN.
> >
> > Thank you.
> >
> > P.S.: Of course if you get any issues don't hesitate to post again...
> >
>
> Frediano
>
> >>
> >> Thanks,Manu.
> >>
> >> On Wed, Aug 31, 2016 at 6:59 PM, Frediano Ziglio <freddy77 at gmail.com>
> wrote:
> >>
> >>> Hi,
> >>>   I don't know Shiny however if I understood:
> >>> - you have a R application running inside this cloud;
> >>> - the application should use RODBC to connect to some SQL Server
> >>> database using ODBC.
> >>> Now I know ODBC. ODBC mainly use drivers (dynamic modules) to connect
> >>> to different database types. As you said that Shiny run on Linux you
> >>> need a driver for Linux that is able to connect to SQL Server, FreeTDS
> >>> is one of them! However the "SQL Server"/"FreeTDS" string after the
> >>> "Driver=" in the connection string is not just a simple string, it's a
> >>> reference to an installed driver. So you have to install the driver
> >>> and configure in the DM (Driver Manager, the ODBC library that RODBC
> >>> is linked to) installed in the Shiny cloud machine. Here we can't help
> >>> much unless you have some direct/standard access (like ssh) to this
> >>> machine.
> >>> About the connection. Where do the SQL Server is running? Inside the
> >>> cloud? On your machine? Is your machine connected and opened (firewall
> >>> speaking) to this Shiny cloud machine(s) ?
> >>> Are you trying to install FreeTDS also on your machine where you are
> >>> testing how your R application is running (I don't know R environment)
> >>> ?
> >>> To install FreeTDS on Windows you can see
> >>> http://www.freetds.org/userguide/osissues.htm.
> >>>
> >>> Frediano
> >>>
> >>>
> >>> 2016-08-31 13:30 GMT+01:00 Manohar Reddy <manu.reddy52 at gmail.com>:
> >>> > Hi ,
> >>> >
> >>> >
> >>> >
> >>> >   Just I want to clarify my requirement before seeking someone help
> on my
> >>> > issue.
> >>> >
> >>> >
> >>> >
> >>> >  *Requirement* :
> >>> >
> >>> >
> >>> >
> >>> >     I need to develop the webpage/Report using shinypackages then I
> need
> >>> to
> >>> > host it on shinyapps.io (shinyapps.io hosted on *Linux*)for that I’m
> >>> using
> >>> > RODBC package to connect my MS Sql server ,but when I deployed it on
> >>> > shinyapps.io ,I have encountered this (first argument is not an open
> >>> RODBC
> >>> > channel) error, based on this error message I googled and found that
> I
> >>> need
> >>> > to use freeTDS drivers instead of sql server and I have cheeked with
> “R
> >>> > professional help”  and they guide me like I  don’t need to install
> >>> freeTDS
> >>> > separately  just I need to use freeTDS drivers instead of sql server
> but
> >>> I
> >>> > couldn’t able to make a successful connection. I’m suspecting that I
> may
> >>> > need to install freeTDS and need to configure it on my machine which
> has
> >>> > been running with Windows 8.
> >>> >
> >>> >
> >>> >
> >>> > *Help* :
> >>> >
> >>> >
> >>> >
> >>> >   Now I’m seeking a help like how to install freeTDS and how to
> configure
> >>> > it on windows 8 ,so that I can make a successful connection to my MS
> Sql
> >>> > server from R studio/Shinyapps.io
> >>> >
> >>> >
> >>> >   FYI… https://groups.google.com/forum/#!topic/shinyapps-users/
> >>> hs4bQHsk9JU
> >>> >
> >>> >
> >>> >
> >>> > Thanks,Manu.
> >>> >
> >>> > On Wed, Aug 31, 2016 at 5:25 PM, Igor Korot <ikorot01 at gmail.com>
> wrote:
> >>> >
> >>> >> 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
> >>> >> _______________________________________________
> >>> >> 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
> >>> _______________________________________________
> >>> 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
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> 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