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

[Bill Robins <brobins@xxxxxxxxxxxxx>]

Mark,

I just looked at one of mine and it looks like you are missing the machines 
"network"
name.  In our company it is the machine's serial number.

SELECT ILML01.WLOC
FROM S1031561.BPCSFSA.ILML01 ILML01
WHERE (ILML01.WWHS='01')
ORDER BY ILML01.WLOC

Bill

Watkins, Mark wrote:

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