🚀 go-pugleaf

If you are using the SQL Links then you need to make sure that the
<OracleHome>\bin directory is in your path and the vendor init is oci.dll and
the dll32 is SQLORA8.dll for the BDE's Oracle driver (sue the BDE Admin to
change these settings).

Glen Zimmerman wrote:
> 
> I have installed the Oracle Net8 drivers and have been able to connect
> to the database through Oracle's admin utility.  However, I have not
> been able to get BDE to connect.  What is the proceedure for getting BDE
> to see the database?
> 
> Glen Zimmerman
> World Impact

-- 
Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
(Please do not email    'Till I lost the peace that dreaming gives
 me directly unless     I dreamed of the moment of my own death
 asked.  Thank You)     That no one ever dreams and lives (Marillion)

The path is set correctly; however, I don't see any environment variable for
<OracleHome>.  Is this suppose to be set as well?

The vendor init is set to oci.dll and the dll32 is sqlora8.dll.

When I try to connect to the database through the BDE admin utility, I get the
error message:
    General SQL error.
    ORA-01041: internal error.  hostdef extension doesn't exist.
    Alias:  ORACLE

I cannot find any reference that indicates where the hostdef extension is suppose
to be set.  Where is this set?

Glen Zimmerman



"Jeff Overcash (TeamB)" wrote:

> If you are using the SQL Links then you need to make sure that the
> <OracleHome>\bin directory is in your path and the vendor init is oci.dll and
> the dll32 is SQLORA8.dll for the BDE's Oracle driver (sue the BDE Admin to
> change these settings).
>
> Glen Zimmerman wrote:
> >
> > I have installed the Oracle Net8 drivers and have been able to connect
> > to the database through Oracle's admin utility.  However, I have not
> > been able to get BDE to connect.  What is the proceedure for getting BDE
> > to see the database?
> >
> > Glen Zimmerman
> > World Impact
>
> --
> Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
> (Please do not email    'Till I lost the peace that dreaming gives
>  me directly unless     I dreamed of the moment of my own death
>  asked.  Thank You)     That no one ever dreams and lives (Marillion)

Glen Zimmerman wrote:
> 
> The path is set correctly; however, I don't see any environment variable for
> <OracleHome>.  Is this suppose to be set as well?
> 

Yes.  Under Win9x it should be set in your autoexec.bat, under NT it is set in
the environment options.

> The vendor init is set to oci.dll and the dll32 is sqlora8.dll.
> 

Good.

> When I try to connect to the database through the BDE admin utility, I get the
> error message:
>     General SQL error.
>     ORA-01041: internal error.  hostdef extension doesn't exist.
>     Alias:  ORACLE
> 

I've never seen this error message before.

> I cannot find any reference that indicates where the hostdef extension is suppose
> to be set.  Where is this set?
> 
> Glen Zimmerman
> 

-- 
Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
(Please do not email    'Till I lost the peace that dreaming gives
 me directly unless     I dreamed of the moment of my own death
 asked.  Thank You)     That no one ever dreams and lives (Marillion)

I set the OracleHome in my autoexec.bat and rebooted.  I still get the same error.
I've deleted my Oracle BDE definition and defined a new one from scratch.  Still get
the same error.

One thing I noticed is that when I click on the down arrow next to the SERVER NAME
field, I receive the error message, "Invalid Filename".  Is there something else that
needs to be set?

I have run out of things to try, and I don't know where to go from here.

Glen Zimmerman

"Jeff Overcash (TeamB)" wrote:

> Glen Zimmerman wrote:
> >
> > The path is set correctly; however, I don't see any environment variable for
> > <OracleHome>.  Is this suppose to be set as well?
> >
>
> Yes.  Under Win9x it should be set in your autoexec.bat, under NT it is set in
> the environment options.
>
> > The vendor init is set to oci.dll and the dll32 is sqlora8.dll.
> >
>
> Good.
>
> > When I try to connect to the database through the BDE admin utility, I get the
> > error message:
> >     General SQL error.
> >     ORA-01041: internal error.  hostdef extension doesn't exist.
> >     Alias:  ORACLE
> >
>
> I've never seen this error message before.
>
> > I cannot find any reference that indicates where the hostdef extension is suppose
> > to be set.  Where is this set?
> >
> > Glen Zimmerman
> >
>
> --
> Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
> (Please do not email    'Till I lost the peace that dreaming gives
>  me directly unless     I dreamed of the moment of my own death
>  asked.  Thank You)     That no one ever dreams and lives (Marillion)

What is the format for specifying the SERVER NAME in the BDE Admin utility?  I've tried
the following combinations (alibaba is the Netware server name, ORCL is the SID, and
1521 the port number):
    Alibaba
    Alibaba:1521:ORCL
    Alibaba:ORCL
    Alibaba/1521:ORCL

"Jeff Overcash (TeamB)" wrote:

