Re: Connecting to Sybase and Informix

[BOB LANG <herr_langer2@HOTMAIL.COM>]

Sorry, I missed your post. Yes, if the version file contains that info then
you should be able to use it as an ODBC.


>From: Mike Morgan <MMorgan@MELLON-INVESTOR.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Connecting to Sybase and Informix
>Date: Tue, 20 Feb 2001 11:48:24 -0500
>
>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.

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