Creating a Linked server to a tmberline database   

Hi all,
I have a Timberline construction application that I am trying to link to SQL 
server 2005 so I can import the data to SQL server for reporting services.  I 
have created the linked server using the below CREATE LINK SERVER below and 
if I right click and test connection it is succesful, when I try to drill 
down into the tables I get the below SCHEMA ERROR:

I have not been able to find an answer online nor did the support at 
timberline help me with this.  They only know how to use excel and Access

TIA,
Joe

CREATE LINK SERVER:
EXEC master.dbo.sp_addlinkedserver @server = N'TIMBER', 
@srvproduct=N'timberline data Source', @provider=N'MSDASQL', 
@datasrc=N'timberline data source'
 /* For security reasons the linked server remote logins password is changed 
with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin 
@rmtsrvname=N'TIMBER',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'collation 
compatible', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'data access', 
@optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'dist', 
@optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'pub', 
@optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'rpc', 
@optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'rpc out', 
@optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'sub', 
@optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'connect 
timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'collation 
name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'lazy schema 
validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'query 
timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TIMBER', @optname=N'use remote 
collation', @optvalue=N'true'

SCHEMA ERROR:
"Microsoft SQL Server Management Studio

            Failed to retrieve data for this request. 
(Microsoft.SqlServer.SmoEnum)
            Additional information:

                An exception occurred while executing a Transact-SQL 
statement or batch. 
                (Microsoft.SqlServer.ConnectionInfo)
                    The OLE DB provider "SQL Server" for linked server 
"(null)" reported an error. One or more 
                    arguments were reported invalid by the provider.
                    Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for 
OLE DB provider "SQL Server" for
                    linked server "(null)". The provider supports the 
interface, but returns a failure code when it is 
                    used. (Microsoft SQL Server, Error: 7399)"

date: Tue, 10 Jun 2008 07:04:00 -0700   author:   jaylou