|
Home > Archive > SQL Server JDBC > February 2006 > Connect client to server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connect client to server
|
|
| bakedmike via SQLMonster.com 2006-02-15, 8:23 pm |
| 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 spreadsheet 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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...tivity/200602/1
| |
| bakedmike via SQLMonster.com 2006-02-20, 8:23 pm |
| 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 spreadsheet 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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...tivity/200602/1
| |
| Joe Weinstein 2006-02-20, 8:23 pm |
| Hi. It just doesn't have anything to do with SQLServer or JDBC...
bakedmike via webservertalk.com wrote:
> Did I not do a good job of explaining what I need or is this beyond the forum
> expertise?
>
> bakedmike wrote:
>
>
>
>
>
|
|
|
|
|