Mirroring with SQL Server 2000 Driver

Question

Mirroring with SQL Server 2000 Driver

sqlfriend

Mr or Mrs. 500

Points: 542
More actions
March 30, 2009 at 8:18 am

#132311

Hello all,
is it possible to add the failover connection information to the connection string of the SQL Server 2000 (!) driver? If so, how?
The 2005 native client driver cannot be used for compatibility reasons with one of the applications connecting to sql server.
Thanks!
J.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mohit K. Gupta SSChampion Points: 12130 More actions · Answer 1

Database mirroring doesn't care about compatibility mode; you should be able to use the SQL Native Client to connect to database running in 2000 compatibility mode.

For example:

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

These connection strings are using SQL Native Client 9.0 OLE DB provider. What programing application are you using?

Thanks.

Mohit.

[font="Arial"]---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

How to ask for help .. Read Best Practices here[/url].

sqlfriend Mr or Mrs. 500 Points: 542 More actions · Answer 2

Hello Mohit,

thank you.

I'm not quite sure what you mean (I'm probably too new to the topic): I was looking for an option to use V.2000 of the SQL server driver the same way as the V2005 of the SQL server native client (where you can enter principal+mirror when defining the ODBC connection). If it is those strings that I should use in the V2000 version of the client: Where exactly should I enter them?

What do you mean with programming application?

Regards,

J.

Mohit K. Gupta SSChampion Points: 12130 More actions · Answer 3

sqlfriend (3/31/2009)
Hello Mohit,
thank you.
I'm not quite sure what you mean (I'm probably too new to the topic): I was looking for an option to use V.2000 of the SQL server driver the same way as the V2005 of the SQL server native client (where you can enter principal+mirror when defining the ODBC connection). If it is those strings that I should use in the V2000 version of the client: Where exactly should I enter them?
What do you mean with programming application?
Regards,
J.

The SQL 2000 ODBC drives can't be used for Failover funcaionality because they don't know anything about FAILOVER partner setting. What i meant by programming application was what programming langauge you are using?

If you have to use SQL 2000 ODBC drivers then what you'll have to do is have two connection strings; and if your application fails to connect to the first one it re-driects to second login.