You can add CCSID and PCCodePage values in the provider
string. That's where you enter any of the extended
properties that you need to set.
-Sue
On Sat, 20 Sep 2003 13:48:00 +0530, "Sriram N A"
[quoted text, click to view] <sriram.na@in.bosch.com> wrote:
>I'm attempting to set up a table on SQL Server 2000 for analysis, using
>source data from an AS/400 server and the IBM AS400 OLEDB Provider which is
>installed with the Client Access Express product.
>
>If I use the DTS Import/Export wizard, the data preview for the "Copy
>tables(s) and views(s) from the sorce database" option shows untranslated
>fields (e.g. 'NAW' shows up as D5C1E6).
>
>If I try to set up a cube in the Analysis Manager directly against this data
>source (without importing the table), the field values are not visible in
>the Cube Wizard browser; they show up as <BINARY>.
>
>I know using the *ODBC* driver, one has to set up a DSN with the "Convert
>binary data (CCSID 65535) to text" option checked to avoid this problem, but
>I don't find any equivalent configuration option for the OLEDB provider...
>what am I overlooking??
>
That's one of the limitations in the iSeries OLE DB provider. I'd say the cause
of your problem is using CCSID 65535 on your iSeries server, that is not
recommended.
--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
[quoted text, click to view]
Thanks for the tip.
I found that setting the "Force Translate" value in the IBM provider to zero
(from the default 65535) and correspondingly the boolean Auto Translate flag
to 1 (default zero) in the Advanced Connection Properties of the SQL Server
provider did the trick.
Sriram
[quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:pbqumvg6o8dksacmg1o1nnp7tm8ts1ag08@4ax.com...
> You can add CCSID and PCCodePage values in the provider
> string. That's where you enter any of the extended
> properties that you need to set.
Don't see what you're looking for? Try a search.
