Erro ao conectar em Banco de Dados com DBEXPRESS
Olá pessoal,
estou tendo algumas dificuldades em conectar tanto no Banco de Dados ORACLE quanto FIREBIRD.
estou utilizando
Delphi 2007 + update December
FireBird 2.0
Oracle 9g
esta aparecendo a seguinte mensagem quando eu tento conectar no Firebir:
´Failure to Connect cannot load oci.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
estou utilizando o Driver TBODbxFirebird
so que o estranho é, o erro tambem esta acontecendo quando eu tento conectar no Banco de dados Oracle.
´Failure to Connect cannot load oci.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
a unica diferença esta no driver.
aqui onde esta configurado:
C:\Documents and Settings\All Users\Documentos\RAD Studio\dbExpress
dbxconnections.ini
-------------------
dbxdrivers.ini
[Installed Drivers]
DB2=1
Interbase=1
MySQL=1
Oracle=1
Informix=1
MSSQL=1
ASA=1
ASE=1
BlackfishSQL=1
DBXTrace=1
DBXPool=1
TBODBXFB=1
[TBODBXFB]
DriverUnit=TBODbxDynalink
DriverPackageLoader=TTBODbxDriverLoader,TboDbxNative.bpl
DriverAssemblyLoader=TBODbxFbManaged.TTBODbxDriverLoader,TboDbxManaged
MetaDataPackageLoader=TDBXFirebirdMetaDataCommandFactory,TboDbxNative.bpl
MetaDataAssemblyLoader=DBXFirebirdReadOnlyMetaData.TDBXFirebirdMetaDataCommandFactory,TboDbxManaged
GetDriverFunc=getSQLDriver
LibraryName=tbodbxfb.dll
VendorLib=fbclient.dll
BlobSize=-1
CommitRetain=False
Database=database.gdb
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=3
TBODBXFB TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True
Trim Char=False
se alguem ja teve este problema por favor postem no FÓRUM.
abrcss.
estou tendo algumas dificuldades em conectar tanto no Banco de Dados ORACLE quanto FIREBIRD.
estou utilizando
Delphi 2007 + update December
FireBird 2.0
Oracle 9g
esta aparecendo a seguinte mensagem quando eu tento conectar no Firebir:
´Failure to Connect cannot load oci.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
estou utilizando o Driver TBODbxFirebird
so que o estranho é, o erro tambem esta acontecendo quando eu tento conectar no Banco de dados Oracle.
´Failure to Connect cannot load oci.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
a unica diferença esta no driver.
aqui onde esta configurado:
C:\Documents and Settings\All Users\Documentos\RAD Studio\dbExpress
dbxconnections.ini
-------------------
dbxdrivers.ini
[Installed Drivers]
DB2=1
Interbase=1
MySQL=1
Oracle=1
Informix=1
MSSQL=1
ASA=1
ASE=1
BlackfishSQL=1
DBXTrace=1
DBXPool=1
TBODBXFB=1
[TBODBXFB]
DriverUnit=TBODbxDynalink
DriverPackageLoader=TTBODbxDriverLoader,TboDbxNative.bpl
DriverAssemblyLoader=TBODbxFbManaged.TTBODbxDriverLoader,TboDbxManaged
MetaDataPackageLoader=TDBXFirebirdMetaDataCommandFactory,TboDbxNative.bpl
MetaDataAssemblyLoader=DBXFirebirdReadOnlyMetaData.TDBXFirebirdMetaDataCommandFactory,TboDbxManaged
GetDriverFunc=getSQLDriver
LibraryName=tbodbxfb.dll
VendorLib=fbclient.dll
BlobSize=-1
CommitRetain=False
Database=database.gdb
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=3
TBODBXFB TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True
Trim Char=False
se alguem ja teve este problema por favor postem no FÓRUM.
abrcss.
Marlonnardi
Curtidas 0
Respostas
Marlonnardi
21/10/2008
NINGUEM TEVE ESTE PROBLEMA??
GOSTEI 0
Marlonnardi
21/10/2008
Pessoal eu ja reinstalei o delphi, e o erro continua o mesmo, se alguem tiver alguma dica do que pode estar acontecendo eu agradeço.
GOSTEI 0
Rodolfo Ramos
21/10/2008
Esse erro eu Nunca Tive, mas passei por vários quando precisei conectar o Delphi 2007 com Banco Firebird. O jeito que eu uso é assim. Na aba DBExpress eu pego um Componente TSQLConnection, dai dê um Click duplo nele e no DataBase coloque sempre Localhost: antes do caminho do banco EX: Localhost:c:\teste.fdb isso sempre resolveu o meu problema. Espero que de certo com vc tb.
GOSTEI 0
Marlonnardi
21/10/2008
Vlw Rodolfo, ja fiz e refiz isto que você falou mas nada de conecta, apenas esta mensagem:
´Failure to Connect cannot load fbclinet.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
obrigado pela ajuda, eu vou formatar minha maquina e refazer todos os processos novamente.
´Failure to Connect cannot load fbclinet.dll library (error code 126). The tbodbxfb.dll library may be missing from the system path´
obrigado pela ajuda, eu vou formatar minha maquina e refazer todos os processos novamente.
GOSTEI 0
Marlonnardi
21/10/2008
Pessoal instalei todos os Programas em outra maquina, mas agora esta ocorrendo outro errro, o que eu estou fazendo de errado!!!!
Instalei o FireBird 2.0
Instalei padrão, marquei a opção para jogar a dll do FireBird no system 32
Instalei o Delphi 2007 + December Update
instalei Padrao
instalei o Driver TBODBXFB
Configurei exatemente igual ao Curso do Grande RODRIGO CARRERO
(ja sei decor, a 1a video aula, rsrsr)
https://www.devmedia.com.br/articles/viewcomp.asp?comp=9585
mas agora esta dando este erro:
Acess violation at address 01F34CFA in module ´tbodbxfb.dll´. Write os address 00000015
Detalhes>>
(01F33CFA){bds.exe } [01F34CFA]
[0CA231FC]{DbxDynalinkDriver100.bpl} Dbxdynalink.TDBXDynalinkDriverCommonLoader.Load + $124
[0C90A8E6]{DbxCommonDriver100.bpl} Dbxcommon.TDBXDriverRegistry.LoadDriver + $72
[0C90AA32]{DbxCommonDriver100.bpl} Dbxcommon.TDBXDriverRegistry.GetDriver + $72
[0C907D32]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionFactory.GetDriver + $46
[0C90F740]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionBuilder.CreateConnection + $7C
[0C90783D]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionFactory.GetConnection + $DD
[406A7FFB]{dbexpress4100.bpl} SqlExpr.TSQLConnection.DoConnect (Line 2453, ´..\..\..\..\..\src\pas\dbx\vcl\SqlExpr.pas´ + 52) + $5
[203A0C75]{dbrtl100.bpl} DB.TCustomConnection.SetConnected (Line 2627, ´DB.pas´ + 7) + $7
[2002AE7E]{rtl100.bpl } TypInfo.SetOrdProp (Line 1316, ´common\TypInfo.pas´ + 27) + $0
[20D29FD6]{designide100.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 841, ´DesignEditors.pas´ + 2) + $E
[20D2B073]{designide100.bpl} DesignEditors.TEnumProperty.SetValue (Line 1401, ´DesignEditors.pas´ + 5) + $4
[20D29C8D]{designide100.bpl} DesignEditors.TPropertyEditor.Edit (Line 671, ´DesignEditors.pas´ + 11) + $14
[20AB55C6]{coreide100.bpl} PropInsp.TPropertyInspector.PropListEditDblClick (Line 855, ´PropInsp.pas´ + 20) + $5
[20E0ED7D]{vclide100.bpl} IDEInspListBox.TInspListBox.DoEditDblClick (Line 967, ´ideinsplistbox.pas´ + 2) + $A
[20E10602]{vclide100.bpl} IDEInspListBox.TInspListBox.EditDblClick (Line 1538, ´ideinsplistbox.pas´ + 0) + $2
[2013CA49]{vcl100.bpl } Controls.TControl.DblClick (Line 5234, ´Controls.pas´ + 1) + $14
[2013CBAC]{vcl100.bpl } Controls.TControl.WMLButtonDblClk (Line 5275, ´Controls.pas´ + 4) + $C
[2013C527]{vcl100.bpl } Controls.TControl.WndProc (Line 5146, ´Controls.pas´ + 83) + $6
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, ´Controls.pas´ + 111) + $6
[2132827C]{vclactnband100.bpl} ActnMenus.CallWndHook (Line 703, ´ActnMenus.pas´ + 12) + $F
[2003203C]{rtl100.bpl } Classes.TThreadList.UnlockList (Line 3359, ´common\Classes.pas´ + 0) + $4
[200EBAA8]{vcl100.bpl } Graphics.FreeMemoryContexts (Line 5060, ´Graphics.pas´ + 12) + $5
[20140158]{vcl100.bpl } Controls.TWinControl.IsControlMouseMsg (Line 7176, ´Controls.pas´ + 9) + $25
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, ´Controls.pas´ + 111) + $6
[20E0DF4B]{vclide100.bpl} IDEInspListBox.TPropInspEdit.WndProc (Line 430, ´ideinsplistbox.pas´ + 7) + $4
[2013FDD0]{vcl100.bpl } Controls.TWinControl.MainWndProc (Line 7073, ´Controls.pas´ + 3) + $6
[20040E4C]{rtl100.bpl } Classes.StdWndProc (Line 11583, ´common\Classes.pas´ + 8) + $0
[20163691]{vcl100.bpl } Forms.TApplication.StopHintTimer (Line 8673, ´Forms.pas´ + 3) + $6
[201625E8]{vcl100.bpl } Forms.TApplication.ProcessMessage (Line 8103, ´Forms.pas´ + 21) + $1
[2016262A]{vcl100.bpl } Forms.TApplication.HandleMessage (Line 8124, ´Forms.pas´ + 1) + $4
[2016291F]{vcl100.bpl } Forms.TApplication.Run (Line 8223, ´Forms.pas´ + 20) + $3
[0042297A]{bds.exe } bds.bds (Line 195, ´´ + 7) + $7
Se alguem puder me dar alguma orientação, eu agradeço muito.
abrcss.
Instalei o FireBird 2.0
Instalei padrão, marquei a opção para jogar a dll do FireBird no system 32
Instalei o Delphi 2007 + December Update
instalei Padrao
instalei o Driver TBODBXFB
Configurei exatemente igual ao Curso do Grande RODRIGO CARRERO
(ja sei decor, a 1a video aula, rsrsr)
https://www.devmedia.com.br/articles/viewcomp.asp?comp=9585
mas agora esta dando este erro:
Acess violation at address 01F34CFA in module ´tbodbxfb.dll´. Write os address 00000015
Detalhes>>
(01F33CFA){bds.exe } [01F34CFA]
[0CA231FC]{DbxDynalinkDriver100.bpl} Dbxdynalink.TDBXDynalinkDriverCommonLoader.Load + $124
[0C90A8E6]{DbxCommonDriver100.bpl} Dbxcommon.TDBXDriverRegistry.LoadDriver + $72
[0C90AA32]{DbxCommonDriver100.bpl} Dbxcommon.TDBXDriverRegistry.GetDriver + $72
[0C907D32]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionFactory.GetDriver + $46
[0C90F740]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionBuilder.CreateConnection + $7C
[0C90783D]{DbxCommonDriver100.bpl} Dbxcommon.TDBXConnectionFactory.GetConnection + $DD
[406A7FFB]{dbexpress4100.bpl} SqlExpr.TSQLConnection.DoConnect (Line 2453, ´..\..\..\..\..\src\pas\dbx\vcl\SqlExpr.pas´ + 52) + $5
[203A0C75]{dbrtl100.bpl} DB.TCustomConnection.SetConnected (Line 2627, ´DB.pas´ + 7) + $7
[2002AE7E]{rtl100.bpl } TypInfo.SetOrdProp (Line 1316, ´common\TypInfo.pas´ + 27) + $0
[20D29FD6]{designide100.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 841, ´DesignEditors.pas´ + 2) + $E
[20D2B073]{designide100.bpl} DesignEditors.TEnumProperty.SetValue (Line 1401, ´DesignEditors.pas´ + 5) + $4
[20D29C8D]{designide100.bpl} DesignEditors.TPropertyEditor.Edit (Line 671, ´DesignEditors.pas´ + 11) + $14
[20AB55C6]{coreide100.bpl} PropInsp.TPropertyInspector.PropListEditDblClick (Line 855, ´PropInsp.pas´ + 20) + $5
[20E0ED7D]{vclide100.bpl} IDEInspListBox.TInspListBox.DoEditDblClick (Line 967, ´ideinsplistbox.pas´ + 2) + $A
[20E10602]{vclide100.bpl} IDEInspListBox.TInspListBox.EditDblClick (Line 1538, ´ideinsplistbox.pas´ + 0) + $2
[2013CA49]{vcl100.bpl } Controls.TControl.DblClick (Line 5234, ´Controls.pas´ + 1) + $14
[2013CBAC]{vcl100.bpl } Controls.TControl.WMLButtonDblClk (Line 5275, ´Controls.pas´ + 4) + $C
[2013C527]{vcl100.bpl } Controls.TControl.WndProc (Line 5146, ´Controls.pas´ + 83) + $6
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, ´Controls.pas´ + 111) + $6
[2132827C]{vclactnband100.bpl} ActnMenus.CallWndHook (Line 703, ´ActnMenus.pas´ + 12) + $F
[2003203C]{rtl100.bpl } Classes.TThreadList.UnlockList (Line 3359, ´common\Classes.pas´ + 0) + $4
[200EBAA8]{vcl100.bpl } Graphics.FreeMemoryContexts (Line 5060, ´Graphics.pas´ + 12) + $5
[20140158]{vcl100.bpl } Controls.TWinControl.IsControlMouseMsg (Line 7176, ´Controls.pas´ + 9) + $25
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, ´Controls.pas´ + 111) + $6
[20E0DF4B]{vclide100.bpl} IDEInspListBox.TPropInspEdit.WndProc (Line 430, ´ideinsplistbox.pas´ + 7) + $4
[2013FDD0]{vcl100.bpl } Controls.TWinControl.MainWndProc (Line 7073, ´Controls.pas´ + 3) + $6
[20040E4C]{rtl100.bpl } Classes.StdWndProc (Line 11583, ´common\Classes.pas´ + 8) + $0
[20163691]{vcl100.bpl } Forms.TApplication.StopHintTimer (Line 8673, ´Forms.pas´ + 3) + $6
[201625E8]{vcl100.bpl } Forms.TApplication.ProcessMessage (Line 8103, ´Forms.pas´ + 21) + $1
[2016262A]{vcl100.bpl } Forms.TApplication.HandleMessage (Line 8124, ´Forms.pas´ + 1) + $4
[2016291F]{vcl100.bpl } Forms.TApplication.Run (Line 8223, ´Forms.pas´ + 20) + $3
[0042297A]{bds.exe } bds.bds (Line 195, ´´ + 7) + $7
Se alguem puder me dar alguma orientação, eu agradeço muito.
abrcss.
GOSTEI 0
Marlonnardi
21/10/2008
OBS. No Banco de Dados ORACLE eu consegui conectar sem problemas.
GOSTEI 0
Fcorrea82
21/10/2008
cara no Sqlconnection nao precisa por o localhost so por o diretorio q vai na boa.
GOSTEI 0
Marlonnardi
21/10/2008
RESOLVIDO, apesar de apanhar muito, para resolver o problema era so joga a ddl do fbclient dentro da pasta do meu projeto...
um grande abrcss a todos.
um grande abrcss a todos.
GOSTEI 0
Josehenrique
21/10/2008
OBS. No Banco de Dados ORACLE eu consegui conectar sem problemas.
Por favor me tire uma dúvida, vc está utilizando qual windows, pois eu estou utilizando o vista ultimate x64 e nao consigo por nada nesse mundo me conectar com o banco, ja testei o banco com outros aplicativos e nos outros tudo ok, mas no delphi nada ....já usei TSQLConnection, TADOConnection, TOracleSession, TZConnection, etc. ....
GOSTEI 0