Board index » delphi » Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist

Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist

I am not successfull in creating a bde-alias for oracle8i while using
sqlora8.dll and oci.dll getting the following errormessages:

Allgemeiner SQL-Fehler
ORA-01041: internal error, hostdef extension doesn't exist
Alias: ORATEST

Direct connection through sql-net works fine. An alias that references an
odbc-dsn that points to the db works fin also.
Installed products: Oracle 8i, Enterprise Manager, BDE 5.01
Does anyone know where the problem may be ?

Thank's in advance.

Martin Suer

 

Re:Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist


Hello,

We have had a lot of problems using the BDE501 and the Oracle8i Client. The
more of them are solved with the BDE5.1 and the SQLORA8.dll updates.

I think this should be your first movement.

PD: And the ORA01014 appears to us always due to an internal error (ORA600)
We have been having this error while we have installed the client in our
locale language. Oracle Support let us to change the registry setting the
NLS_LANG parameter to AMERICAN_AMERICA, and then adding the parameters to
get our locale date format again. This is for our Snanish instalation but
due to the fact the the CD should be the same and the language is getted
from the Windows configuration maybe you are in the same position.

The change we have done are:

HKLM/Software/Oracle/NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
......................................../NLS_DATE_FORMAT=DD/MM/YY
......................................../NLS_NUMERIC_CHARACTERS=,.

But in any case I let you to talk with your locale Oracle Support because
this solution is for us in our case.

Hope this helps

    Luis.

--
......................................................
Luis Morales Boisset - Departamento IT
Infonis International.
lbois...@infonis.es

Martin Suer <m.s...@klueh.de> escribi en el mensaje de noticias
825d3g$1p...@forums.borland.com...

Quote

Re:Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist


You get the same errormessage when You for instance try to use a synonym
that is not longer valid (because a database-link has been dropped). The
message comes directly in SQL-Plus, is not BDE-specific.
So one of the reasons could be an error in names, synonyms, ... only one
idea.
Martin Suer <m.s...@klueh.de> schrieb in im Newsbeitrag:
825d3g$1p...@forums.borland.com...
Quote
> I am not successfull in creating a bde-alias for oracle8i while using
> sqlora8.dll and oci.dll getting the following errormessages:

> Allgemeiner SQL-Fehler
> ORA-01041: internal error, hostdef extension doesn't exist
> Alias: ORATEST

> Direct connection through sql-net works fine. An alias that references an
> odbc-dsn that points to the db works fin also.
> Installed products: Oracle 8i, Enterprise Manager, BDE 5.01
> Does anyone know where the problem may be ?

> Thank's in advance.

> Martin Suer

Re:Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist


Thank's to all. I solved the problem by updating to then bde 5.1 with the
sqlora8.dll - patch and removing the path to a previous installed Oracle 7.3
version.

Martin Suer <m.s...@klueh.de> schrieb in im Newsbeitrag:
825d3g$1p...@forums.borland.com...

Quote
> I am not successfull in creating a bde-alias for oracle8i while using
> sqlora8.dll and oci.dll getting the following errormessages:

> Allgemeiner SQL-Fehler
> ORA-01041: internal error, hostdef extension doesn't exist
> Alias: ORATEST

> Direct connection through sql-net works fine. An alias that references an
> odbc-dsn that points to the db works fin also.
> Installed products: Oracle 8i, Enterprise Manager, BDE 5.01
> Does anyone know where the problem may be ?

> Thank's in advance.

> Martin Suer

Other Threads