Not coming from a VB development shop, we use strictly Delphi, I am not familiar with defing the connection like that. You can do it Delphi but there is no reason to. I have noticed however when our research department pulls data into Access.

This has never been a issue for us as we have several .udl files on our file server that the application reads it's connection info from at startup. This allows us to switch SQL Servers rapidly. If one server went down all I have to do is switch the connection properties in the .udl file and everyone is then using a backup server. This came in handy when we upgraded our server this spring.

Ross