Home All Groups Group Topic Archive Search About
Author
4 Aug 2006 10:11 PM
Lee
I tried to connect to a version 7 database with SMO to do a backup and got an
error indicating that it could not perform the operation becuase of the
version. I checked the documentation and version 7 should be supported. Is
this a an undocumented "feature"

Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to
connect to server 192.168.15.200. --->
Microsoft.SqlServer.Management.Common.ConnectionFailureException: This SQL
Server version (7.0) is not supported.
   at
Microsoft.SqlServer.Management.Common.ConnectionManager.CheckServerVersion(ServerVersion version)
   at
Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   at HWAutoDialer.modHWAutoDialer.BackupDatabase(String sFilePath, String
sDatabase, String sServer, String sUserid, String sPwd, Boolean fTrusted) in
C:\Clients\Csi\HWAutoDialer\modHWAutoDialer.vb:line 403

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Author
4 Aug 2006 10:40 PM
Erland Sommarskog
Lee (L**@discussions.microsoft.com) writes:
> I tried to connect to a version 7 database with SMO to do a backup and
> got an error indicating that it could not perform the operation becuase
> of the version. I checked the documentation and version 7 should be
> supported. Is this a an undocumented "feature"

I'm afraid that the documentation is wrong. Apparently support for SQL7
was planned, but it was never completed.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
4 Aug 2006 10:53 PM
Lee
AAAAAHHHHHHHHH !!!!!!!!, The reason I went to SMO from DMO was the support
for V7 AND I cannot get DMO to install on certain machines. I have env tried
the distrib package staight off the CD with no avail. So now I am stuck.
Can't get DMO to install when a version 7 MSDE is on a machine, and can't use
SMO. Thanks Microsoft Very Much! I guess my monetary loss is your gain DAMN
IT.....

AddThis Social Bookmark Button