Using SQL Server Management Studio to set up an Oracle Linked Server.

When setting up a linked server to Oracle from a SQL Express 2005 instance using the OraOLEDB.Oracle OLE DB Provider you need to be able to change the “AllowInProcess” property to true from the provider properties. Or it doesn’t work.

Problem… when connecting to a SQL Express 2005 instance there is no properties dialog available for the provider.

Solution:

EXEC sp_MSset_oledb_prop N’OraOLEDB.Oracle’, N’AllowInProcess’, 1

in the master database.