Re: Connecting to another database

[Stephen Keen <Stephen_Keen@SQR-SERVICES.COM>]

It works in mine without quotes

Steve


-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Elvis Pressly
Sent: Tuesday, May 08, 2001 2:18 PM
To: SQR-USERS@list.iex.net
Subject: Re: Connecting to another database

Peter/Stephen

It should be enclosed in single quote like:

   -DB'DSN=DSNNAME;UID=userid;PWD=password'

This has been working for me between Oracle(source) and
SQL server(target) and vice versa as long as both has been
defined in ODBC using odbc admin.


>From: Stephen Keen <Stephen_Keen@SQR-SERVICES.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Connecting to another database
>Date: Tue, 8 May 2001 12:41:38 -0400
>
>Here is the string I use
>
>         Begin-Select
>-DB=databasename;DSN=DSNNAME;UID=userid;PWD=password
>
>-----Original Message-----
>From: Discussion of SQR, Brio Technology's database reporting language
>[mailto:SQR-USERS@list.iex.net]On Behalf Of Stan Quick
>Sent: Tuesday, May 08, 2001 12:28 PM
>To: SQR-USERS@list.iex.net
>Subject: Re: Connecting to another database
>
>Peter,
>You are currently using SQR/Oracle, which is not capable of connecting to
>ODBC data sources.  You
>would need SQR/ODBC to connect to SQL Server.
>Stan
>
>-----Original Message-----
>From: Mark Pietersz [mailto:MPietersz@ADECCO.COM.AU]
>Sent: Monday, May 07, 2001 3:43 AM
>To: SQR-USERS@list.iex.net
>Subject: Connecting to another database
>
>
>Folks,
>
>
>I a Peoplesoft environment I am trying to connect to another database in a
>BEGIN-SELECT using -DB
>
>Oracle is the primary (Peoplesoft) database, SQL Server the target
>
>ie BEGIN-SELECT -DBconnect string
>
>I have set up a USER DSN and tested it to see if it connects OK
>
>I have tried a number of different variations for the connect string but I
>can't get it to work.
>
>
>    (SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
>  BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn]
>               [ON-ERROR=procedure[(arg1[,argi]...)]]
>BEGIN-SELECT -DBDSN=SQLServer;UID=PSADM
>(SQR 5528) ORACLE OPARSE error -942 in cursor 4:
>    ORA-00942: table or view does not exist
>SQL:  select USERNAME  FROM dbo.tblAccountManagers
>Error at:  tblAccountManagers
>
>Error on line 279:
>    (SQR 3716) Error in SQL statement.

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