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

Your SQL statement should be formatted as follows

SELECT ZPRF, ZCLP, ZTREF, ZWHSE FROM BPCSMPF/ZSCL01  WHERE ZPRF='MWATKINS';



-----Original Message-----
From: Watkins, Mark <MWatkins@shaklee.com>
To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
Date: Wednesday, September 23, 1998 4:34 PM
Subject: BPCS, ODBC, ADO, ASP, & !@%&^$#


> 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
>+---
>

+---
| 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
+---