You are viewing limited content. For full access, please sign in.

Question

Question

9227 error can not locate external table for views in SQL

Laserfiche
Updated March 31, 2014
asked on March 24, 2014

 

I have Several SQL views that are getting their data from an ORACLE DBMS. I have a SQL Table under the Database portion that I can attach to with the external table under metadata in the admin console but cannot attach to the views under the same Database 

0 0

Answer

APPROVED ANSWER
replied on March 31, 2014

The application event log was reporting

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "[Server Name]".

 

The change in the SQL Server setting mentioned in this page was recommended to address the matter.

0 0

Replies

replied on March 25, 2014

Comparing the table that can be configured successfully versus the view that cannot, are there any differences between the two objects other than the fact that one is a table and one is a view? For example, could they be using different schemas, i.e. one is using dbo and the other is using something else?

0 0
replied on March 26, 2014

They are both dbo.crosscrop the table and dbo.crops the view of the Oracle db

0 0
View 1 previous reply
replied on March 26, 2014

Can you confirm that there are no leading or trailing spaces in the view name? If that's been verified and the issue still occurs, please open a support case.

0 0
replied on March 26, 2014

Hi, I am the customer working with Var Mark H.

The issue seems to be between sql server 2012 and LF9.1. I can connect to database table as Mark indicated, but cannot connect to a view. This is not exclusive to the views created from the Oracle linked tables. I tried to make a connection to a db on the same ms server and it failed with the same error.

 

0 0
replied on March 26, 2014

You can check the application event log on the Laserfiche Server computer for more details about the error. Is the database using a case sensitive collation? Are you specifying the view using the same casing that it's actually using in SQL?

0 0
APPROVED ANSWER
replied on March 31, 2014

The application event log was reporting

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "[Server Name]".

 

The change in the SQL Server setting mentioned in this page was recommended to address the matter.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...