[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] DSN question
Thanks for the info. Yes, PeopleSoft does deliver an ODBC version of SQR.
Thanks again,
------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.
Voice (214) 904-2550
Fax (214) 350-0941
------------------------------------------------
Bill Beckner
<Bbeckner@icc.edu To:
"'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
> cc:
Sent by: Subject: RE: [sqr-users] DSN
question
sqr-users-admin@s
qrug.org
04/24/03 10:56 AM
Please respond to
sqr-users
You can use a variable in the -DB construct. For example:
LET $DbConnect = 'DSN=' || $DBName || ';UID=xxxxxx;PWD=yyyyyy'
BEGIN-SQL -DB$DbConnect ON-ERROR=SQL-Error
We ran into a problem though...the version of SQR that was delivered does
not support ODBC connectivity (SQR for PeopleSoft v8.4). Does PeopleSoft
have an ODBC version?
--
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."
-----Original Message-----
From: Ramzi_Salameh@daveandbusters.com
[mailto:Ramzi_Salameh@daveandbusters.com]
Sent: Thursday, April 24, 2003 10:39 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] DSN question
Good morning group,
Is it possible to use a variable in the -DB construct for the DSN value.
We are wanting to be able to point to a specific database instance to
process an update on, based on the environment the SQR is running from,
without having to have different procedures to call depending on the
environment. We're using SQL Server 2000, PeopleSoft 8, SQR for PS 8.
------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.
Voice (214) 904-2550
Fax (214) 350-0941
------------------------------------------------
_______________________________________________
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