<html>
<head>
</head>
<body>
Hi , <br>
i start a mail-thread about ODBC Problems with Sybase 30.05.2002. <br>
<br>
this works <img src="chrome://editor/content/images/wink_n.gif" alt=";-)" class="moz-txt-smily" height="19" width="19" align="Center">
<br>
channel.Sybase <- odbcConnect("DSN-NAME","login","passsword",host="IP-Number")
<br>
sybase.query <- sqlQuery(channel.Sybase,"SELECT * FROM DATA.EXPORT_EXAMPLE",errors=T,as="data
frame", nullstring="SYSMIS",na.strings="NA") <br>
<br>
regards,christian <br>
<br>
<br>
Christian Schulz wrote:<br>
<blockquote type="cite" cite="mid:3CF616CF.1040704@metrinomics.de"> Ok,
i test/understand that a object what work with any<br>
RODBC function should not have any point or something other special sign
in the name.<br>
<br>
I follow the recommendation from Prof. Ripley and change the sqlFetch function,
but <br>
the error message is the same.<br>
My problem is (1.) that the name of the tables in th db have all the name
structure DATA.EXPORT_NAME <br>
and i understand that .EXPORT_NAME cause the problems.<br>
<br>
Should i do the same like "juli g. pausas (13.May.2002)" with the loop &
noms, that<br>
the modified function sqflFetch works (..but it's not so easy,because <br>
list.file(pattern="DATA.EXPORT") is difficult,because the DataBase is a
Server and not my localMachine ?<br>
<br>
When it works, i get all tables with the name DATA.EXPORT in a list ?<br>
<br>
many thanks for suggestions<br>
& regards,Christian<br>
<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:ripley@stats.ox.ac.uk">
ripley@stats.ox.ac.uk</a>
wrote:<br>
<blockquote type="cite" cite="mid:Pine.LNX.4.31.0205300947100.21889-100000@gannet.stats">
<pre wrap="">On Thu, 30 May 2002, Christian Schulz wrote:<br><br></pre>
<blockquote type="cite">
<pre wrap="">Hello,<br>i would like import Data from Sybase DataBase to R-1.5.0 via RODBC.<br><br>With this i get a connection without problems !<br>channel <- odbcConnect("ODBCName","LoginName","LoginPass")<br><br>dataSybase <- sqlFetch(channel,"EPORT_XYZ")<br>,but when i try this i get a message error ?<br>(Perhaps the _ is a problem, i know that's i.e. not usual to name<br>objects with _ in R ?)<br></pre>
</blockquote>
<pre wrap=""><!----><br>It is. Search the archives for a workaround I posted a few days ago.<br><br></pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>