BPCS, ODBC, ADO, ASP, & !@%&^$#

["Watkins, Mark" <MWatkins@xxxxxxxxxxx>]

        I've just installed NetSoft's ODBC drivers, and although they
are working fine with MS Access I'm getting a little frustrated trying
to retrieve BPCS data via our web server (NT/IIS) using ADO/Active
Server Pages. 

        I'm new to ASP but have found out by working with Oracle that
ADO apparently needs SQL statements to be in a format native to the
database being queried. Unfortunately I know nothing about DB2 (?)
syntax. I guessing the problem lies in how the schema is being
referenced. Access sees the tables as LIBRARY_TABLE i.e.:
"BPCSMPF_ZSCL01", but ADO wouldn't take that. I also tried
BPCSMPF.ZSCL01 and just ZSCL01, with the same results. Can someone give
me an example of the proper way to specify a tablename for this
database? I'd love to hear from anyone with experience using active
server pages to access BPCS.

        Here is the error the driver returns:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Netsoft][NS/NSODBC][SQL/400][DRDA Error]Token was not valid. Valid
tokens: FOR . SQLCODE=-104 SQLSTATE=42601 (262) DRDA SQL Prepare Error 

        This is the query as defined in Access:

SELECT BPCSMPF_ZSCL01.ZPRF, BPCSMPF_ZSCL01.ZCLP, BPCSMPF_ZSCL01.ZTREF,
BPCSMPF_ZSCL01.ZWHSE FROM BPCSMPF_ZSCL01  WHERE
(((BPCSMPF_ZSCL01.ZPRF)='MWATKINS'));

        Thanks for your help...


   Mark Watkins
   Information Technologies
   Shaklee Technica, Norman OK
   mwatkins@shaklee.com
   (405) 573-4293
   
+---
| 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
+---