similar to: ODBC database logging for rsync

Hi there, I'm having a PowerBuilder aplication that connects to a Sybase data base through an ODBC. The application works fine on Windows, but I want to make it run on a Mandriva 2010.2 distribution. The fact is, I could run it on a machine with Mandriva 2010.2, but now I want to do an installation from scratch to another computer, but it does't work. The kernel version that I'm

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael

Has anyone found out any problem with ODBC accesss to sybase sql servers? On my setup the win32 driver (DBCLIENT.EXE) starts when executed from the command line, but does not when called from the application; or the application is not able to talk with a running DBCLIENT process. Any hint appreciated. Luigi

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

Hi, I wish to integrate a Microsoft SQL server with Asterisk for CDRs and for dialplan routing based on database values, and have this application scale to a large number of simultaneous calls: The Asterisk: The Future of Telephony 2nd edition book states that: ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple

I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "TM_Reporting_00001", :username => "<name>", :password

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

Struggled a whole day, but still could not get DCOM working on my machine. What I did is: 1. Installed R 2.8.1 under folder "../R/R-2.8.1" 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, rcom_2.0-4... 4. run the following commands: library(rscproxy) library(rcom)

Introducing Acucorp's Innovative extend5 Software Solutions For the last 14 years, Acucorp has provided Fortune-class corporations, government end users and independent software vendors (ISVs) with unparalleled support for the maintenance and modernization of COBOL applications. While other software manufacturers have created solutions that solve specific technical problems, Acucorp has

Hi, folks. <shameless plug for rsync> rsync has changed the way I handle mirroring tasks, and is a wonderful compliment to EMC's timefinder product. EMC handles their BCV mirror splits, and rsync handles files and hierarchies on non-EMC disk. I am quite happy with this arrangement. For small numbers of systems, rsync is far simpler than NIS+/LDAP for replicating certain types of

Hi James, Is your server name correct in the string below? Looks like you are using incorrect server name. If you don't give full server name, then the server has to be registered with ODBC management tool so that it can be picked up automatically. Regards, Alok From: James Mathew [via R] [mailto:ml-node+s789695n4699208h81 at n4.nabble.com] Sent: Wednesday, November 05, 2014 5:04 AM To:

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

Hi, I'm trying to get R connected to Sybase on a Linux machine. I'm relatively new to databases, particularly the connectivity side. Do I have to use RODBC and install ODBC support on the system (a huge pain with Sybase, as you have to install a scaled-down version of Sybase itself on the system to get it to work with ODBC), or can I somehow use DBI to do it. Other processes on the

I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,

Hello, I am not able to query Sybase IQ database from R using RODBC package. Check the below code R> sybaseiq.query <- function (sql, ..., as.is = FALSE) { connstr <- "Driver={Sybase IQ};UID=ajadhav2;PWD=*****;ServerName=PSGSESHR01A_IQ;CommLinks=SharedMemory,TCPIP{host=psgseshr01_iq.sg.csfb.com;port=3051}" chan <- odbcDriverConnect(connstr)