Delphi

Question:
I receive a "Cannot load Idapi service library" error.
How do I resolve this?


Answer:
This general IDAPI startup error can occur for a number of
reasons. In the context of a multi-tier application, you
should be sure that STDVCL32.DLL and DBCLIENT.DLL are
registered on the server. Also, make sure that you have
IDPROV32.DLL in the BDE directory.

Question:
What other software do I need to access Microsoft Access
databases and tables

Answer:
You must have Microsoft's DAO version 3.0 drivers installed. The
Access driver does not support DAO 3.5 (Access 97). If you
upgrade Access 95 to Access 97, DAO 3.0 still resides on your
machine, so the driver will function correctly. If you install
Access 97 with no prior version of Access 95, the driver will
not function.

Question:
"Could not find IDataBroker in type library" error. How do I
resolve this error?

Answer:
Stdvcl32.dll may have gotten deleted from your Window's system
directory. If you need to, copy it from your CD and register it
using TRegSvr.exe (found in the Delphi bin directory).

Question:
I get an External Exception error in Delphi when connecting to
Sybase server when in Delphi's IDE or Turbo Debugger with NT4
running the 10.0.4 Sybase client. If I run the application
alone, it executes correctly. How do I get around the problem?

Answer:
In NT4.0 anything that is being debugged with any debugger will
cause the OS to report exceptions that would otherwise be

ignored. "External Exception C0000008" one of those types of
errors. Changing the Sybase client version will solve the
problem. You can move back to the 10.0.3 client.

Question:
Why do I receive an "Interface is not supported" error when
trying to use an interface?

Answer:
Verify that STDVCL32.DLL and your type library are registered.
If casting an interface, you must be using DCOM and the type
library must be registered on the client.

Question:
SELECT INTO statment returning error "ct_cursor(CLOSE); user api
layer: external error: A cursor must be opened before this
command type can be intialized." What is wrong and how do I get
around the problem?

Answer:
The Sybase CTLIB client will always parse a passthrough sql
statement weather or not we (Delphi, BDE, SQL Links, etc.) issue

an 'open' or 'exec'. If a SELECT is found to be the FIRST
word, it (Sybase CTLIB) will try to create a cursor hence the
error message. There is a workaround. Place a comment in front
of the SQL text like so:

CHANGE
select * into #temptable from oldtable

TO
/**/select * into #temptable from oldtable

Question:
"Application is not licensed to run this feature" error when
running demo application from \demos\db\clientds.

Answer:
This error occurs when attempting to use Delphi 3 Client/Server
features from Delphi 3 Professional or Standard editions. This
could happen if you compiled the demos using a compiler other
than the one that comes with Delphi 3 C/S. Check that the

Delphi 3 Professional was not installed previously without first
being un-installed. To correct this situation, uninstall
Delphi, double check for leftover Delphi files, and finally re-
install Delphi 3.0 C/S.