Re: CA ODBC Error : "Error in host server data stream"

That was the first thing I checked.

I know the connection works, since I can display all the available AS/400 
tables if I click on the sever under the 'Linked Servers' option.

On Thu, 31 Oct 2002 08:18:38 +1300, Evan Harris wrote:

>Hi Rich
>
>just a wild stab in the dark here - the user profile you were using hasn't
>expired or require its password reset does it ?
>
>regards
>Evan Harris
>
>>Hello all -
>>
>>I recently set up a connection between a SQL Server 7 server and our
>>AS/400 (running
>>V5R1) with the AS/400 set up as a linked server.
>>
>>It worked fine for a couple weeks, but now every time we try and access
>>any data
>>we get this error message: "[OLE/DB provider returned message:
>>[IBM][Client Access
>>Express ODBC Driver (32-bit)]Error in host server data stream.]".
>>
>>Other than rebooting the SQL server, nothing we know of has changed - no
>>PTF's, service
>>packs, etc.  Does anyone have any ideas?
>>
>>
>>
>>Rich Herdman
>>Abbott Foods
>>Columbus, OH
>>email: rherdman@abbottfoods.com
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>


Rich Herdman
email: rherdman@columbus.rr.com
http://www.columbus.rr.com/~rherdman

"He who breaks a thing to see what it is has lost the
path of wisdom." - Gandalf, 'The Lord of the Rings'