ADO connection with a SQL cluster

Hi everyone,

I am new in the MS SQL server world in cluster. I am in the process of
implementing a cluster of SQL server 2000.

Some of the IT people in my company asked me if an ADO connection will see
the virtual server name as a normal SQL server?
I believe so but my lack of experience in SQL clustered and also the lack of
info on this subject drove me to ask everyone on newsgroups.
Would anyone have some info, web sites... on this matter?
thanks in advanceYes. ADO will see a virtual name like any other names. The beauty of having
a virtual name is that you do not need to know the physical/active instance
name in order to get to the data.

For info on connectionstring, etc...
http://able-consulting.com/ADO_Conn.htm

For info on clustering...
http://www.microsoft.com/ntserver/s...stering_faq.asp
http://support.microsoft.com/defaul...kb;EN-US;254321
http://support.microsoft.com/defaul...;259267&sd=tech

--
-oj
http://www.rac4sql.net

"Wilfrid Ertaud" <grille11@.yahoo.com> wrote in message
news:bujtjm$osf$1@.reader1.imaginet.fr...
> Hi everyone,
> I am new in the MS SQL server world in cluster. I am in the process of
> implementing a cluster of SQL server 2000.
> Some of the IT people in my company asked me if an ADO connection will see
> the virtual server name as a normal SQL server?
> I believe so but my lack of experience in SQL clustered and also the lack
of
> info on this subject drove me to ask everyone on newsgroups.
> Would anyone have some info, web sites... on this matter?
> thanks in advance