No Subject

[Ali Dosani <adosani@YAHOO.COM>]

Hi Ben,
I have coded a similar program on SQL Server.
Here is a sample sql statement

BEGIN-SELECT  -DBDSN=CURDEVDB;UID=sa;PWD=aaaaa
Z.EFFDT
Z.EFF_STATUS
Z.CR_LIMIT
 Z.COLLECTION_STATUS
 FROM PS_CUST_CREDIT Z
 WHERE Z.SETID = &A.SETID
AND Z.CUST_ID = $a.cust_id
END-SELECT

You need first setup an ODBC connection string.
If you don't know where it is
 Start ---> Setting --->control panel --->ODBC
The datasource name you give there should be the
-DBDSN name.

I hope this would help.

---Ben Lawrence <ben_lawrence69@HOTMAIL.COM> wrote:
>
> Hello, all.  I am running on a sql-server platform and would like to
> connect to another database without having to log out of the current
> database within SQR.  I came across a parameter to add to the end of
the
> Begin-Select called '-DB'.  Is this what I would have to use to
connect
> to another database, and if it is, how do I use it, i.e. do i need to
> input username and password and what is the syntax.
> Thanks for your help in advance.
> Ben
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>

==
Dosani Ali

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com