I need step by step instructions to setup QODBC as a linked server for -

Quick Books Enterprise Solutions - Professional Services Editon 6.0 & SQL Server 2005 (Express) using

MS SQL Management Studio Express

Any help is appreciated.

Thanks in advance.

See: Does QODBC work with MS SQL Server 2005 Linked Tables? 

Thanks for your response.  I still am not able to do it.  in http://www.qodbc.com.au/SQLServer.htm under section for 'Creating a Linked Table in Microsoft SQL Server 2005' section about "connection Properties" and "Providers", no tabs are found in the New Linked Server setup interface for "connection Properties" and "Providers".  so Dynamic parameter, Allow InProcess etc couldnt be configured.

Upon running the query, SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Host')

The following errors were received:  Any assistance is appreciated.

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

If this doesn't work, check your Ole Automation Procedures Option because it may be turned off in your 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

Tom,
Thank you for your response.
I followed step by step instructions to setup QODBC Remote and then tryied to create Linked Table in
MS SQL 2005 Express Followed instructions online -used interfaces till the stp to edit
Connection Properties or Provider Options.  Then I ran your sript - which ran without errors.
Then completed the setup using the interface of SQL Studio.
Querying the ODBC datasource results in errors - times out & finally when I cancel the query, this is what I get . 
Any help is appreciated. Thanks in advance.  The SQL error is below -

Tom,

I tried that - no luck.  I tried QODBC DCOMs - no luck either. 

Then I  tried to export a report from Quick Books into MS Excel, & this is the  error I get -
_______________________________________________
Installation Error:File not Found

A required installation file SKU111.CAB could not be found.

Orfinal Installation source Required:

If you installed Microsoft Office Professional Edition 2003 from a CD, please insert your CD. 
If you installed Microsoft Office Professional Edition 2003 over your computer network, please browse
to the installation source on your network.  Once you have located yourinstallation source, click OK.
_______________________________________________

Excel by itself is working.  SKU111.CAB  google results point to wrong CD used to install MS Excel.....
But does this have anything with ODBC not working? 

Thanks again!