× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2003

RE: OLE DB returning junk

Is it not possible to correct the CCSID of the source data?  CCSID 65535 is
used to indicate binary data, and as such will not translate EBCDIC to ACSII
as you wish.  CHGPF lets you change CCSID (with some restrictions, see
help).  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Adam Lang [mailto:aalang@xxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, September 30, 2003 10:44 AM
To: Midrange Systems Technical Discussion
Subject: Re: OLE DB returning junk


If I add it to the .Properties() property it errors out.  If I add it to the
connections string, there is no change and it just doesn't work.  The only
thing I can assume at this point is that I am using a different version of
the OLE DB provider against the different OS/400 version.

I'm just going to have to use the OLE DB provider through ODBC since it
works that way.

----- Original Message ----- 
From: "Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, September 30, 2003 11:01 AM
Subject: RE: OLE DB returning junk


> Adam,
>
> On the connection string specify 'Force Translate=0'
>
> -Walden
>
> See:
>
http://www-1.ibm.com/servers/eserver/iseries/access/oledb/techref/v5r1/cwbzm
> tchforce_translate.htm
>
> ------------
> Walden H Leverich III
> President
> Tech Software
> (516) 627-3800 x11
> (208) 692-3308 eFax
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
>
> -----Original Message-----
> From: Adam Lang [mailto:aalang@xxxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, September 30, 2003 10:29 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: OLE DB returning junk
>
>
> well I doubt it is a property of the adodb connection object, so I assume
it
> is something i need to pass to attributes or something.  Any idea?
> ----- Original Message ----- 
> From: <MWalter@xxxxxxxxxxxxxxx>
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Sent: Tuesday, September 30, 2003 10:18 AM
> Subject: Re: OLE DB returning junk
>
>
> >
> > I believe there is an option when creating the connection object.
> >
> > Thanks,
> >
> > Mark
> >
> > Mark D. Walter
> > Senior Programmer/Analyst
> > CCX, Inc.
> > mwalter@xxxxxxxxxx
> > http://www.ccxinc.com
> >
> >
> >
> >                     "Adam Lang"
> >                     <aalang@rutgersinsura        To:     "Midrange
Systems
> Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> >                     nce.com>                     cc:
> >                     Sent by:                     Subject:     Re: OLE DB
> returning junk
> >                     midrange-l-bounces@mi
> >                     drange.com
> >
> >
> >                     09/30/2003 10:07 AM
>
> >                     Please respond to
> >                     Midrange Systems
> >                     Technical Discussion
> >
> >
> >
> >
> >
> >
> > Yeah, I just discovered that.
> >
> > So now the situation is this:
> > For Operations Navigator, if I go to JDBC setup and check translation,
it
> > returns the proper data.
> >
> > If I use the ODBC driver and tell it to translate, it works.
> >
> > But if I use the OLE DB provider, it still doesn't work (no where I know
> of
> > to implicitly tell it to translate).
> >
> > ----- Original Message -----
> > From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
> > To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> > Sent: Tuesday, September 30, 2003 9:54 AM
> > Subject: RE: OLE DB returning junk
> >
> >
> > > Sounds like all your files are CCSID 65535, which indicates binary
data
> > and
> > > is not translated unless you've checked the "Convert CCSID 65535"
> > property
> > > in your data source.
> > >
> > > Eric DeLong
> > > Sally Beauty Company
> > > MIS-Project Manager (BSG)
> > > 940-898-7863 or ext. 1863
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Adam Lang [mailto:aalang@xxxxxxxxxxxxxxxxxxxx]
> > > Sent: Tuesday, September 30, 2003 8:38 AM
> > > To: Midrange Systems Technical Discussion
> > > Subject: Re: OLE DB returning junk
> > >
> > >
> > > 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.
> > >
> > > _______________________________________________
> > > 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.
> > >
> > >
> > > _______________________________________________
> > > 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.
> >
> > _______________________________________________
> > 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.
> >
> >
> >
> >
> >
> > _______________________________________________
> > 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.
>
> _______________________________________________
> 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.
> _______________________________________________
> 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.

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.