RE: [sqr-users] SQR for ODBC Connectivity

[Bill Beckner <Bbeckner@icc.edu>]

Thanks for the tip...that is what exactly happened!! :-(  

-----Original Message-----
From: Suman Buddharaju [mailto:SBUDDHA@dot.state.tx.us] 
Sent: Wednesday, April 16, 2003 3:33 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] SQR for ODBC Connectivity


PeopleSoft might have shipped the database specific version of SQR
(instead of ODBC version of SQR) with your PeopleTools CD.

There will be a file called 'version' in your SQR bin directory.
Open the file.  If the file does not say ODBC compliant then your
-DBDSN
calls will not work.


>>> Bbeckner@icc.edu 04/16/03 02:40PM >>>
We have recently upgraded to PeopleSoft Financials 8.42 and I'm having
a bit
of trouble getting an SQR that previously worked before.

I've got a procedure that needs to connect to a different DB2 database
and
SQRW gives me the following error:

Error on line 107:
   (SQR 3730) Incorrect arguments for BEGIN-SQL:
 [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]
BEGIN-SQL -DBDSN=FS84TST;UID=xxxxxx;PWD=*******

I compared the SQR Help file for the new SQR version (SQR for
Peoplesoft
V8.42) to the previous version (SQR V4.3.4) and there is no difference
in
the -DB parameters.  Did Peoplesoft, in their infinite wisdom, disable
this
functionality?  Or am I completely clueless and I'm missing something
in the
-DB syntax?

Thank in advance!!!!

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"There are 10 types of people in the world...those that know binary
and
those that don't."

_______________________________________________
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

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