Got it figured out. I found a similar issue with Oracle and the solution was to check the Allow inprocess box on the Provider options under Linked Servers, Providers in SQL. Make sure you reboot and then it appears to be working.
Now I don't have to store my data in SQL to use the Analysis services to build cubes. Thanks for the suggestions. That all checked out ok and the views were working, just not the Analysis services part. Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vance, Kathy Sent: Thursday, May 11, 2006 1:11 PM To: [email protected] Subject: RE: [U2] Linked server fails when using Analysis services I run into the similar situation while using linking Universe server in SQL. Eventually I got it fixed is: 1) check the User account and make sure it has right to read the UniVerse tables. 2) make sure the column name used in UniVerse view is not uniVerse reserved word. If you could view the data from Excel via ODBC, most of time it should work in SQL server. Kathy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, May 11, 2006 10:53 AM To: [email protected] Subject: [U2] Linked server fails when using Analysis services I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error. Data source provider error: Cannot get the column information from OLE DB provider "IBM.UniOLEDB" for linked server "M2K".;42000;The OLE DB provider "IBM.UniOLEDB" for linked server "M2K" reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
