Re: SQL Server 7 to 2000 Connection

From: Neil Pike (neilpike_at_compuserve.com)
Date: 03/09/04 

Date: Tue, 09 Mar 2004 11:38:44 GMT

 Correct, you're wasting your time. But the reverse is fine - i.e. a SQL 2000
EM coinnecting to a SQL 7 Server
 
> We're trying to connect FROM a local SQL Server 7 database
> TO a remote SQL Server 2000 database using the
> Registration Wizard in Enterprise Manager.
>
> Are we wasting our time or is this possible?
>
> Hey, thanks very much for any input.
>
> Best regards,
> Randy
>

 Neil Pike MVP/MCSE. Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

Relevant Pages

  • Re: 1000 records FlatFile takes over 5 minutes before being publis
    ... I need to debatch 1 file of 1000 records into 1000 seperate records. ... I am still seeing the spool size increasing step by ... We use 1 BizTalk application server with 1 remote SQL server when doing our ...
    (microsoft.public.biztalk.general)
  • SQL select and datetime to date
    ... Is there a way to create a sql select (remote sql server) statement that ... brings down a datetime field as a FoxPro date field. ... I tried the CAST function: ...
    (microsoft.public.fox.helpwanted)
  • Re: Spin/ spout BCDL to sql server Swap (how do i stop sharepoint using BCDL?)
    ... Spin/Spout just copies the documents and meta info into SQL. ... If it is confusing to your users I would remove the BCDL if you are no ... > remote sql server database. ... > reference the remote sql server correctly. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Failed to start monitoring changes
    ... I connect to a remote SQL Server using SQL authentication, regarding permissions its the owner of the database. ... >> Praveena. ...
    (microsoft.public.dotnet.security)
  • Re: ReportIoError 2 - any ideas?
    ... job - then modify the schedule as required. ... using DBCC SHRINKFILE to reduce the ldf file size. ... Rerunning the backups through Enterprise Manager. ... My colleagues know even less about SQL Server ...
    (microsoft.public.sqlserver.server)