See: Does QODBC work with MS SQL Server Linked Tables? and How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? for more on DCOM setup.

You just need to setup the defaults for QODBC:

The opening mode is in the QODBC setup or connection string and includes multiple ways of opening a QuickBooks file:

• Same as company file If you select “Follow Company File”, we will simply use whatever mode is currently set on the company file.
• Multi-user mode Selecting “Multiuser Mode” will set the file to Multi-user status, where multiple users can update the file simultaneously.
• Single-user mode If you require exclusive write access to the file (for record deletes), select “Single User Mode”.

Sorry, using the QODBC Remote Connector as your connection method for your MS SQL Server 2005 Linked Server isn't going to provide you with adequate throughput.

See your MS SQL Server 2005 documentation for Linked Server instructions, from what I see on Microsoft.com they are similar. You just need to setup your defaults for QODBC.

Please upload some screen dumps of your MS SERVER 2005 Linked Server setup to look at. Use the Insert/Edit image button and then click on "Browse Server" and "Browse" to locate the screen dump on your computer.

Ok, you're just missing "QODBC" as the Linked Server name at the top. See if you can find where all the "Provider Options" for the Microsoft OLE DB Provider for ODBC Drivers have gone and post up the screen dumps of this also (as I will update the Does QODBC work with MS SQL Server Linked Tables? topic to show both SQL Server 2000 and SQL Server 2005 with a little help from you).

You will also need to specify the company file to open in QODBC and setup auto-login mode, see: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running?  for these details.

My understanding is that SQL Server 2005 does not have the property menu item on the Link Server providers like SQL Server 2000. The OLE DB provider options for managing linked queries can be set in SQL Server Management Studio. In Object Explorer, right-click the provider name and select Properties. If you can't configure them through the UI as indicated in the directions you can script this action like this:

USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'DynamicParameters', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'IndexAsAccessPath', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'LevelZeroOnly', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'NestedQueries', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'NonTransactedUpdates', 1
GO

But you can also run the query directly without OPENQUERY like this:

SELECT ListID, Name, CompanyName FROM QODBC...Vendor

Some developers have also reported that their Ole Automation Procedures Option was turned off in thier SQL Server Surface Area Configuration.

To turn it on with a query, see:
http://msdn2.microsoft.com/en-gb/library/ms191188.aspx

which contains:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO