Re: Speaking of ODBC drivers....

[DAsmussen@xxxxxxx]

Mark,

In a message dated 99-03-12 19:01:18 EST, you write:

>       I am still looking for a solution to a problem I'm having using
>  Active Server Pages to publish BPCS data on our intranet. I'm using
>  NetSoft's ODBC drivers, and while they work fine getting data into MS
Access
>  I can't seem to get the server to accept an SQL statement from an ASP page.
>  Is anyone on the list using ASP successfully? It works great with our
Oracle
>  databases but not with BPCS.

You probably need to look at your user exit points.  If you have CIM installed
(or have had at an earlier date), an SSA program gets placed in the old PCSACC
parameter under WRKNETA that intercepts client requests through PC Support
(Client Access) -- persons with access to BPCS information via PC only _MUST_
be authorized within BPCS to access this data.  There are also several entries
under the system registration system (WRKREGINF) that can affect ODBC access.
Amazing that SSA _STILL_ hasn't gotten their green screen access right, but
can stick these little gems out there for us PC users...

Regards!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-mail:  DAsmussen@aol.com

"It's better to look where you're going, rather than where you've been.
Especially if you're not too crazy about where you've been!" -- Anonymous
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---