Re: [R] RODBC: DNS vs. connection string

I meant a DSN, not a DNS... -- O.L. __ R-help@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, reproducib

[R] RODBC: DNS vs. connection string

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 v