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

Frediano Ziglio freddy77 at gmail.com
Thu Sep 1 06:39:54 EDT 2016


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


More information about the FreeTDS mailing list