[R] RODBC & Problems with Sybase Database

[Christian Schulz]

Hi ,
i start a mail-thread about ODBC Problems with Sybase  30.05.2002.

this works [;-)]
channel.Sybase <- 
odbcConnect("DSN-NAME","login","passsword",host="IP-Number")
sybase.query  <- sqlQuery(channel.Sybase,"SELECT * FROM 
DATA.EXPORT_EXAMPLE",errors=T,as="data frame", 
nullstring="SYSMIS",na.strings="NA")

regards,christian


Christian Schulz wrote:

> Ok, i  test/understand that a object what work with any
> RODBC function should not have any  point or something other special 
> sign  in the name.
>
> I follow the recommendation from Prof. Ripley and change the sqlFetch 
> function, but
> the error message is the same.
> My problem is (1.)  that the name of the tables in th db have all the 
> name structure  DATA.EXPORT_NAME 
> and i understand that  .EXPORT_NAME cause the problems.
>
> Should i do the same like "juli g. pausas (13.May.2002)" with the loop 
> & noms, that
> the modified function sqflFetch works (..but it's not so easy,because
> list.file(pattern="DATA.EXPORT")  is difficult,because the DataBase is 
> a  Server and not my localMachine ?
>
> When it works, i get all tables with the name DATA.EXPORT in a list ?
>
> many thanks for suggestions
> & regards,Christian
>
>
>
> ripley at stats.ox.ac.uk wrote:
>
>>On Thu, 30 May 2002, Christian Schulz wrote:
>>
>>>Hello,
>>>i  would like import Data from Sybase DataBase to R-1.5.0 via RODBC.
>>>
>>>With this i get a connection without problems !
>>>channel <- odbcConnect("ODBCName","LoginName","LoginPass")
>>>
>>>dataSybase  <-  sqlFetch(channel,"EPORT_XYZ")
>>>,but when i try this i get a message error ?
>>>(Perhaps the _ is a problem, i know that's i.e. not usual to name
>>>objects with _ in R ?)
>>>
>>
>>It is. Search the archives for a workaround I posted a few days ago.
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://stat.ethz.ch/pipermail/r-help/attachments/20020607/5d34d683/attachment.html