A wild guess, perhaps a default connection setting is conflicting like ANSI NULLS DEFAULT ON/OFF. Default collation (see the database model)

What is the patch level of sql server 2000? Sp3a...

just to make sure you have everything right on firewall settings http://support.microsoft.com/kb/839279

What is your current connectionstring? Does it use a name or an ip-address?

*outdated post

At work we currently differ the password the application uses to connect to the various servers. (sql authentication at the moment)

dev: login applicationX password applicationTesting

QA: login applicationX password applicationQA

Prod: ...

So...

Can you trace how far the program goes along with sql server using the sql profiler? What was it last statement ?

Have you changed the language of sql server or the default language...

Needs some testing (restoring the backup), a good network connection. (the smallest thing could make the backup corrupt making it a high risk operation)

A mapped (X

if you want to increase the chance that sql server uses an index; only select the necessary fields instead of select *.

Does the sql server account have permissions to write on the share?

Autostart MSDTC is enabled on both sql servers?

Unsure about this but there could be a problem when msdtc is started after sql server.

Same servicepacks.. SP1,SP2,SP3,SP3a,SP4...?

Nt servicepack SP6, SP6a?

Any firewall in...

There seem to be some indendations (whitespace?), is the column defined as char?

What is the patch level of the ado component (mdac 2.8?)

for step 3, have you also tried sqlplus to connect to the database from your cluster?

I have no experience for clusters but it could be required that both hosts have to...

Happy to help 🙂

The main relinking happens in fcRefreshlinks.

strNewConnect = the new link/connection to your tables.

findConnect(strDatabase, tdf.Name, strOldConnect)

is a function to get the updated connection.

see http://www.connectionstrings.com/ for possible connection strings

You could...

NT-machines... hmm... which servicepack and which sql server version?

Do the tables have a primary key?

Both servers have MSDTC service running?

Have you rebooted the machines?

=0 is false

<>0 is true

Is one of the servers OS windows 2003?

http://support.microsoft.com/default.aspx/kb/839279?