pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: bdealhoy@sympatico.ca
To: pgsql-admin@postgresql.org
Subject: POrtability of ODBC and DBArtisan connection information
Date: 10 Mar 2004 08:29:26 -0800
Message-ID: <b47d3acf.0403100829.70770bae@posting.google.com> (raw)

Here's the situation:

We're doing user administration on a pile (250+) DB2 databases, and
are using ODBC to provde the connection to these database (plus a
whole pile of ones from other database providers). The desktop is
Windows 2000 and we're running the client ODBC software for DB/2.

Right now, I've got two BIG problems.

The first is that the ODBC connections have to be created by hand. I'm
using MS ODBC Administrator to do this, and have already created an
alias list that's completely independent of the name of the database).
Yes, we have mulitple databases defined on multiple instances on
multiple servers, with duplicate database names galore. So, aliases
are going from "AAAAAAAA" to whatever I hit when I complete the list
of ALL DB2 databases.

The second is that we're using Embarcadero DBArtisan as the
administrative tool. This requires that the database connection be
registered within the application for it to be usable.

There is the requirement that the desktop environment (connection
information and DBArtisan registry list) be retained in a version
control environment, PLUS be loaded unto other administration
desktops.

So, I'm looking for two solutions:
How to automate the process of creating an ODBC connection and
registering it in DBArtisan.
How to export the data for the ODBC connection (Windows Registry is
easy, but where is the alias/server/port information retained)as well
as the DBArtisan registrations, and how to import them.

Any help, pointers, or better yet TOOLS, are greatly appreciated.

Better to reply directly if at all possible.

Thanks in advance!



view thread (2+ messages)  latest in thread

Message-ID: <b47d3acf.0403100829.70770bae@posting.google.com>
Permalink:  ../b47d3acf.0403100829.70770bae@posting.google.com/
Also on:    postgresql.org/message-id/b47d3acf.0403100829.70770bae@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bdealhoy@sympatico.ca
  Subject: Re: POrtability of ODBC and DBArtisan connection information
  In-Reply-To: <b47d3acf.0403100829.70770bae@posting.google.com>
  References: <b47d3acf.0403100829.70770bae@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox