Re: [R] Read in data from Microsoft SQL

2004-11-02 Thread Prof Brian Ripley
On Tue, 2 Nov 2004 [EMAIL PROTECTED] wrote: Hi, the DSN should be exactly the same as name of the (probably system) DSN stated in Windows ODBC settings. Just keep in mind, that DSN in general often holds information about the Default Database, and that switching database os stating

Re: [R] Read in data from Microsoft SQL

2004-11-01 Thread Uwe Ligges
Xiaorong Chen wrote: Hi, I am trying to read data from Microsoft SQL. I tried to use odbcConnect (in RODBC) but failed. What should the dsn be? Does anyone know how to do it? I will appreciate it. The dsn is that one you have entered in the control panel before. (there you have to specify data

Re: [R] Read in data from Microsoft SQL

2004-11-01 Thread Jan_Svatos
Hi, the DSN should be exactly the same as name of the (probably system) DSN stated in Windows ODBC settings. Just keep in mind, that DSN in general often holds information about the Default Database, and that switching database os stating database as prefix may be necessary. Jan - - -