question

Qwazar avatar image
Qwazar asked

Error: 7302. MSSQL 2000

Hi all. Cannot create an instance of OLE DB provider "SQLNCLI" for linked server "SERVERNAME", Error: 7302 MS SQL 2000. Version SQL-server: 8.00.760 How to solve this problem?
sql-server-2000linked-server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Hi! What did you try before asking the question? FROM which version of SQL Server are you setting up the linked server connection? TO which version of SQL Server are you setting up the linked server connection? (I can see you saying SQL Server 2000, but it's not clear if that's the host or the linked server). The discussion in **[this][1]** Social MSDN forum thread suggests having a look at the SQL Server service account. Reinstalling the SQL Server Native Client is another suggestion I've seen. But that's just guessing. You really need to provide more details. [1]: http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/e64476a9-4182-4f89-98ca-f2e489d815b2
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Qwazar avatar image
Qwazar answered
I try to do linked server on Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3) to MS SQL 2000 - 8.00.760. By script: exec sp_addlinkedserver N'ip' exec sp_addlinkedsrvlogin 'ip', 'false', null, 'login', 'pass' exec sp_serveroption N'ip', N'collation compatible', N'false' exec sp_serveroption N'ip', N'data access', N'true' exec sp_serveroption N'ip', N'rpc out', N'true' exec sp_serveroption N'ip', N'rpc', N'true' exec sp_serveroption N'ip', N'use remote collation', N'false' exec sp_serveroption N'ip', N'collation name', N'null' exec sp_serveroption N'ip', N'connect timeout', 0 exec sp_serveroption N'ip', N'query timeout', 0
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.