🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.intrabuilder.data.bde
3 messages
3 total messages Started by Srinivasa Rao Madireddi Fri, 04 Sep 1998 00:00
Oracle: Connecting?
#116
Author: Srinivasa Rao Madireddi
Date: Fri, 04 Sep 1998 00:00
52 lines
2045 bytes
Hi,

        My application is on WindowsNT 4.0 Workstation. My database at
the moment is on Access.

I have  transferred the database onto Oracel8 (Enterprise edition
Release 8.0.3.00) on a Sun Solaris server.

I have configured my SQL*NET (ver greater than 2) to have an alias
(GEN).

I tried to connect to the Oracle database from my local SQL*PLUS it was
successful. I tried a few queries from the local SQL*PLUS interface adn
it was also successful.

I want to use SQL Links to connect to the Oracle database. So, I went to
the BDE Administrator
(Intrabuilder ver 1.5) and created a new ORACLE alias (TESTO), in the
"SERVER NAME" setting I selected "GEN" which was listed. I saved the new
alias settings.

When I tried to view the Oracle database from within the BDE
Administrator it prompted for a password and login name, when I provided
the correct login name and password it failed to connect and
the following error was displayed:

Vendor initialization failed
Cannot load IDAPI service library
File: ORANT71.DLL
Alias: testo

On  clicking the details button the following was displayed:

BDE Error: 15879   [$3E][$7]
Vendor intialization failed.

On clicking the next button the following was displayed:

BDE Error: 8458 [$21][$A]
File ORANT71.DLL

On clicking the next button again the following was displayed:

BDE ERROR: 15879 [$3E][$7]
Alias: testo


Can anybody please help me with this problem......I need to connect to
Oracle8....

Thanks in advance,
-Srinivas.
Re: Oracle: Connecting?
#118
Author: d_kris
Date: Thu, 17 Sep 1998 00:00
64 lines
2676 bytes
If you are using a version earlier to BDE5.0, make sure that
ORANT71.DLL is in your path.
If u r using BDE5.0, good luck and post results if u r successful.

Kris

In article <35EF9E54.92F5CD2E@numbat.cs.rmit.edu.au>,
  Srinivasa Rao Madireddi <srin@numbat.cs.rmit.edu.au> wrote:
> Hi,
>
>         My application is on WindowsNT 4.0 Workstation. My database at
> the moment is on Access.
>
> I have  transferred the database onto Oracel8 (Enterprise edition
> Release 8.0.3.00) on a Sun Solaris server.
>
> I have configured my SQL*NET (ver greater than 2) to have an alias
> (GEN).
>
> I tried to connect to the Oracle database from my local SQL*PLUS it was
> successful. I tried a few queries from the local SQL*PLUS interface adn
> it was also successful.
>
> I want to use SQL Links to connect to the Oracle database. So, I went to
> the BDE Administrator
> (Intrabuilder ver 1.5) and created a new ORACLE alias (TESTO), in the
> "SERVER NAME" setting I selected "GEN" which was listed. I saved the new
> alias settings.
>
> When I tried to view the Oracle database from within the BDE
> Administrator it prompted for a password and login name, when I provided
> the correct login name and password it failed to connect and
> the following error was displayed:
>
> Vendor initialization failed
> Cannot load IDAPI service library
> File: ORANT71.DLL
> Alias: testo
>
> On  clicking the details button the following was displayed:
>
> BDE Error: 15879   [$3E][$7]
> Vendor intialization failed.
>
> On clicking the next button the following was displayed:
>
> BDE Error: 8458 [$21][$A]
> File ORANT71.DLL
>
> On clicking the next button again the following was displayed:
>
> BDE ERROR: 15879 [$3E][$7]
> Alias: testo
>
> Can anybody please help me with this problem......I need to connect to
> Oracle8....
>
> Thanks in advance,
> -Srinivas.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum
Re: Oracle: Connecting?
#119
Author: Ken Rachynski
Date: Thu, 17 Sep 1998 00:00
30 lines
1325 bytes
The Oracle driver in BDE has two DLLs that it can use: one for Oracle 7 and
one for Oracle8. From your error messages, you are using the Oracle 7
driver. I think that using the Oracle8 driver requires that you have Net8
installed instead of SQL*NET.

Ken Rachynski
Database Analyst


Srinivasa Rao Madireddi wrote in message
<35EF9E54.92F5CD2E@numbat.cs.rmit.edu.au>...
>Hi,
>
>        My application is on WindowsNT 4.0 Workstation. My database at
>the moment is on Access.
>
>I have  transferred the database onto Oracel8 (Enterprise edition
>Release 8.0.3.00) on a Sun Solaris server.
>
>I have configured my SQL*NET (ver greater than 2) to have an alias
>(GEN).

>Can anybody please help me with this problem......I need to connect to
>Oracle8....
>
>Thanks in advance,
>-Srinivas.
>
>
>
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads