Re: Creating ODBC sources for many remote PC's

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

Mike--

With OpsNav you can centrally create and store system data sources on the
AS/400. From OpsNav, a right click on the data source name "registers" that
ODBC data source with the client PC.

While this is a potential answer to your question, it has two downsides:
1. Doesn't work with file data sources (which are what MS Query insists on)
2. Requires OpsNav on any desktop that wants to use the data source--not
really to use the data source, but to register it. (Having said that, bet
you could make a REG file to distribute and use to squirt the necessary
registry entries to the client with, as long as REGEDIT were on the
desktop--geeze, the conditional crap involved reminds me why I hate ODBC so
much!).

Also, I bet you could park centrally located file DSN's on a mapped drive
(using NetServer, for example).

rp


----- Original Message -----
From: <mcrump@ballfoster.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, July 07, 1999 8:38 AM
Subject: Creating ODBC sources for many remote PC's


>
>
> We are trying to find ways to simplify ODBC administration and support.
We
> have 20 remote locations with numerous PC's that we need
>
> to define new ODBC sources for.  Is there any way we can distribute this
data
> with minimal remote location intervention?
>
> I was thinking in terms of a silent install, control file copy, file DSN,
etc.
> I've poured through the documentation and have had little luck in finding
> anything that remotely resembles what I want to do.
>
> Currently, we are V4R2 and V3R1M3.
>
> Thanks
>
> Mike
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---