Error Messages (C)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Could not get the column information from the OLE DB provider

Using Microsoft SQLServer's linked server option, trying to "view" a Table or View results in the following error:

Error:
Error 7311: Could not obtain the schema rowset for OLE DB provider "UNKNOWN". The provider supports the interface, but returns a failure code when it is used.

Server: Msg 7350, Level 16, State 2, Line 1
Could not get the column information from the OLE DB provider
'OpenLinkODBC'

Resolution:

1. Link in the remote server, select "Provider Options".

2. Check the "In Process" option.

This will resolve the problem.