Devart Forums

Can someone tell me if this driver will work with SQL Server (2000 or 2005) when failover clustering is implemented on the database.

Microsoft documentation talks about cluster aware drivers but I don't know if that applies to dbExpress?

I have a user which has SQL Server 2000 with failover clustering and things seem to stop working when the failover switches databases. This could be a setup issue but I just need to know if there is anything about the driver which would prevent this from working or if any parameters are missing?

Hope that makes sense.

Thanks

To put it simpler.

Does the fact that dbexpsda.dll uses sqloledb.dll mean that it complies with the Microsoft Failover Clustering standards/requirements?

Or isn't dbExpress compatible?

Thanks

As far as I know, Failover Clustering is transparent for clients when connecting through a Virtual Server.
DbxSda supports setting the Failover Partner for Database Mirroring. There is the information about setting this option in the Readme.html file that is located in the DbxSda installation directory.

Thanks for that. I assume it must be a failover setup issue.

From what I can gather here is that the Microsoft drivers must be doing something which the Core Labs ones aren't. It's odd the Microsoft web site specifically mentions "cluster aware" drivers.

Our developing partner, who just uses purely Microsoft technology, doesn't have any problems when a failover switch is made. We, using the dbExpress driver, do though.

We seem to end up taking to an empty database. No errors are generated and subsequent queries just return no data?!

The "Failover Partner" you mention is for a different setup and as far as I'm aware isn't applicable here.

Is Core Labs stance here that it's just happy to have non cluster aware drivers? Whatever that means!

We will deeply investigate this issue in the nearest time.

Thanks for that