Connect client to server

I need a way to pass a connect string to a client. As of now, I hold the
connection information in an Access database that the client finds through a
mapped drive that is set in the applications ini file. The cleint selects
what server/database they want to connect to from a list that is generated
from the Access database and then the client connects to that SQL
server/database. Works great, except the Access database becomes corrupt
frequently, which I attribute to it running in a networked environment.

I have thought of placing the connect string in a text file or the ini file,
but this doesn't address when there is multiple server they could connect to
and it can't be plain text, must be protected some how and be able to build a
list. I have thought of using a Excel spread*** in place of the Access
database, but thought I would throw it out here to see if there is a better
way.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-connectivity/200602/1
.

Loading