search for: openlink

I'm using RODBC to connect to a MS SQL server. I've been able to get it to work without much of a hitch in windows. However, I'm using OpenLink's iODBC drivers on the Linux side and I'm not sure how RODBC is able to find information about the dsn's (which is in the odbc.ini file?). I've tested the connection with the test program included by OpenLink and I've verified that it connects to the server correctly. I ju...

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

Hi, In an app I''m developing I''ve run into a strange problem. I''ve created some controllers and models using the scaffolding generator and everything seemed to work fine. However I''ve noticed that a particular model I''ve created always fails its tests and I can''t test it out in a browser due to the same error I''m getting which is:

Hi all, I am getting a problem in calling Stored Procedure from C++ application on macintosh using OpenLink. Exact scenario is that my stored procedure takes 6 parameters out of which 1 parameter is out parameter and other 5 are input parameters. So it uses 5 IN parameters as values for inserting a row in database and returns its max id as out parameter. Code Snippet is given below :-- SWORD ret...

Hi, I'm trying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4. On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning: > [doibook:~] dorme% /usr/bin/odbctest > iODBC Demonstration program > This program shows an interactive SQL processor > > Enter ODBC connec...

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...

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the odbcConnect util and the odbcDriverConnect util. I am able to connect to the database through other non-odbc based database programs f...

...ybe someone can assist i created a module in my apps lib directory which i use for authenticating against an external source (among other things). lib/myapp.rb ----------------- require ''rubygems'' require_gem ''activerecord'' # uses activerecord odbc adapter by openlink module MyApp module ExternalSource class Connection < ActiveRecord::Base def self.authenticate(opts = {:login => "", :password => "", :env => "") begin ActiveRecord::Base.establish_connection( :adapter => "o...

I have a Zope + DCOracle2 setup, and I was thinking of moving to Zope + eGenix ODBC (which will use unixODBC) however that still leaves me lacking a driver to connect this to the Oracle server. There are a number of variously priced commercial drivers out there like EasySoft, Merant, OpenLink, etc. Someone built upon a previous open source EasySoft driver: http://fndapl.fnal.gov/~dbox/oracle/odbc/ Anyone have any suggestions/experience? -Mike

...). writing by Perl. I have download and install UnixODBC, DBI, DBD from CPAN, when i tested isql -DSN -UID - PWD, that's successful, but when run by perl, message alert could not loaded driver database, .... anybody used ODBC for linux, connect to MS SQL Sevre, please help me? easysoft and openlink have trial license, run with iODBC, run on 30 days, could you like help me don't used iODBC, free tools. any advice? Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050813/416fcb94/atta...

I have a few questions regarding using activerecord outside of rails. Usage is with legacy databases, which gives rise to some of the problems. Probably the first, and most simple question though, is how to capture the SQL log, with which I can hopefully figure the other stuff out. I''m currently trying ActiveRecord::Base.logger = Logger.new STDOUT Based on random googles, but it

[sorry, but this is a re-post - I forgot to set the subject line the first time around] Hello, I would like to access an Oracle database running on Solaris from R on my linux desktop. I have had a look at the R Data Import/Export manual, and downloaded RODBC and unixODBC, but I am still quite confused about how to proceed. It appears to me that I still need to get an Oracle ODBC driver, and

Hello! I've got a Buffalo Linkstation HD-HLAN250. This is a consumer NAS device, which makes the built-in HD accessible via SMB and FTP. On that system, some sort of Linux with some sort of Samba is running. I'm now trying to create filenames with special characters (ie. non-ASCII chars) in it. For example "bl?der name" (means "stupid name"). To get access to the