BDC and AdventureWorks SQL 2005 Version

Hi,

I'm trying to work with the AdventureWorks sample database SQL 2005
version and BDC in MOSS 2007. The application is correctly defined in
MOSS, using the sample XML application definition file for
AdventureWorks SQL2000 version. When I try to retrieve data from the
web part, I get an error message stating "An error occurred while
retrieving data from AdventureWorksSQL2005. Administrators, see the
server log for more information". First question - Which server log?
(MOSS, SQL, others)

Also, in the Event Viewer of the server, I found this entry:

Could not run query/stored proceedure 'SELECT ProductID, Name,
ProductNumber, ListPrice FROM Product WHERE (ProductID >=
@MinProductID) AND (ProductID <= @MaxProductID) AND (Name LIKE @Name)
AND (ProductNumber LIKE @ProductNumber)' using 'Data
Source=OFFICE2007;Initial Catalog=AdventureWorks;Integrated
Security=SSPI;Pooling=false;Persist Security Info=false;' in App
Domain '/LM/W3SVC/858119008/Root-1-128152197026259408'. The full
exception text is: Invalid object name 'Product'.

It seems to me that one or many elements of the SQL2005 version of the
AdventureWorks database is not similar to the SQL2000 version, from
which the sample XML application file has been based on.

Anyone has similar problem?

Thanks in advance

[1420 byte] By [DJLordee] at [2008-2-7]