August 28, 2008 at 2:08 am
Hi,
I've searched all over and can't find any solutions to this.. hope this is the right forum.
I'm trying to create a Report Model, for use in Reporting Services 2008, which is based on an Informix database.
Clearly I can't add a datasource for Informix in the report model project, as it only supports SQL and Oracle.
So I tried the route of building the data source and a view in Analysis Services first.
The platform is SQL 2008 Enterprise running on Windows Server 2003 Standard SP2.
With Analysis services, there are 2 options for the data source, either using the IBM Informix .Net Data provider, or using the IBM Informix OLE DB provider.
The .Net provider says "Failed to find or load the registered .Net Framework Data Provider" so I can't create the data source using this provider. The provider is installed and being used just fine in other apps on the same server, but just won't work here.
Using the OLE DB provider, I first had the issue requiring me to run scripts on the databse to create the OLE DB provider system tables. I can create the data source successfully using the OLE DB provider, but it fails when attempting to load the schema info from the database. The error message I get is as follows:
Code Snippet===================================
'Ifxoledbc.2' failed with no error message available, result code: E_FAIL(0x80004005). (Microsoft Visual Studio)
------------------------------
Program Location:
at System.Data.OleDb.OleDbConnectionInternal.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbMetaDataFactory.PrepareCollection(String collectionName, String[] restrictions, DbConnection connection)
at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection connection, String collectionName, String[] restrictions)
at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbConnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions)
at System.Data.OleDb.OleDbConnection.GetSchema(String collectionName, String[] restrictionValues)
at Microsoft.DataWarehouse.Design.OleDbSchema.GetSchema(String collectionName, String[] restrictionValues)
at Microsoft.DataWarehouse.Design.DataSourceConnection.GetSchemaTable(DataTable& dataTable, String collectionName, String[] restrictions)
at Microsoft.DataWarehouse.Design.DataSourceConnection.ConvertGetSchema(DataTable& dataTable, Guid schemaEnum, Object[] restrictions)
at Microsoft.DataWarehouse.Design.DataSourceConnection.GetSchemaTable(DataTable& dataTable, Guid schemaEnum, Object[] restrictions)
at Microsoft.AnalysisServices.Design.ChooseDBObjectsControl.GetAllTableList(Boolean populateSelectedItems, ArrayList& tableList, ArrayList& sysTableList, ArrayList& viewList, ArrayList& sysViewList)
at Microsoft.AnalysisServices.Design.ChooseDBObjectsControl.PopulateAvailableItems(Boolean populateSelectedItems)
at Microsoft.AnalysisServices.Design.ChooseDBObjectsControl.PopulateItems(Boolean populateSelectedItems)
Has anyone tried this before or perhaps got any information for me?
Any help would be much appreciated.
Thanks,
Stephen
March 23, 2009 at 1:09 pm
I've just connected an Informix box as a linked server to SQL Server 2008 Developer Edition, and we had to have the DBA's for the Informix box run some kind of sysmaster thing that allowed access to metadata before we could view the tables in SSMS. Sounds like that may be a part of the problem, but not sure.
I'm trying to figure out why we're getting metadata errors when we run a query, where SQL Server indicates it sees a longer field length at compile-time than at run-time.
Steve
(aka smunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply