Re: ODBC in SQRs

[Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>]

Elvis,

We have found success!   The problem was with the password.

I used the DBAs login and the ODBC to DB2 via SQL Server proved successful.
The tricky thing was that the ODBC connection ocurred with my Login but I did
not have the rights to Select the table. As a result the error masked itself as
a problem with the Select, Column, Where and &name.

Thank you for help Elvis, Kristy Engelkes, Steve Schelske, and Nigel Ho!

Les





Elvis Pressly <elvisdman@HOTMAIL.COM> on 10/08/2001 09:19:00 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Les Brugere/Systems/ais)

Subject:  Re: ODBC in SQRs



YES for 3 & 4. You will need SQLTalk for 5 (call Centura.com).


>From: Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: ODBC in SQRs
>Date: Fri, 5 Oct 2001 16:20:27 -0500
>
>Elvis,
>
>Here are the anwers to your questions.   Are items 3, 4, and 5 mandatory
>for
>this to work?   Thanks again, Les
>
>1. Are you using DB2 UDB or simply DB2/400 in AS400?
>We have DB2 UDB
>
>2. Is this the first time you are going to connect to AS400?
>NO
>
>3. Are proper profiles in AS400 created? like connect Id and
>    owners,,etc..?
>NO
>
>4.Does both your AS400 and client PC has Client Access product?
>NO
>    are they both on the same service pack?
>NO
>
>5. Using an SQL tools (like SQLPlus) can you connect to AS400?
>No.  Have unsuccessfully tried from SQL Server using: Select * from
>OPENQUERY(WUMVS2,'SELECT * FROM DBATEST.FIT_DEPT_INFO')
>
>6. What is your client PC?  95 97 98 NT 2000 ?
>NT 4.0
>
>7. What version of SQR you are using?
>V6.1.4
>
>
>
>
>Elvis Pressly <elvisdman@HOTMAIL.COM> on 10/05/2001 02:46:22 PM
>
>Please respond to sqr-users@list.iex.net
>
>To:   SQR-USERS@list.iex.net
>cc:    (bcc: Les Brugere/Systems/ais)
>
>Subject:  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


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