Re: ODBC in SQRs

[Kristy Engelkes <kristy_engelkes@RSMI.COM>]

I am not sure if this is your problem or not but when
I use a connection string, I include single quotes
around it.  For example,
-DB'DSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR'

I am not sure if this will correct the
error you are getting but thought I would
pass along the observation.






Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>@list.iex.net> on 10/05/2001
09:48:10 AM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR,              Brio Technology's database
      reporting language"              <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:
Subject:  ODBC in SQRs


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