> Glen Zimmerman wrote:
> >
> > The path is set correctly; however, I don't see any environment variable for
> > <OracleHome>.  Is this suppose to be set as well?
> >
>
> Yes.  Under Win9x it should be set in your autoexec.bat, under NT it is set in
> the environment options.
>
> > The vendor init is set to oci.dll and the dll32 is sqlora8.dll.
> >
>
> Good.
>
> > When I try to connect to the database through the BDE admin utility, I get the
> > error message:
> >     General SQL error.
> >     ORA-01041: internal error.  hostdef extension doesn't exist.
> >     Alias:  ORACLE
> >
>
> I've never seen this error message before.
>
> > I cannot find any reference that indicates where the hostdef extension is suppose
> > to be set.  Where is this set?
> >
> > Glen Zimmerman
> >
>
> --
> Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
> (Please do not email    'Till I lost the peace that dreaming gives
>  me directly unless     I dreamed of the moment of my own death
>  asked.  Thank You)     That no one ever dreams and lives (Marillion)

Glen Zimmerman wrote:
> 
> I set the OracleHome in my autoexec.bat and rebooted.  I still get the same error.
> I've deleted my Oracle BDE definition and defined a new one from scratch.  Still get
> the same error.
> 

Just to verify you added <orahome>\bin right?  It needs to be pointing to the
bin directory.

> One thing I noticed is that when I click on the down arrow next to the SERVER NAME
> field, I receive the error message, "Invalid Filename".  Is there something else that
> needs to be set?
> 

Is SQL*Easy net working correctly on that machine?

> I have run out of things to try, and I don't know where to go from here.
> 
> Glen Zimmerman
> 

-- 
Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
(Please do not email    'Till I lost the peace that dreaming gives
 me directly unless     I dreamed of the moment of my own death
 asked.  Thank You)     That no one ever dreams and lives (Marillion)

Should just be something like Alibaba_DB.  Alibaba_DB should be the Oracle Alias
you set up using the SQL Easy*Net application (whatever you called it there). 
Make sure that you can connect first with the SQL Easy*Net and also SQL Plus to
make certain the Oracel Alias is setup up correctly first.

Glen Zimmerman wrote:
> 
> What is the format for specifying the SERVER NAME in the BDE Admin utility?  I've tried
> the following combinations (alibaba is the Netware server name, ORCL is the SID, and
> 1521 the port number):
>     Alibaba
>     Alibaba:1521:ORCL
>     Alibaba:ORCL
>     Alibaba/1521:ORCL
> 


-- 
Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
(Please do not email    'Till I lost the peace that dreaming gives
 me directly unless     I dreamed of the moment of my own death
 asked.  Thank You)     That no one ever dreams and lives (Marillion)

I have tried to connect to the database using a different work station which is still
using BDE 5.01 and has not been upgraded to BDE 5.1.  The error message we get is

        Unknow user name or password.
        ORA-24325  Service handle not initialized.

We've verified that the user name and password are valid(since we can connect using the
Net8 assistant).  I've made sure that the dll's are set for Oracle 8 and the path is
set correctly.  We've also tried TCP/IP and the TNS protocol and any number of
variations on the server name, but still get the same error.

Glen Zimmerman

"Jeff Overcash (TeamB)" wrote:

> Glen Zimmerman wrote:
> >
> > The path is set correctly; however, I don't see any environment variable for
> > <OracleHome>.  Is this suppose to be set as well?
> >
>
> Yes.  Under Win9x it should be set in your autoexec.bat, under NT it is set in
> the environment options.
>
> > The vendor init is set to oci.dll and the dll32 is sqlora8.dll.
> >
>
> Good.
>
> > When I try to connect to the database through the BDE admin utility, I get the
> > error message:
> >     General SQL error.
> >     ORA-01041: internal error.  hostdef extension doesn't exist.
> >     Alias:  ORACLE
> >
>
> I've never seen this error message before.
>
> > I cannot find any reference that indicates where the hostdef extension is suppose
> > to be set.  Where is this set?
> >
> > Glen Zimmerman
> >
>
> --
> Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
> (Please do not email    'Till I lost the peace that dreaming gives
>  me directly unless     I dreamed of the moment of my own death
>  asked.  Thank You)     That no one ever dreams and lives (Marillion)

That did it!  I was entering the Netware server name instead of the name that was assigned in
Easy*Net.  The BDE SERVER NAME field is rather confusing in exactly what it needs to have.

Thank you, very much.  We've been fighting this for about a week now.

Glen Zimmerman

"Jeff Overcash (TeamB)" wrote:

> Should just be something like Alibaba_DB.  Alibaba_DB should be the Oracle Alias
> you set up using the SQL Easy*Net application (whatever you called it there).
> Make sure that you can connect first with the SQL Easy*Net and also SQL Plus to
> make certain the Oracel Alias is setup up correctly first.
>
> Glen Zimmerman wrote:
> >
> > What is the format for specifying the SERVER NAME in the BDE Admin utility?  I've tried
> > the following combinations (alibaba is the Netware server name, ORCL is the SID, and
> > 1521 the port number):
> >     Alibaba
> >     Alibaba:1521:ORCL
> >     Alibaba:ORCL
> >     Alibaba/1521:ORCL
> >
>
> --
> Jeff Overcash (TeamB)   On waves of silver I dreamed of gold
> (Please do not email    'Till I lost the peace that dreaming gives
>  me directly unless     I dreamed of the moment of my own death
>  asked.  Thank You)     That no one ever dreams and lives (Marillion)