Re: Connecting to Sybase and Informix

[BOB LANG <herr_langer2@HOTMAIL.COM>]

Yes, Russ. I have experience with this issue. My problem was trying to
Select from SQL Server and Insert rows into Sybase. My solution was to find
an ODBC version of the SQR program. In my case, it was found by using the
SQR programs found in the HR application. If you have HR, check that
version. The directory was X:\HR751\SQRBINW. To determine the version, view
the VERSION file in that subdirectory. By the way, this information was
gathered with the help of those on the SQR Users list.


>From: Russ Wulfson <rwulfson@BOST.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Connecting to Sybase and Informix
>Date: Tue, 20 Feb 2001 08:00:58 -0700
>
>I have, what is to me, a rather complex question.  I recently posted a note
>about trying to connect to multiple databases (Sybase and Informix).  The
>answer that seemed correct was that I had a licensing issue.  We have sqr
>4.3 bundled with PeopleSoft and this version seems tied directly to
>Informix (our PeopleSoft database).  We're interested in getting a free
>standing version of Brio Report, but I'm concerned that this will not
>resolve my current problem.  I need to be able to run an sqr that will
>function primarily in Informix and allow me to use the -DB flag in my
>select and connect to Sybase.  We have Brio Enterprise and have not been
>able to find or make any drivers work on the UNIX side. So here's my
>questions:
>
>1) Does any one have any direct experience getting Sybase and Informix to
>work at the same time? or know anything specific about this issue?
>
>2)Do the newer versions of Brio Report use ODBC connections or some other
>type of connections?(I don't think I fully grasp the connectivity issues)
>
>Thanks for any help you guys can give me.
>
>Russ

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com