[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: ODBC in SQRs

Les,

I getting quite confused here. I need more clarification because
I believe the error is coming out of your "FROM" clause. Do not
always believe what the error messages says because sometimes they
are misleading.

1. Are you using DB2 UDB or simply DB2/400 in AS400?
2. Is this the first time you are going to connect to AS400?
3. Are proper profiles in AS400 created? like connect Id and
   owners,,etc..?
4. Does both your AS400 and client PC has Client Access product?
   are they both on the same service pack?
5. Using an SQL tools (like SQLPlus) can you connect to AS400?
6. What is your client PC?  95 97 98 NT 2000 ?
7. What version of SQR you are using?


I asked you this because I have been writing SQRs to connect to
different platforms(sometimes three at the same time) and never
had a problem as long as setups at both ends are satisfied.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp