pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
POrtability of ODBC and DBArtisan connection information
2+ messages / 2 participants
[nested] [flat]

* POrtability of ODBC and DBArtisan connection information
@ 2004-03-10 16:29 Byrocat <bdealhoy@sympatico.ca>
  0 siblings, 0 replies; 2+ messages in thread

From: bdealhoy@sympatico.ca @ 2004-03-10 16:29 UTC (permalink / raw)
  To: pgsql-admin

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!



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: POrtability of ODBC and DBArtisan connection information
@ 2004-03-15 21:42 Campano, Troy <Troy.Campano@LibertyMutual.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Campano, Troy @ 2004-03-15 21:42 UTC (permalink / raw)
  To: pgsql-admin

Isn't this a DB2 question and not a PostgreSQL question?
How does this relate to PostgreSQL? I'm lost.


Thanks!


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Byrocat
Sent: Wednesday, March 10, 2004 11:29 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] POrtability of ODBC and DBArtisan connection
information

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!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-03-15 21:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-10 16:29 POrtability of ODBC and DBArtisan connection information Byrocat <bdealhoy@sympatico.ca>
2004-03-15 21:42 Re: POrtability of ODBC and DBArtisan connection information Campano, Troy <Troy.Campano@LibertyMutual.com>

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