Skip to content

Returning position of mouse cursor (without button press) ?

7 messages · Rick Bilonick, Jason Turner, Peter Dalgaard +4 more

Rick Bilonick
# 
Does anyone know of a way to convert or read MS Access database files under Linux
so I can access them in R? I had contacted  Concdeptual Software about DBMS/Copy
and they assured me that the Linux version could handle Access files. Of course,
when I purchased it then they said that it couldn't read MS Access files.

Rick Bilonick

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Jason Turner
# 
Hi
Haven't tried exactly this, so take it with the appropriate scoops of salt...

It may be possible to export the data as an ODBC source, and use RODBC
to read it.  The more I think about it, though, the more hurdles present
themselves.  The biggest problem is the fact that Access behaves as a 
self-contained database package - I don't know of any way to make it behave
like a database server, providing data to other applications on demand.

The RODBC package is something I've used rather a lot under R, but never
to read an Access database.  I usually export the Access data via ODBC
to a network-aware database server (usually PostgreSQL), and then
use RODBC or RPgSQL from there.  

Once the data is transferred to the server, I also usually use that as 
my workbase - removing or renaming the original tables within Access
and then linking the tables via ODBC from the database server back
to Access, so version control and concurency aren't a problem.

[somewhat off-topic - perl as a tool for the job]

One possibility (if you're comfortable with perl) is the DBI package, 
using the DBD::Proxy functionality, and "roll your own" server connection.
This is less elaborate than it sounds - the infrastructure to do this
is already provided within DBI and DBD::Proxy, including finnicky details
like compression for transmission over slow networks, and encrypted
transmission.

R would use system() to call a perl script on the linux machine,
which would connect to a (running in background) perl script on the 
windows machine.  The perl script on the Windows machine would excecute
the data fetching, and pass it back to the perl script on the linux 
machine.  From there, the values could be passed back to R, or to
an external file.  

This sounds pretty involved, but perl isn't hard to learn if you
don't know it, and if you do, the DBI module isn't difficult.

Hope this helps - I've never tried it exactly like this.  Let me know
what you find.

Cheers

Jason
Peter Dalgaard
# 
"Richard A. Bilonick" <rab at nauticom.net> writes:
I don't think I can come up with anything not involving a Windows OS.

With something like Win4Lin and R for windows, I think you can set up
an RODBC connection to the file.
A.J. Rossini
# 
PD> "Richard A. Bilonick" <rab at nauticom.net> writes:
    >> Does anyone know of a way to convert or read MS Access database
    >> files under Linux so I can access them in R? I had contacted
    >> Concdeptual Software about DBMS/Copy and they assured me that
    >> the Linux version could handle Access files. Of course, when I
    >> purchased it then they said that it couldn't read MS Access
    >> files.
    >> 
    >> Rick Bilonick

    PD> I don't think I can come up with anything not involving a
    PD> Windows OS.

    PD> With something like Win4Lin and R for windows, I think you can
    PD> set up an RODBC connection to the file.
 
Why not the unixodbc drivers?   (someone who should remain nameless so
he won't get pestered suggested that they might work).

best,
-tony
Brian Ripley
#
On 1 Mar 2001, A.J. Rossini wrote:

            

      
      
      
    

        
I believe that using Access from Linux needs an ODBC-ODBC bridge on a
Windows server.  Put another way, unixODBC can't have drivers for a
database that does not run on Linux.

www.unixodbc.org says

Microsoft Access

You can use a Bridge to get to a ODBC data source on a Windows machine

See the ODBC-ODBC Bridge entry


B.

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Andrew Perrin
    

    

      
      #
    

  


  

      
I've never seen any non-Windows software capable of reading Access files
directly, although I'm happy to be corrected on that.  You can, though,
run Access on another machine or on a VMWare/Win4Lin subsystem and then
either attach via RODBC or write the data to some more useful format (say,
tab-delimited) and go from there.

----------------------------------------------------------------------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology  
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
        aperrin at socrates.berkeley.edu - aperrin at igc.apc.org

        
On Thu, 1 Mar 2001, Richard A. Bilonick wrote:

        

            

      
      
      
    

        
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    
26 days later

    

      


  

        

      Derek N Eder
    

    

      
      #
    

  


  

      
I would like a function that return the X,Y position of the mouse cursor
whenever it is called PERIOD, i.e., without the button presses of locator()
or identify().

E.G.,

            

      
      
      
    

        
[1]  123   34  # X and Y coordinates of present mouse position in current
graphics window

Is this a conceivable R function or does it need to be addressed with a call
to the OS (Windows 2000 in my case)?

Thanks,

Derek


Derek N. Eder
G?teborgs Universitet
Institutionen f?r klinisk neurovetenskap - psykiatri
Sahlgrenska universitetssjukhuset
Bl? straket 17
SE 413 45  G?teborg
Sverige

tlf. +46 (031) 34 26 139
derek.eder at neuro.gu.se


Gothenburg University
Institute of clinical neuroscience,
section for Psychiatry
SU/SS
SE 413 45  G?teborg
Sweden

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._