Query database on linked server where database has name like [ABC.DEF]  
Author Message
BibleJohn





PostPosted: Tue Jan 10 10:50:02 CST 2006 Top

SQL Server >> Query database on linked server where database has name like [ABC.DEF]

A database exists on a linked server that I would like to query

When I run the following command
SELECT * from [INSTANCE_NAME].[ABC.DEF].dbo.sysfiles
-- Note the name of database has an "." in it (I cannot change this)

I get the error
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object '"ABC.DEF"."dbo"."sysfiles"'. The OLE DB
provider 'SQLOLEDB' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to
process object, since the object has no columnsProviderName='SQLOLEDB',
Query="ABC.DEF"."dbo"."sysfiles"'].

This query works on other databases on this instance and other
instances.

Does anybody have any ideas?

SQL Server225  
 
 
bluefish





PostPosted: Tue Jan 10 10:50:02 CST 2006 Top

SQL Server >> Query database on linked server where database has name like [ABC.DEF] Does the SQL Server has multiple instances in the same box? I have noticed
that Link Server is unable to recognize\access the second instance when
there are multiple instances..




> A database exists on a linked server that I would like to query
>
> When I run the following command
> SELECT * from [INSTANCE_NAME].[ABC.DEF].dbo.sysfiles
> -- Note the name of database has an "." in it (I cannot change this)
>
> I get the error
> Server: Msg 7357, Level 16, State 2, Line 1
> Could not process object '"ABC.DEF"."dbo"."sysfiles"'. The OLE DB
> provider 'SQLOLEDB' indicates that the object has no columns.
> OLE DB error trace [Non-interface error: OLE DB provider unable to
> process object, since the object has no columnsProviderName='SQLOLEDB',
> Query="ABC.DEF"."dbo"."sysfiles"'].
>
> This query works on other databases on this instance and other
> instances.
>
> Does anybody have any ideas?
>
>
 
 
A





PostPosted: Wed Jan 11 03:27:03 CST 2006 Top

SQL Server >> Query database on linked server where database has name like [ABC.DEF] This is the only instance on the host. I can also query other databases
on this instance - they do not have "." in their name.