Linked server to oracle fails to retrieve column information

· Uncategorized
Authors

After setting up a linked server to oracle, the connection was tested successfully.
But when using the linked server in an openquery, following error message was generated:

“Cannot get the column information from OLE DB provider “OraOLEDB.Oracle” for linked server.”

Solution was to check the “Allow inprocess” option in the Oracle provider properties.

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: