ODBC resetting itself!?!

[chubtub]

Does anyone know why an ODBC connection would reset itself?

Recently I moved my database for a program that I had written to another computer. I redirected the ODBC to look at that computer and tested it. It ran this way very stable for a good 10 hours or so then decided that it was going to point itself back to the other computer with the old setting.

The odd thing is this has happened on two seperate computers at the same time, both pointing to the new one.

Any ideas welcome.

[BipolarBill]

You're not alone. I habe a travel agency client whose network connected database string gets lost regularly too.

I tell him what I'm about to tell you - copy the string to a text file and keep it handy.

:(

[chubtub]

Will have to do that. Looks like I am going to have to write a program that goes out and checks that ODBC connection to make sure it is aiming at the proper computer and has not been reset to the previous.

At first I thought it was a virus of some sort, but that would not make any sense considering that they would what to keep the known good connection for thier evil ways.

Of course I could not find anything at the microsoft site on this topic.

Thanks for the reply:)