View Single Post
  #2  
Old 10-21-2016, 07:51 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,335
Default

Did you change the content of the .udl?
Since that is holding your real connection settings.

Try rebuilding your .udl

Other thing that I can think of is permissions on the .udl. Perhaps it's locked exclusively somewhere. Rebuilding it would also solve this issue (in the short run). If that's the case you still should figure out what is locking it (perhaps some test code, it's open in an editor, or whatever you could think of)

Is all this still not working try giving the connectionstring directly in the AdoQuery.ConnectionString (database, user, and so on that is now configured in your udl). Check if that's working properly, perhaps there's something wrong there (db changed permissions on user or whatever).