64 Bit SQL Server four part name Problem

James Boyer — Thu, 11 Dec 2003 12:54:20 GMT

I have a fresh install of the 64 Bit SQL server 2000 and I get a strange error when I run a qry against a linked server.

For example the following qry
select
top 10
*
from
nibbler.seveneleven.dbo.pip_composed_of_bom

Returns

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete this operation could not be found on the server (they were supplied with the ODBC setup disk for the SQL Server driver). Please contact your system administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ].

I have already tried running the instcat.sql script and everything works but I get the following warning/error.

creating sp_ddopen
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_ddopen'. The stored procedure will still be created.
creating sp_tableswc

creating spt_provider_types

I am at a complete loss here. By the way the openqry function does work but in this case I can't use it because of speed/network issues.

Re: 64 Bit SQL Server four part name Problem

Ganesh Babu — Thu, 11 Dec 2003 15:23:52 GMT

select
top 10
*
from
nibbler.seveneleven.dbo.pip_composed_of_bom

in this query,

is nibbler the linked server name?
seveneleven is the db name?
dbo the owner name ?
& pip_composed_of_bom the table name??

Ganesh

Re: 64 Bit SQL Server four part name Problem

James Boyer — Thu, 11 Dec 2003 15:28:30 GMT

is nibbler the linked server name? Yes
seveneleven is the db name? Yes
dbo the owner name ? Yes
& pip_composed_of_bom the table name?? Yes

Jim.

Note it does not matter what linked server I use I get the same error.

Re: 64 Bit SQL Server four part name Problem

Ganesh Babu — Thu, 11 Dec 2003 15:32:11 GMT

do u have sp3 (service pack 3) installed for the SQL2k??

Ganesh

Re: 64 Bit SQL Server four part name Problem

James Boyer — Thu, 11 Dec 2003 15:33:25 GMT

As far as I can tell the 64 Bit version does not have any service packs yet.

topic Re: 64 Bit SQL Server four part name Problem in Operating System - Microsoft

64 Bit SQL Server four part name Problem

Re: 64 Bit SQL Server four part name Problem

Re: 64 Bit SQL Server four part name Problem

Re: 64 Bit SQL Server four part name Problem

Re: 64 Bit SQL Server four part name Problem