UDB 7.2, LDAP and ODBC Data Sources on Client

Frederick Page

Hi everybody,

we are using DB2 UDB 7.2 FP 11 on WinNT 4.0 (SP5) machines, LDAP works quite
fine. As I already googled, there is however the question on how to apply
e.g. "db2 catalog system odbc data source <name>" on the client-machines.

One can roll out an initial config, no problem. But how do you guys out
there manage deleted or new databases on your clients? I read one post
about "self-repairing MSI packages" but unfortunately, the author did not
elaborate further.

Would I have to use e.g. a WSH-script (check if all DBs in LDAP are
catalogued as ODBC datas ources on client)?

TIA Frederick

Nov 12 '05 #1

Subscribe Reply

2616

Mark Yudkin

I would strongly recommend your creating an MSI-based installation program
("self-repairing MSI packages"). Review the documentation on installer
technologies on the MS web site
(http://msdn.microsoft.com/library/de...-us/dnanchor/h
tml/setup.asp). Purchase an installation development application (such as
InstallShield or WISE) to simplify development thereof. Both of these have
sophisticated ODBC management function, as well as a host of other function
that make development of install / uninstall / update / repair programs
easy.

Using a WSH script would probably work, but I wouldn't go that way.

"Frederick Page" <fo************ ****@gmx.de> wrote in message
news:7e******** *************** ***@posting.goo gle.com...

Hi everybody,

we are using DB2 UDB 7.2 FP 11 on WinNT 4.0 (SP5) machines, LDAP works quite fine. As I already googled, there is however the question on how to apply
e.g. "db2 catalog system odbc data source <name>" on the client-machines.

One can roll out an initial config, no problem. But how do you guys out
there manage deleted or new databases on your clients? I read one post
about "self-repairing MSI packages" but unfortunately, the author did not
elaborate further.

Would I have to use e.g. a WSH-script (check if all DBs in LDAP are
catalogued as ODBC datas ources on client)?

TIA Frederick

Nov 12 '05 #2

Similar topics

6901

Automating installation of ODBC data source

by: SkunkDave | last post by:

Is there a script anyone has that will automate the addition of an access database to the OBDC datasources in control panel. Thanks

Microsoft SQL Server

3516

EM DTS Designer ODBC source as a file DSN doesn't work!

by: kakaz | last post by:

Hi All there! I am quite new in MS SQL administration so let me explain how it work on Your instances of SQL Servers. We have several DTS packages on our server, all of them managed on some station which have seriously hardvare problem. So we wolud like to catch two problems at one time and decided to develop systematic way of DTS manipulation. One of several aspects of this operation would be migration from system ODBC data sources...

Microsoft SQL Server

3488

ODBC question

by: Philip Wright | last post by:

I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8 on a Windows XP Pro machine. I have the Software Development Client installed on the XP machine and have run the Client Configuration Assistant and registered the SAMPLE and my TEST databases with the ODBC Administrator as System DSN data sources. Everything seems fine, but when I try to connect to "External Tables" through 123 my DB2 databases are not listed under available...

DB2 Database

10813

ODBC Connection

by: Jacob Pallapati | last post by:

Hi, I need to create an ODBC connection for one of my databases from the command line. I could use db2 catalog system odbc database source <my-database>. But I want to create a DSN with a name different from the name of the database. For instance if my database name is SAMPLE i want to create a dsn with name sample_database. Please let me know if there is a way to do this from the command line. As far as I can see db2 catalog command...

DB2 Database

6187

ODBC on new installs

by: Lauren Quantrell | last post by:

Maybe a dumb question - I'm new to ODBC. How do I install an Access ..mde file on a user's workstation and create the ODBC connection to the backend SQL Server database without having to go through the Administrative Tools>Data SOurces (ODBC) menu? IS there a way to do this with VBA code from my installer disk, or by simply copying a file onto the user's PC? Any help is appreciated. LQ

Microsoft Access / VBA

40407

ODBC connection failed

by: Alec | last post by:

Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network lacation on a different machine, it tells me that the ODBC connection to 'SQL Server Name' failed. How can I create the linked table permenant no matter what machine the networked database is opened on?

Microsoft Access / VBA

2566

Problems with ODBC access since XP SP2 upgrade

by: Randall Perry | last post by:

I've got an app written with Access XP that was deployed 2 years ago using a PostgreSQL backend database through an internet connection. Recently a client upgraded to XP Service Pack 2. After the upgrade she was unable to connect to the remote database, getting the error: Unable to connect to remote database File Name=C:\Program Files\Common Files\ODBC\Data Sources\PostgresCNI.dsn Error message: The file is not a valid compound file.

Microsoft Access / VBA

5714

use ODBC to import filemaker file

by: polpe | last post by:

Hello, i have a filemaker server 5.5 with some shared files. I don't understand how use ODBC with these files to import a database in Access. Can anyone help me? Polpe from Italy

Microsoft Access / VBA

3707

ODBC connection to V7 and V8 databases simultaneously

by: byrocat | last post by:

Up until now, I've been working with V& DB2 UDB databases, using Embarcadero DBArtisan as my GUI tool. I also have other tools that I use in my day-to-day job so running directly on the server via the CLP is not a viable option. I've just had a number of V8 DB2 UDB databases added to my task list. Of course #1, the old V7 DB2 ODBC client software doesn't connect to V7 databases.

DB2 Database

9621

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9454

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10267

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10040

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6717

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5355

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5484

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4012

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2852

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General