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

 

[RiverGuy]

That would probably work, but I'm sure you could just make a file DSN and save it in a DSN's folder on your network where you would have all your file DSN, not System or User DSNs.

 

[BigTeeJay]

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

 

[RiverGuy]

Just beware that I have had trouble using File DSN's in the past. In fact, I have NEVER got one to work in Access to link tables. I have got them to work in SQL Server for importing....and if I remember right, I did have trouble in VB to make a connection. But there has to be a way to get it working correctly.