[R-SIG-Mac] RODBC connection MS SQL with Actual driver

[Prof Brian Ripley]

By far the most likely cause is a bug in the ODBC driver.  But can you 
not run this in a debugger and find out where the code is segfaulting: 
if in the driver that pinpoints the cause (and if in RODBC it could 
still be the driver returning incorrect structures).

I have some of the Actual Technologies' ODBC drivers but not this one. 
They have rather a lot of incompletely/incorrectly implemented 
features (there are some notes in the RODBC manual) and are prone to 
crashing.

On Wed, 16 Sep 2009, Josh London wrote:

> Hello
>
> I am trying to troubleshoot connection issues from RODBC on a mac (leopard) 
> to a Microsoft SQL Server using the Actual SQL Server driver.
>
> I have the driver installed and the System DSN is setup and tests 
> successfully. I have also successfully connected and downloaded data in Excel 
> and via terminal using iodbctest. I can also successfully connect to this SQL 
> server from a windows box and using RODBC on a windows installation of R.
>
> That said, on the mac, odbcConnect() and odbcDriverConnect() both result in a 
> segfault.
>
> I have some theories about what might be happening:
>
> 1) there is a conflict between RODBC and the Actual SQL Server driver that is 
> causing the crash
>
> 2) the domain\user specification is not possible with RODBC and I should use 
> a separate SQL Server user authentication
>
> I am continuing to pursue these possibilities on my own and with our local IT 
> staff, but thought I would reach out to the r/mac community to get further 
> advice or suggestions. If I find an answer, I'll post as a response for the 
> archives.
>
> Thanks for any assistance in advance
> josh
>
> *******
> Below are example details and code
>
> System DSN = my_database
> Driver = Actual SQL Server
>
> username = mydomain\me
> password = p@$$
>
>> library(RODBC)
>> odbcConnect("my_database",uid="mydomain\\me",pwd="p@$$")
>
> *** caught segfault ***
> address 0x0, cause 'memory not mapped'
>
> Traceback:
> 1: .Call(C_RODBCDriverConnect, as.character(connection), id, 
> as.integer(believeNRows),     as.logical(readOnlyOptimize))
> 2: odbcDriverConnect("DSN=my_database;UID=mydomain\\me;PWD=p@$$")
> 3: eval(expr, envir, enclos)
> 4: eval(expr, p)
> 5: eval.parent(Call)
> 6: odbcConnect("my_database",uid="mydomain\\me",pwd="p@$$")
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595