Re: Connecting to Sybase and Informix

[Mike Morgan <MMorgan@MELLON-INVESTOR.COM>]

Bob,

My VERSION file for PS Financials 7.5 contains the following:

SQR Server/4.3.4/PC/Windows NT 4.0/ODBC Level 2/Jun 03 1999

Does this mean I have an ODBC version - and that I should be able
to SELECT from SYBASE and INSERT into MS SQL SERVER?

> -----Original Message-----
> From: BOB LANG [SMTP:herr_langer2@HOTMAIL.COM]
> Sent: Tuesday, February 20, 2001 11:37 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Connecting to Sybase and Informix
>
> 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
**************************************************************
NOTICE: The information contained in this e-mail is confidential and may be
privileged or otherwise protected from disclosure.  This e-mail is intended
solely for the use of the named addressee.  Please be aware that any other
use, printing, copying, disclosure or dissemination may be subject to legal
restriction.  If you are not the intended recipient, please notify us
immediately by return e-mail to the sender.