DSN's do not display in ODBC Data Source Administrator

From: Byrocat (strikemaster2000_at_yahoo.ca)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 14:00:41 -0500

I'm currently having to create a raft of DB2 connections in a
reasonable hurry. In addition, this list has to be propogated to three
other workstations (ultimate goal is to have DBArtisan access the
servers, instances and databases in an identical manner without having
to spend days doing this manually.)

I've figured out that the registry keys
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
and
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
allow me to specify the System DSN's so that they can be picked up by
the ODBC Data Source Administration application.

Unfortuantely, I think that there's a hidden limit in how much data
the tool can handle. Somewhere around 155 of the 219 DSN's, one row
gets chopped.

Instead of a line that reads
server.instance.database IBM DB2 ODBC DRIVER
I get variants such as the latest:
server.insta <rest of line is blank>

Looks like a classic buffer reaches max-size, burp and do nothing but
continue running.

BTW, this is only the tip of the iceberg, not only are there going to
be 200+ DB2 databases, but we're also looking at Sybase, MS SQLServer,
Informix, and Oracle, plus a few other antique clangers and
boat-anchors.

A follow-up question, would shortening the name of the ODBC server have any
impact? (eg, just DB2)

Thanks in advance...
Bruce

Relevant Pages

  • DSNs do not display in ODBC Data Source Administrator
    ... HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources ... the ODBC Data Source Administration application. ... server.instance.database IBM DB2 ODBC DRIVER ... be 200+ DB2 databases, but we're also looking at Sybase, MS SQLServer, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Simple query executes fast but renders slow...
    ... So, ODBC, right? ... no database engine can perform ... I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • RE: Data Transfer b/w SQL Server 2005 and DB2 UDB.
    ... Your IBM guy may like the ODBC method because it's easy for him, ... install the Microsoft OLE DB for DB2 Provider (you will need ... colleagues, a DB2 DBA, has helped me in setting up the ODBC DSN for DB2 and I ...
    (microsoft.public.sqlserver.dts)
  • Re: Simple query executes fast but renders slow...
    ... Then I wrote queries and reports based on the local versions. ... So, ODBC, right? ... > I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: sp_addlinkedserver for DB2
    ... If you have HIS, you can get the required ODBC ... drivers from the administration client .For DB2, ... Configuring Data Sources for the Microsoft OLE DB Provider for AS/400 ... Configuring Data Sources for the Microsoft OLE DB Provider for DB2' ...
    (microsoft.public.sqlserver.programming)
Loading