Page 1 of 1
Invalid object name 'master.dbo.spt_provider_types'
Posted: Wed 15 Feb 2006 15:16
by 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
Posted: Mon 20 Feb 2006 12:41
by 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.
Same problem with 2.50.7 driver
Posted: Wed 26 Jul 2006 15:17
by 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
Posted: Thu 27 Jul 2006 11:48
by 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.