Re: DSN's do not display in ODBC Data Source Administrator

From: Ashok Rautela (arautela_at_openlinksw.co.uk)
Date: 03/02/04 

Date: 2 Mar 2004 03:12:49 -0800

Hi Bruce,

Just wanted to ask if you have already installed the ODBC drivers for
all the other databases i.e. Sybase, SQL Server, Informix and Oracle?

Regards,

Ashok Rautela

"Byrocat" <strikemaster2000@yahoo.ca> wrote in message news:<CM50c.68204$ee3.635958@news20.bellglobal.com>...
> 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

  • Re: DSNs do not display in ODBC Data Source Administrator
    ... all the other databases i.e. Sybase, SQL Server, Informix and Oracle? ... > the ODBC Data Source Administration application. ... would shortening the name of the ODBC server have any ...
    (microsoft.public.sqlserver.odbc)
  • RE: ODBC-Server Middleware
    ... We have the need to use ODBC. ... see only those datasources which were configured on the server. ... animal with the combination of Sequelink and Informix though the conception ... The ODBC driver usually is used by the application. ...
    (comp.databases.informix)
  • Re: Ok, call me silly...
    ... Server and not into Informix. ... Let's see the SQL Server document... ... A full chapter dedicated to features used for Oracle compatibility... ... I could post here some more new compatibility features introduced in Cheetah. ...
    (comp.databases.informix)
  • Re: MS OLE DB for ODBC with Oracle ODBC source headaches
    ... > I am having trouble getting linked Oracle 9 server in MS SQL Server ... > ODBC Provider and an Oracle ODBC source. ... > for Oracle Driver in my ODBC source I have inconsistent behavior. ...
    (comp.databases.ms-sqlserver)
  • Re: Problem connecting to Informix from Sql Server
    ... What version of the Informix CSDK or Connect are you using? ... that you are using an old one based on the version of your ODBC driver. ... My first guess is that the Informix client that you are using is not ... the latest and thus does not work properly on Windows 2003 Server. ...
    (comp.databases.informix)
Loading