Iain Sharp (iains@pciltd.co.uk) writes:
> Unfortunately, it uses its own database. It does come with an ODBC
> driver, and I did find the Linked server option to set it up. This has
> met with limited success. (One table appears to return all values but
> there are only 15 in the database, one fails after about 30).

In that case, specifying SQLOLEDB is no road to success, but it seems
that you have already returned from that blind alley.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx