IBMDA400 OLEDB provider not working

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

IBMDA400 OLEDB provider not working

Author

Topic

Stevemc1
Starting Member

5 Posts

Posted - 2006-08-27 : 22:05:53

I am using SQL Server 2005 to try and build a cube from data from an IBM AS400.
I can define the data source OK, but when I try to build the data source view it returns just the file names from the AS400 - no field information.
I can access the AS400 just fine using ODBC, but for some reason I can't choose ODBC as a data source when building a cube.
I am running IBM Client Access V5R3 Service Pack SI24723 which is the latest I think.

raghu_gogi05
Starting Member

1 Post

Posted - 2006-09-01 : 11:31:13

Hi, Can you plz provide me the connection string you are using and also the code to access as400 stored proc? do you hv mdac 2.8 sp1 installed on your webserver machine?

Stevemc1
Starting Member

5 Posts

Posted - 2006-09-03 : 18:35:27

Thanks for your input:
<ConnectionString>Provider=IBMDA400.DataSource.1;Data Source=SASF;Persist Security Info=False;User ID=;Initial Catalog=SASF;Catalog Library List=SRVDTA</ConnectionString>

MDAC 2.8 - I am running Windows Server 2003 and the documentation says that MDAC 2.8 is included in this OS. I tried loading it anyway, and it wouldn't load, saying that it was incompatible with my OS, so I gues that is rightv

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-04 : 00:44:42

quote:
Originally posted by Stevemc1

<ConnectionString>Provider=IBMDA400.DataSource.1;Data Source=SASF;Persist Security Info=False;User ID=;Initial Catalog=SASF;Catalog Library List=SRVDTA</ConnectionString>

<ConnectionString>Provider=IBMDA400.DataSource.1;Data Source=SASF;Persist Security Info=False;User ID=;Initial Catalog=SASF;Catalog Library List=SRVDTA</ConnectionString>

Peter Larsson
Helsingborg, Sweden

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-09-04 : 02:19:18

http://www.connectionstrings.com/ is a good resource for making sure your connection string syntax is correct.

-ec

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-04 : 02:52:16

Here is a site I prefer for the clarity of providers
http://www.carlprothman.net/Default.aspx?tabid=81

Peter Larsson
Helsingborg, Sweden

Stevemc1
Starting Member

5 Posts

Posted - 2006-09-04 : 19:01:01

Thanks for the help, but now I suspect the provider is working OK, it is just when defining a Data Source View that I can't see the fields.
The reason i think this is that:

1. I can create a standard report over the same OLEDB and it can see the fields OK.
2. If I create a Named View in the Data Source View and select tables from the same OLEDB, it can also see the fields.

It is just when I add a table direct to the .dsv that I can't see the fields.
Any ideas?

Stevemc1
Starting Member

5 Posts

Posted - 2006-09-14 : 22:33:13

I have the answer to this.
The IBMDA400 OLE DB provider does not support the "OleDbSchemaGuid" .net class. This is the class that gets field names and characteristics.
The Data Source View expects it's provders to support that class.
So, I am going to try another provider

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources