Re: Connect client to server

Hi. It just doesn't have anything to do with SQLServer or JDBC...

bakedmike via SQLMonster.com wrote:

Did I not do a good job of explaining what I need or is this beyond the forum
expertise?

bakedmike wrote:

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.



.

Loading