Cannot Load An Idapi Service Library File Sqlora8.dll
Rocki Stenger
/* ENGLISH VERSION (excuse me if you find some mistakes)*/We are developing an application with Delphi 3.0 for various databases.
The development database is SQL SERVER 6.5, and Delphi's code had
written under standarts that allow works with Oracle and SQL Server only
changing their respective Alias or BDE configuration. But when we tested
conectivity with Oracle 8.04, from BDE Admin 5.01 or from Database
desktop this error message appear: "Cannot load an IDAPI service
library. File: SQLORA8.dll" and the conection between Oracle Client an
Oracle Database was successfull (tested with SQL Net80 Easy
Configuration utility).Before we tested connectivity with Oracle 8.03 and BDE 5.0 with DLL32
and VENDOR INIT BDE's parameters in SQLORA32.DLL and OCIW32.DLL
respectively (because OCI.DLL doesn't exists in Oracle 8.03), but in
Delphi, TQueries' SQL sentences had problems with
objects names (case-sensitive). For this, we change BDE parameter DRIVER
FLAGS to 1 but now, when the application connect to SQL Server, the
problem with objects names (case-sensitive) appear. Also we obtain
conectivity from NT with DLL 32 in SQLORA32.DLL and VENDOR INIT in
SQLORA804.DLL, but with this configuration from client Win 95 this error
appear: "Vendor initialization failed" but this error is logic.In brief I need to know:
How can I finally load the library SQLORA8.DLL?
Which value would be defined (or DRIVER FLAG specificlly) in order to
the application runs in Oracle 8.04 and SQL SERVER 6.5 and/or 7.0?
What problems have been detected when exists connectivity with Oracle
8.04 and SQL Server 7.0? and, of course, your recommendations.
Exists SQLORA8.DLL later version, and if any, where can obtain it?I'm using:
Delphi 3.0 c/s
Oracle 8.0.4 (NT Version)
SQL Server 6.5
BDE 5.01Thanks for your help.
/* SPANISH VERSION*/Donde trabajo estamos desarrollando una aplicacin para que corra en
diversos motores de base de datos, est desarrollada en Delphi 3.0
y como base de datos de desarrollo SQL SERVER 6.5. El cdigo Delphi fu
desarrollado bajo estndares orientados a que la aplicacin funcione
tanto para Oracle como para SQL Server 6.5 con slo configurar el BDE.
Sin embargo, al probar conectividad con Oracle 8.04, desde el BDE Admin
o desde el database desktop y habindose probado ya conexin desde el
SQL NET Easy configuration de Oracle, aparece el error "Cannot load an
IDAPI service library. File: SQLORA8.dll". A pesar de estar trabajando
con BDE 5.01as como el vendor init OCI.dll de Oracle 8.04, tal como
est en la documentacin.Anteriormente se haban realizado pruebas de conectividad entre Oracle
8.03 y BDE 5.0 con el parmetro Dll32 en SQLORA32.dll y el Vendor init
en OCIW32.DLL (ya que el OCI.DLL en Oracle 8.03 no estaba presente),
pero tuvimos problemas de case sensitive en las sentencias
de los TQuery en Delphi al conectarse a Oracle y una vez solucionado, se
traslad a SQL SERVER 6.5, (es decir, en Oracle los nombres de los
objetos se requeran en mayscula, as que, el parmetro DRIVER FLAGS
del BDE se coloc en el valor 1 para el alias de la base de datos
Oracle, tal como se recomienda en la documentacin, pero ahora el SQL
Server no los interpreta como usualmente lo vena haciendo). Tambien se
logr conectividad desde un servidor NT con SQLORA32 y el Vendor Init en
ORA804.DLL, pero con esta misma configuracin
en el cliente Win 95 aparece error "Vendor initialization failed", lo
cual me parece ms lgico, en fin, hemos hecho de todo.En resumen necesito saber:Que debo hacer para que finalmente desde el cliente se pueda cargar la
librera SQLORA8.dll?
Cuales son los valores del parmetro DRIVER FLAG que debo tener para
que los nombres de los objetos sean case-insensitive en Oracle y que al
mismo tiempo la aplicacin funcione con SQL Server 6.5 y/o 7.0 y Oracle
8?
Que problemas se han detectado una vez se tiene conectividad con Oracle
8.04 as como con SQL Server 7.0 ? y por supuesto, las recomendaciones
para sortearlos.
Existe una versin ms reciente de la librera SQLORA8.DLL en donde no
tenga este tipo de problema? o si es, en efecto, un problema ya
documentado anteriormente.estoy utilizando:
Delphi 3.0 c/s
Oracle 8.0.4 (NT Version)
SQL Server 6.5
BDE 5.01Agradezco cualquier colaboracin.
I am using Delphi 4 with SQL 7.0 Database. I have hust migrated my database
from SQL 6.5 to SQL 7.0. And this gives me problems:* In delphi 4.0 I can not any more use the stored procedures I wrote in SQL
6.5 (which are now in SQL 7.0). I have a TStoredProc component in my
Delphi application and when trying to enter its StoredProcName I get an
error message : " Table does not existe. Sysprocedures :Incorrect object
name ".
Sysprocedures is a system table not mine as I haven't created it.But if I use a SQL 6.5 database it works perfectly : I am able to enter the
StoredProcName property of the TStoredProc component.I have checked SQL 7.0 system tables (with the stored procedure sp_tables)
and I did not find the table Sysprocedure (but Sysprocesses). But in SQL 6.5
there is the table Sysprocedures.Has someone already used TSotredProc in Delphi 4 to access a stored
procedure in SQL 7.0 database?Is anybody able to help me. I need your help !!!!!WilliamSoftware Developer
For WinNT, bring up the system applet frmo the control panel. Seelct the
enviornment tab and scroll down until you see the path veriable. Verify it is
there. You can also do the set verification from within a command prompt. I do
not believe NT has a path length limitation.You Oracle tools can work just fine without having this in the path since the
dll's exist in the working directory, but with third party tools, they are not
so must reside somewhere in the dll finding scheme of Windows.
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
The fool escaped from paradise will look over his shoulder and cry
Sit and chew on daffodils and struggle to answer why?
As you grow up and leave the playground
Where you kissed your Prince and found your frog
Remember the jester that showed you tears, the script for tears. (Fish)
--
I found a nice work-around that works in win95. With this procedure,
you set a path for each executable separately. This way you can
ensure that the path will be correct, regardless of what other
software is being used.Make a file called NAME.REG containing these lines:
REGEDIT4[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App
Paths\query.exe]
@="C:\\myapps\\query\\query.exe"
"Path"="C:\\windows;C:\\bde;D:\\orawin95\\bin"Notes:
The second line is blank.
The 3rd and 4th lines should be one line, extended out with no break.
The line containing @ should be the fully qualified pathname of your
executable, where each backslash in the real path uses 2 backslashes.
The last line is the path you want to use. I include Windows, plus the
BDE directory, and the Oracle bin directory.Once you have saved these 5 lines as NAME.REG, you can run it by
double-clicking on it from Explorer, or by using the START command in
a DOS box: C:>START NAME.REGNote that you also need one of these files to set up entries for
delphi32.exe, so you can connect to Oracle when you run your program
from the IDE.Eric Engler
Ol! Tentei baixar o arquivo e recebi a mensagem de banda excedida ("Bandwidth Limit Exceeded").
H a possibilidade de voc subir esse arquivo em outro lugar e disponibilizar? Desde j muito obrigado!
Thanks for posting this. Unfortunately I executed a "group by" query and while it runs, it returns zero records.
On a 32-bit machine with "proper" BDE installed, the app works fine.
On a 64-bit machine with the minimal BDE install, it fails.
Hi,
this solution might "save my life" but unfortunately I can't download your Installation package...
I keep getting the following message: Bandwidth Limit Exceeded.
Can you help me?
Aps instalar o BDE p/windows 7, recebo a seguinte msg. de erro qdo tento acessar o programa q preciso utilizar: "unknown database Alias: autsuper" e o programa no abre. Vc. pode me ajudar? Baixei o BDE pq usava um programa de assistencia tcnica no win xp, e agora mudei p/o windows 7 e ele sempre dava erro no BDE, e agora o q pode ser? Obrigada, Liliane
Thanks so much!
I have a several year old app that needs to work on Win 8. Had load of problems getting it to work. Win 8 wouldn't even let me run my old install kit. It wasn't a permissions or compatibility issue. It just said I couldn't run that program here. Annoying!
So, I tried downloading BDE's at other sources. No luck. They either wouldn't install or wouldn't work. Your's was the only one that worked and it worked beautifully!
Thanks again!
Hi I tried to install bde and via ssis package i was able to load from paradox db to sql server. It works fine on 32 bit but not on 64 bit . Can you please help.
I am trying to install on 64 bit windows 2008 .
Hi Jonno,
Did you receive any error message? Did you try to check the option to remove any previous installation (this option will in fact remove EVERYTHING BDE related from the system Registry).
Hi Daniel, What do you mean by "4GBPatch" directory? I believe that the setup does NOT create any any 4GBPatch directory... The setup is what it means to be: A BDE v 5.2.0.2 setup for Win Vista/7/2008 mainly, creted by me, once Borland/Embarcadero no longer provides such. If you have any doubts about the "nature" of this program, please submit it to www.virustotal.com, otherwise, just don't use it ;-)
Did anyone succeed to have Delphi/BDE run On Win 7 64 Bits with Oracle?
I am struggling having the error Cannot load IDAPI or OCI.DLL on Win 7.
On the other hand, I managed to make it work on Windows XP 64 Bit with registry key changes for DLLPath and CONFIGFILE01