64 bit linked server

I am trying to set up a linked server on a 64 bit Itanium SQL Server 2000
server to access a 32 bit SQL Server 2000 server. When I run a query in
query analyzer accessing the linked server I get the error:
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: ].
If I run a trace on the 32 bit server I see the error:
Error: 2812, Severity: 16, State: 62
Also, the trace on the 32 bit server shows a system stored procedure that
isn't on the 32 bit machine. It is
exec [Database1]..sp_tables_info_rowset_64 N'SERVICE', N'dbo', NULL
Is there a way to link from a 64 bit server to a 32 bit server?That sounds like a bug in IA64 version of sql2k. I suggest you contact PSS
for this.
Meanwhile, have you tried to create a linked server to sql2k x86 using
MSDASQL provider.
--
-oj
"billd101" <billd101@.newsgroup.nospam> wrote in message
news:uF4GrzGnGHA.4604@.TK2MSFTNGP02.phx.gbl...
>I am trying to set up a linked server on a 64 bit Itanium SQL Server 2000
>server to access a 32 bit SQL Server 2000 server. When I run a query in
>query analyzer accessing the linked server I get the error:
> 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: ].
>
> If I run a trace on the 32 bit server I see the error:
> Error: 2812, Severity: 16, State: 62
> Also, the trace on the 32 bit server shows a system stored procedure that
> isn't on the 32 bit machine. It is
> exec [Database1]..sp_tables_info_rowset_64 N'SERVICE', N'dbo', NULL
>
> Is there a way to link from a 64 bit server to a 32 bit server?
>|||Hi,
Thanks for your reply.
From your description, I understand that:
You had two SQL Server 2000, one is 64 bit, the other is 32 bit. And you
tried to link the two servers,
however you got that error.
If I have misunderstood, please let me know.
From my research, this issue is mostly caused by the system stored
procedures were not upgraded to SQL Server 2000 SP3 or SQL Server 2000 SP4.
I recommend you manually run the Instcat.sql script that is included with
SQL Server 2000 SP3 or SP4 on the 32-bit SQL Server 2000 server.
Use Windows Authentication mode
To use Windows Authentication mode to upgrade the system stored procedures
on a 32-bit instance of SQL Server 2000, follow these steps: 1. Log on to
the computer by using a Windows account that is a member of the SQL Server
sysadmin fixed server role.
2. Click Run, type cmd.exe, and then click OK.
3. At the command prompt, type one of the following commands, and then
press ENTER:
For a default instance:
osql -E -S <LinkedServerName> -i <Location>\instcat.sql
For a named instance:
osql -E -S <LinkedServerName>\<InstanceName> -i <Location>\instcat.sql
Note <LinkedServerName>, <InstanceName>, and <Location> represent the
linked server name, the instance name, and the full path of the folder that
contains the Instcat.sql script. By default, this folder is C:\Program
Files\Microsoft SQL Server\MSSQL\Install.
Use SQL Server Authentication mode
To use SQL Server Authentication mode to upgrade the system stored
procedures on a 32-bit instance of SQL Server 2000, follow these steps: 1.
Log on to the computer by using any Windows account.
2. Click Run, type cmd.exe, and then click OK.
3. At the command prompt, type the following command, and then press ENTER:
For a default instance:
osql -U <AdminLogin> -P <AdminPassword> -S <LinkedServerName> -i
<Location>\instcat.sql
For a named instance:
osql -U <AdminLogin> -P <AdminPassword> -S
<LinkedServerName>\<InstanceName> -i <Location>\instcat.sql
Note <AdminLogin> and <AdminPassword> represent the user account that is a
member of the SQL Server sysadmin fixed server role.
Note After you run the Instcat.sql script, many messages are generated. The
last message indicates whether the script ran successfully.
You may refer to:
http://support.microsoft.com/?id=906954
This KB article is for the client SQL 2005 64bit, it also applies to the
issue you encountered, because the servers are both SQL 2000.
If this issue persists, I appreciate you send me the SQL error logs and
dump files for further research.
My email is changliw@.microsoft.com.
If you have any other concerns, please feel free to let me know. It's my
pleasure to be of assistance.
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Running instcat solved the problem. Thanks for your help.
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:8x$0MPnnGHA.4612@.TK2MSFTNGXA01.phx.gbl...
> Hi,
> Thanks for your reply.
> From your description, I understand that:
> You had two SQL Server 2000, one is 64 bit, the other is 32 bit. And you
> tried to link the two servers,
> however you got that error.
> If I have misunderstood, please let me know.
> From my research, this issue is mostly caused by the system stored
> procedures were not upgraded to SQL Server 2000 SP3 or SQL Server 2000
> SP4.
> I recommend you manually run the Instcat.sql script that is included with
> SQL Server 2000 SP3 or SP4 on the 32-bit SQL Server 2000 server.
> Use Windows Authentication mode
> To use Windows Authentication mode to upgrade the system stored procedures
> on a 32-bit instance of SQL Server 2000, follow these steps: 1. Log on to
> the computer by using a Windows account that is a member of the SQL Server
> sysadmin fixed server role.
> 2. Click Run, type cmd.exe, and then click OK.
> 3. At the command prompt, type one of the following commands, and then
> press ENTER:
> For a default instance:
> osql -E -S <LinkedServerName> -i <Location>\instcat.sql
> For a named instance:
> osql -E -S <LinkedServerName>\<InstanceName> -i <Location>\instcat.sql
> Note <LinkedServerName>, <InstanceName>, and <Location> represent the
> linked server name, the instance name, and the full path of the folder
> that
> contains the Instcat.sql script. By default, this folder is C:\Program
> Files\Microsoft SQL Server\MSSQL\Install.
> Use SQL Server Authentication mode
> To use SQL Server Authentication mode to upgrade the system stored
> procedures on a 32-bit instance of SQL Server 2000, follow these steps: 1.
> Log on to the computer by using any Windows account.
> 2. Click Run, type cmd.exe, and then click OK.
> 3. At the command prompt, type the following command, and then press
> ENTER:
> For a default instance:
> osql -U <AdminLogin> -P <AdminPassword> -S <LinkedServerName> -i
> <Location>\instcat.sql
> For a named instance:
> osql -U <AdminLogin> -P <AdminPassword> -S
> <LinkedServerName>\<InstanceName> -i <Location>\instcat.sql
> Note <AdminLogin> and <AdminPassword> represent the user account that is a
> member of the SQL Server sysadmin fixed server role.
> Note After you run the Instcat.sql script, many messages are generated.
> The
> last message indicates whether the script ran successfully.
> You may refer to:
> http://support.microsoft.com/?id=906954
> This KB article is for the client SQL 2005 64bit, it also applies to the
> issue you encountered, because the servers are both SQL 2000.
> If this issue persists, I appreciate you send me the SQL error logs and
> dump files for further research.
> My email is changliw@.microsoft.com.
> If you have any other concerns, please feel free to let me know. It's my
> pleasure to be of assistance.
> +++++++++++++++++++++++++++
> Charles Wang
> Microsoft Online Partner Support
> +++++++++++++++++++++++++++
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi ,
Appreciate your update and response. I am glad to hear that the problem has
been fixed.
If you have any other questions or concerns, please do not hesitate to
contact us.
It is always our pleasure to be of assistance.
Have a nice day!
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Just out of curiosity, what does upgrading the system stored procedures do
exactly? I'm wondering how it will affect any existing systems on the 32bit
server.