Re: (SPAM)(22.1417) [sqr-users] Connect to different instance

["Jamie Harris" <JHarris@frederick.edu>]

Murali,
 
Another way you could do this without a DB link is this:
 
begin-select -DBDSN=database;UID=userid;PWD=password
 
 
That tells it to use the "database" datasource name and the user id and 
password selected.  This datasource is only used with that specific select 
statement (it works with begin-sql too) while all other database activity 
happens in the main database.
 
The downside here is that the SQR needs some way to receive the username and 
password to use - say from the command line or in a run control (or you could 
hard-code the user/password in the SQR, but then anyone who can see the SQR 
code knows how to login as that user).  
 
 
-----------------------------------------------------
James Harris
Enterprise Application Analyst/Programmer
Information Technology Division
Frederick Community College 

-----------------------------------------------------

>>> "Kaithi, Murali" <Murali.Kaithi@spencergifts.com> 8/9/2007 2:24 PM >>>
Hi,
I am processing sqr from one instance for example
userid/password@database.
Within the program I have to get some data from another instance for
example userid1/password@database.
In the above example only the change is userid.
How can I specify the from clause in my sqr when going to the different
instance.
Any help would be appreciated.

Thanks,
Murali

________________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning Services, 
utilizing MessageLabs proprietary SkyScan infrastructure. For more information 
on a proactive anti-virus service working around the clock, around the globe, 
visit http://www.paetec.com. ( http://www.paetec.com./ )
________________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users