Assuming that spt_values is a table, I think your problem lies in the
database that you're trying to get the table from. If you examine the
error string "master.dbo.spt_values" that indicates that you're trying to
access the MASTER database, where this table hopefully isn't stored. The
master database should never contain any user tables.
Thomas
> Hi All:
>
> In creating a database project (following the example in Beginning Web
> Development with Visual InterDev 6.0), when connecting to my SQL 2000
> database server, I get a splash indicating an ADO Error: Invalid Object
> Error: ?master.dbo.spt_values?.
>
> I?m in Windows Professional 2000 with IIS 5.0 and Visual Studio 6.0
(SP5). I
> ?ve already tried reloading and reinitializing all the software in the
> environment, with no change in the result. Any ideas would be greatly
> appreciated. I also found nothing in MSDN that helps.
>
> Thanks in advance,
>
> Michael Simmons
>