[R] RODBC: DNS vs. connection string

From: Olivier Lefevre <lefevrol_at_yahoo.com>
Date: Tue, 04 Mar 2008 22:49:31 +0100


I am able to connect to an SQL Server Express 2005 instance using either a local source or a connection string (i.e., the two forms of odbcConnect) but sqlColumns returns different results. Specifically two string columns are reported as being of type ntext and length 1073741823 in the first case vs. nvarchar and 0 in the latter. Neither seems correct since in the schema these two columns are declared as nvarchar(max). Does that ring a bell with anyone?

Thanks,


R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Tue 04 Mar 2008 - 22:02:45 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 05 Mar 2008 - 00:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive