Re: OLE DB returning junk

["Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>]

I ran the same query in the Run SQL Scripts in Operations NAvigator and it
returned the non translated data as well.

The as/400 is running 4.4 and i am using CAE 5.1.

----- Original Message ----- 
From: "Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Monday, September 29, 2003 4:29 PM
Subject: OLE DB returning junk


> I am doing a query on the AS/400 from Visual Basic OLE DB and some of the
> fields are returning question marks.  Is there a way to set a CCSID value
or
> something via OLE DB?  Any other ideas what it could be?  When I pull down
> the data via the Excel Add-in and set the CCSID property it comes back ok,
> but if I don't, the fields that I get back in VB with problems also show
up
> in Excel with problems.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.