Is this possible? Connecting to a remote PCs DSN? 1

[BigTeeJay]

Greetings all,
I am trying to find the best method for connecting to a
remote ODBC data source.

I've been searching several of the forums & their FAQs
here (as well as on the web in general).

Here is the scenario. I have a File to which I have an
ODBC driver installed on a Server (its a FileMaker file).
I can setup a System DSN on the Server, and apps running
on the server can access it.

Now, I know I could probably setup some method of
distributing a DSN onto each client PC and point it to
the server, but this seems like it would require more work
and maintance.

Is there anyway to connect to another PCs DSN? For example,
instead of...
[tt]
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.ConnectionString = "DSN=ClientDB;TABLE=GRDTEST_CLIENT"
[/tt]

...doing something like (I know this wont actually
work, but I hope it illustrates the idea)...
[tt]
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.ConnectionString = "DSN=\\server\ClientDB;TABLE=GRDTEST_CLIENT"
[/tt]

Any thoughts/leads/hints/suggestions would be greatly
appreciated...

Regards,
Tj

 

[FancyPrairie]

Setup a File DSN rather than a System or User DSN. The File DSN can reside on a server that everyone has access to.

 

[BigTeeJay]

Such as wonderfully brilliant solution, it hadnt
even crossed my mind... thanks!