ADO Connection String Error for Mirrored Database

I am trying to connect to a failover partner using ADO (non .Net) and Visual C++. ADO is throwing the following exception:

Caught: Unspecified error - Invalid connection string attribute(Microsoft OLE DB Provider for SQL Server)

Connection String:
Provider=SQLOLEDB.1;Data Source=Edwardsville\SQLSERVER;Failover Partner=Mirror2\SQLSERVER;Initial Catalog=SomeCatalog;User Id=SomeId;Password=SomePassword

Any ideas?

As far as I know this is only supported in ADO.NET 2.0.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Hi, Im trying to do the same thing.

Could you get any answer to this? Its possible with ADODB ?

Thanks