Re: ODBC in SQRs

[Elvis Pressly <elvisdman@HOTMAIL.COM>]

It has to be something like this:

BEGIN-SELECT -DB'DSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR'

You can also read the SQR manual for more information.


>From: Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: ODBC in SQRs
>Date: Fri, 5 Oct 2001 09:48:10 -0500
>
>Hello,
>
>I'm attempting to access a DB2 database using the ODBC command as follows:
>
>BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
>Z.ROW_IDENT &Z.ROW_IDENT
>FROM DBATEST.FIT_HR_PROF_CHGS Z
>END-SELECT
>
>The IBM DB2 ODBC DRIVER is installed and the DSN is called FIDTFSRL.   The
>platform is NT/SQL Server.
>
>I continue to recieve this error:
>
>(SQR 1303) Error in SQL (perhaps missing &name after expression):
>SELECT ROW_IDENT  FROM DBATEST.FIT_HR_PROF_CHGS
>(SQR 1304) Check SELECT columns, expressions and 'where' clause for syntax.
>
>SQR: Program Aborting.
>
>I also used the following 2 variations of the code resulting in the same
>error
>as above:
>
>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
>ROW_IDENT &Z.ROW_IDENT
>FROM DBATEST.FIT_HR_PROF_CHGS
>END-SELECT
>
>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
>ROW_IDENT
>FROM DBATEST.FIT_HR_PROF_CHGS
>END-SELECT
>
>Any thoughts are greatly appreciated!
>
>Thanks,
>Les


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