Invalid object name 'master.dbo.spt_provider_types'

[PaulG]

When the following code is run, the message "Invalid object name 'master.dbo.spt_provider_types'" is displayed.

SQLDataSet1.SetSchemaInfo(stColumns, 'HumanResources.Employee', '');
SQLDataSet1.Open;

---
Delphi 7
SQL Server Express
dbexpsda.dll 3.0.2.0

[Ikar]

Thank you for information.
It's a known problem and we've already fixed it.

New fixed build (3.00.3) will be available approximately on this week.

[carlobar]

I've the same problem using 2.50.7 driver to obtain metadata information from a 2005 server.
From the source code I've notice that the query uses master.dbo.spt_provider_types also for 2005 server, but this object doesn't exists.
Can you fix this problem into 2.50 driver?
Thanks

[Antaeus]

This task is rather difficult because it affects mechanism of metadata retrieval in general. We do not plan to add such enhancement to DbxSda 2 in the nearest future.