Adding FoxPro to SQL Cluster?

Hi all,
I am the SQL DBA for an organization. We have an active/passive 2-node SQL 2000 cluster running on Windows 2003 Server. So far, it has been very stable (knock wood).
Somebody here wants to add FoxPro as a clustered application onto our (failover) clustered database server. My gut tells me no, partially because I'm not sure if you can cluster FoxPro, and what the implications of running a FoxPro cluster are. Also, I
have not been able to find any information on the Web about implementing, administrating or coding for a FoxPro cluster, while the same information on SQL Server clustering is abundent.
My questions are:
1. Has anyone out there implemented a clustered FoxPro server?
2. If so, have you implemented this on the same cluster as your production SQL Server cluster?
3. Does anyone have any recommendations for or against this type of setup?
4. Can anyone point me in the direction of information that would make the case one way or the other about this proposed implementation?
Thanks in advance!
Cheers,
-m
My first question would be:
Why do they want to do this?
Why would they want to use a FoxPro application in an environment that is
designed for high availablitly?
Theoritically any application can be clustered but logically it does not
make sense to cluster an application that by design is a desktop
application. It seems to be a waste of resources.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Someone within your organisation seems to be getting confused between server products and desktop products. Foxpro is a desktop product. Another way of looking at it is by replacing the word "FoxPro" with "Access", "Word", "Excel" etc and ask yourself t
he same questions again. Desktop applications are not cluster-aware. Some server products are. eg SQL Server 2000, Exchange 2000/2003. Attempting to make a desktop application cluster-aware seems to be a major step in the wrong direction. Your initia
l instincts were correct. Now you just need to point out the differences between cluster-aware applications and non-cluster-aware applications to your management.
If management want high availability with their database platform switch from FoxPro to SQL Server 2000 EE (on a MCS cluster). There is no such thing as a cheap highly available solution in the database space (well I've not seen one yet).