Re: SQLBASE/SQR configuration problem

[*Sehat Rosny <SRosny@SMTPGW.ARMS.OHIO-STATE.EDU>]

Hello Aruna
 For sqr configuration instead of using -cb option
i used below statement.

-iC:\user\sqr\;C:\hr600\sqr\;C:\hr600\user\sqr\;C:\hr600\sqr\;
-mC:\hr600\sqr\allmaxes.max -oC:\temp\sqr.log -fC:\temp\  -cb

however, this may be a different issues then the error message that
you get. HR600 is the directory for the peoplesoft installation.
The statement above is to find the sqc,sqr and sqr setting.
If this does not help take alook at the file below
c:\autoexec.bat
c:\bat\pssetvar.bat
c:\windows\sqr.ini
(and compare it to the other machine which sqr are working)
Usually this is the main three files that set up SQR


bye
Sehat Rosny
PeopleSoft and SQR Developer




>
>hi,
>
>To all the SQR pundits:
>
>I have installed SQR version 3.0.13.7 on Windows 95 Desktop with SQLBASE
>version 6.x and Intersolv ODBC Drivers comptabile with SQLBASE version.
>
>I am trying to execute the sample program given below. I just give the
>-cb option when running SQRW.
>
>begin-report
>    do sampleProg
>end-report
>
>begin-procedure sampleProg
>begin-select
>emplid(,1)
>from ps_personal_data
>end-select
>end-procedure
>
>The error I get is as follows:
>
>(SQR 5528) ODBC SQL dbSql : SQLPrepare Error 902 in cursor 1:
>[INTERSOLV] [ODBC SQLBASE DRIVER] [SQLBASE] 00902 PRS MFC Missing From
>clause
>
>Error on line 10 :
>(SQR 3716) SQL Stmt
>
>I am able to run the sample program successfully on a different Windows
>95 Desktop with the same versions. The only difference I did not do the
>installation on this machine.
>
>I feel it is just a configuration issue and I have not properly set some
>value. Could one of the gurus tell me what it is that I am missing?
>
>thanx in advance
>
>aruna
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>