× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 6/3/2013 4:28 PM, Crystal Reports wrote:
Where do we load this?

Question
You may receive an "IBMDADB2 is not registered"
error message when attempting to run an ASP.NET application with DB2®
and the IBM® OLE DB provider (IBMDADB2). Using the same provider with a
stand-alone Windows® application works, however.
Cause
You need to ensure that the IBMDADB2 provider is
registered with the operating system, and that the proper permissions
are met for the ASP.NET and IUSR_### accounts on the system.
Answer
The IBM OLE DB Provider should be registered
during installation of the DB2 Universal Database™ (DB2 UDB) product. If you receive this error, however, here are the steps to take to ensure
the driver is registered:

1. At a command prompt, type the following:
regsvr32.exe /c "C:\Program Files\IBM\SQLLIB\BIN\ibmdadb2.dll"
(where <C:\Program Files\IBM\SQLLIB\BIN\> is the location of the ibmdadb2.dll on your system)
2. Once this is complete, you will also need to ensure that both the ASP.NET and IUSR_### user accounts on the system have READ, WRITE,
EXECUTE, and LIST FOLDER CONTENTS privileges on the C:\Program
Files\IBM\SQLLIB directory in the machine on which you are running your
ASP.NET application. To do that, open your Windows Explorer, and drill down to your SQLLIB directory. Then right-click and choose
"Properties". Here you can then click on the "Security" tab and modify
the privileges as needed. If Extended Windows Security is enabled, this
can also be achieved by adding the user to the DB2ADMNS or DB2USERS
group.
3. It is recommended that once the proper privileges are set, that
you recycle your ASP.NET application server, so the new changes take
effect.

The quoted question and answer relates to IBM DB2 LUW (Linux, Unix,
Windows).
The DB2 that runs on IBM i is called IBM DB2 for i.

Having said that, you will need a driver on every PC that wants to
access the DB2 for i database. If you have a dozen Crystal clients, and
they each want to read from DB2 for i, then you need to load the driver
on each machine. If you're using Crystal Server, then you only need to
load it on the Crystal Server machine because the 'clients' get their
information via a web server and the Crystal Server machine gets it from
DB2 for i.

You need to find the same OLE driver you installed on your machine to do
the testing and install that on the clients, using the instructions that
go with DB2 for i, not DB2 UDB.
--buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.