Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL7 Clustering question

Author  Topic 

Jim_kimbolton
Starting Member

2 Posts

Posted - 2001-10-13 : 07:24:01
Hi,

I've developed an app with ASP/VB-COM/SQL7.
I'm trying to put more power to my sql server and in the process buying h/w to create cluster of SQL7.
I've written all stored procs instead of embeded sqls in my COMs. And I use ODBC-DSN to access db. No triggers/views.

1. Does anyone have an idea, whether my app will create any problem in creating clustering solution?
2. To which box should I point my DSN to? What if one box goes down? Do I need to manually change the DSN to the other or will there be some virtuall IP to which I'll point my DSN?

Thanks for any help.
Jimmy
   

- Advertisement -