Re: [R] RODBC, freetds, and MS SQL Server

[Andrew Schuh]

I'm happy.  Setting this argument seemed to work for me and I guess I 
should have messed with it a bit.  I guess the argument seemed a bit 
confusing and didn't seem to imply to me that it represented a possible 
solution.  However, it does seem to work with the MS SQL Server I'm 
having to use.  I haven't been connected to the list since last November 
so I'm sorry if I missed some discussion on this.  It might be a good 
idea to call it out a bit more in the details and state that it has 
represented a potential solution with Oracle and MS SQL Server.  Also, 
for those out there that are looking for a good way to connect R to a MS 
SQL Server; installing freetds via unixODBC seems to work (fingers 
crossed).  Thanks again.

Prof. Brian Ripley wrote:

?odbcConnect has

believeNRows: logical.  Is the number of rows returned by the ODBC
         connection believable?  Not true for Oracle, apparently.
Try setting it to FALSE, as it looks like your driver is broken.

I am not wure why people keep ignoring this parameter in RODBC ....

On Mon, 31 Mar 2003, Andrew Schuh wrote:

 

I have a question for RODBC users out there.  I have used the package with 
good results for some time.  However, I have just switched from an OpenLink 
proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL 
Server 2000 I'm connecting to if it matters).  I was/am running them from 
unixODBC on a Linux Client.  I think I have it set up fine since I can use 
"isql" to perform simple queries on the database.  However, I get really odd 
behavior when I try to use it through RODBC.  It seems to connect fine but 
gives back odd results.  The database I'm accessing is called "cmp" and there 
are many tables of which one is called "Medium".  In the past "select * from 
cmp.Medium" has returned the whole table to me but now it only seems like I 
get column headers.  Any help or advice would be appreciated.

##-------------------------------------------------------------------------------##
   

library(RODBC)
con <- odbcConnect("BIGSKY","***","**********")
con
     

RODB Connection 0
Details:
 case=nochange
 0����Ҩ���� 
   

sqlTables(con)
     

[1] TABLE_QUALIFIER TABLE_OWNER     TABLE_NAME      TABLE_TYPE     
[5] REMARKS        
<0 rows> (or 0-length row.names)
   

sqlQuery(con,"select * from Medium")
     

[1] "[RODBC] ERROR: Could not SQLExecute"                                                                  
[2] "S1000 1 [unixODBC] Msg 208, Level 16, State 1, Server BIGSKY, Line 
1\nInvalid object name 'Medium'.\n"
   

sqlQuery(con,"select * from cmp.Medium")
     

[1] MediumKey Medium    IsSpecies
<0 rows> (or 0-length row.names)
   

version
     

        _
platform i686-pc-linux-gnu
arch     i686
os       linux-gnu        
system   i686, linux-gnu
status                    
major    1
minor    6.2
year     2003             
month    01               
day      10               
language R                
   

Also, I'm using the latest RODBC I got from CRAN yesterday.

   

 

______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help