Portal de Documentação

Appearance

Home Portal Cloud

Tag-icone-mini.png BDE

Referenciado por: Configurações BDE e ODBC | Dicas Técnicas |

Nesse artigo podemos descrever configurações que funcionaram, e técnicas utilizadas para contornar problemas de BDE.
Ao descrever uma configuração que funcionou, é imprescindível seguir o modelo, para informar todos os dados necessários.

Importante ​

A configuração oficial de BDE e ODBC está disponível no artigo Configurações BDE e ODBC.

Configuração na Máquina TTWTS2012 ​

Configurações da Máquina:

  • Processador: Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz (12 processors)
  • Memória instalada (RAM): 10,0 GB
  • Sistema Operacional: Windows Server 2012 R2 Standard - 64-bit Operating System Versão do Windows não confirmada

Versões dos Programas Instalados:

  • Versão da BDE: 5.01 (32 bits) 32 bits não confirmado
  • Versão do Driver PostgreSQL do ODBC: 4.0
  • Client Oracle 11g 32 bits versão 11.2.0.1.0. 32 bits não confirmado

Configuração da BDE:

Configuration |- System |-- INIT |--- AUTO ODBC = FALSE |--- DATA REPOSITORY = Sample Data Dictionary |--- DEFAULT DRIVER = PARADOX |--- LANGDRIVER = Pdox ANSI Intl850 |--- LOCAL SHARE = FALSE |--- LOW MERORY USAGE LIMIT = 128 |--- MAXBUFSIZE = 20480 |--- MAXFILEHANDLES = 4096 |--- MENSIZE = 205 |--- MINBUFSIZE = 65535 |--- MTS POOLING = FALSE |--- SHAREDMEMLOCATION = 4000 |--- SHAREDMENSIZE = 4096 |--- SQLQRYMODE = |--- SYSFLAGS = 0 |--- VERION = 4.0 |- Drivers |-- Native |--- PARADOX |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = Pdox ANSI Intl850 |---- NET DIR = C:\ |---- BLOCK SIZE = 2048 |---- FILL FACTOR = 95 |---- LEVEL = 7 |---- STRINGINTEGRTY = TRUE |--- DBASE |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = 'WEurope' ANSI |---- LEVEL = 25 |---- MDX BLOCK SIZE = 1024 |---- MEMO FILE BLOCK SIZE = 1024 |--- ORACLE |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL32 = SQLORA32.DLL |---- VENDOR INIT = oraclient11.dll |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 200 |---- BLOB SIZE = 32 |---- BLOBS TO CACHE = 64 |---- ENABLE BCD = FALSE |---- ENABLE INTEGERS = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- LIST SYNONYMS = NONE |---- MAX ROWS = -1 |---- NET PROTOCOL = TNS |---- OBJECT MODE = TRUE |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SERVER NAME = ORA_SERVER |---- SQLPASSTHRU MODE = SHARED NOAUTOCOMMIT |---- SQLQRYMODE = SERVER |---- USER NAME = TOTALI |-- ODBC |--- PostgreSQL |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL = IDODBC01.DLL |---- DLL32 = IDODBC32.DLL |---- ODBC DRIVER = PostgreSQL |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 32 |---- BLOBS TO CACHE = 8192 |---- DATABASE NAME = |---- ENABLE BCD = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- MAX ROWS = -1 |---- ODBC DSN = |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SQLPASSTHRU MODE = SHARED AUTOCOMMIT |---- SQLQRYMODE = |---- USER NAME =

Configuração do ODBC:

Options >>> DataSource   Page 1 [X] Disable Genetic Optimizer [X] KSQO (Keyset Query Optimization) [X] Recognize Unique Indexes [_] Use Declare/Fetch [_] CommLog (C:\psqlodbc_xxxx.log) [_] Parse Statements [_] Cancel as FreeStmt (Exp) [_] MyLog (C:\mylog_xxxx.log)   Unknown Sizes (_) Maximum (_) Don't Know (o) Longest   Data Type Options [_] Text as LongVarChar [_] Unknows as LongVarChar [_] Bools as Char   Miscellanous Max Varchar = 4000 Max LongVarChar = 4000 Cache Size = 100 SysTable Prefixes = dd_;   Page 2 [_] Read Only [_] Show System Tables [X] LF <-> CR/LF conversion [X] Updatable Cursors [_] Row Versioning [_] Disallow Premature [_] True is -1   Int8 As (_) default (o) bigint (_) numeric (_) varchar (_) double (_) int4   Protocol (o) 7.X,6.4+ (_) 6.3 (_) 6.2   OID Options [_] Show Column   Connect Settings =

Data que Configuração foi Realizada: 05/07/2018
Por Quem: Pedro Braga
Observações da configuração:
Configurações conferidas no TTWTS2012.

Configuração na Máquina TTWTS ​

Configurações da Máquina:

  • Processador: Intel(R) Xeon(R) CPU E5-2420 v2 @ 2.20GHz (2 processors)
  • Memória instalada (RAM): 14,0 GB
  • Sistema Operacional: Windows Server 2003 - 64-bit Operating System - Service Pack 1 Versão do Windows não confirmada

Versões dos Programas Instalados:

  • Versão da BDE: 5.2.0.2 (32 bits) 32 bits não confirmado
  • Versão do Driver PostgreSQL do ODBC: 5.0
  • Client Oracle 11g 32 bits versão 11.2.0.1.0. 32 bits não confirmado

Configuração da BDE:

Configuration |- Drivers |-- Native |--- PARADOX |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = Pdox ANSI Intl850 |---- NET DIR = c:\temp\ |---- BLOCK SIZE = 2048 |---- FILL FACTOR = 95 |---- LEVEL = 7 |---- STRINGINTEGRTY = TRUE |--- DBASE |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = 'WEurope' ANSI |---- LEVEL = 25 |---- MDX BLOCK SIZE = 1024 |---- MEMO FILE BLOCK SIZE = 1024 |--- ORACLE |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL32 = SQLORA32.DLL |---- VENDOR INIT = oraclient11.dll |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- ENABLE BCD = FALSE |---- ENABLE INTEGERS = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- LIST SYNONYMS = NONE |---- MAX ROWS = -1 |---- NET PROTOCOL = TNS |---- OBJECT MODE = TRUE |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SERVER NAME = ORA_SERVER |---- SQLPASSTHRU MODE = SHARED NOAUTOCOMMIT |---- SQLQRYMODE = SERVER |---- USER NAME = TOTALI |-- ODBC |--- PostgreSQL |---- VERSION = 5.0 |---- TYPE = SERVER |---- DLL = IDODBC01.DLL |---- DLL32 = IDODBC32.DLL |---- ODBC DRIVER = PostgreSQL |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- DATABASE NAME = |---- ENABLE BCD = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- MAX ROWS = -1 |---- ODBC DSN = |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SQLPASSTHRU MODE = SHARED AUTOCOMMIT |---- SQLQRYMODE = |---- USER NAME =

Configuração do ODBC:

Options >>> DataSource   Page 1 [X] Disable Genetic Optimizer [X] KSQO (Keyset Query Optimization) [X] Recognize Unique Indexes [_] Use Declare/Fetch [_] CommLog (C:\psqlodbc_xxxx.log) [_] Parse Statements [_] Cancel as FreeStmt (Exp) [_] MyLog (C:\mylog_xxxx.log)   Unknown Sizes (_) Maximum (_) Don't Know (o) Longest   Data Type Options [_] Text as LongVarChar [_] Unknows as LongVarChar [_] Bools as Char   Miscellanous Max Varchar = 4000 Max LongVarChar = 4000 Cache Size = 100 SysTable Prefixes = dd_;   Page 2 [_] Read Only [_] Show System Tables [X] LF <-> CR/LF conversion [X] Updatable Cursors [_] Row Versioning [_] Disallow Premature [_] True is -1   Int8 As (_) default (o) bigint (_) numeric (_) varchar (_) double (_) int4   Protocol (o) 7.X,6.4+ (_) 6.3 (_) 6.2   OID Options [_] Show Column   Connect Settings =

Data que Configuração foi Realizada: 20/07/2015
Por Quem: Rodrigo Petters
Observações da configuração:
Configurações conferidas no TTWTS.

Configuração na Máquina TTPetters ​

Configurações da Máquina:

  • Processador: Intel Core i5-3330 CPU @ 3.00 GHz
  • Memória instalada (RAM): 4,00 GB
  • Sistema Operacional: Windows 7 64 bits com Service Pack 1

Versões dos Programas Instalados:

  • Versão da BDE: 5.2.0.2 (32 bits)
  • Versão do Driver PostgreSQL do ODBC: 4.0
  • Client Oracle 11g 32 bits versão 11.2.0.1.0.

Configuração da BDE:

Configuration |- Drivers |-- Native |--- PARADOX |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = Pdox ANSI Intl850 |---- NET DIR = C:\ |---- BLOCK SIZE = 2048 |---- FILL FACTOR = 95 |---- LEVEL = 7 |---- STRINGINTEGRTY = TRUE |--- DBASE |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = 'WEurope' ANSI |---- LEVEL = 25 |---- MDX BLOCK SIZE = 1024 |---- MEMO FILE BLOCK SIZE = 1024 |--- ORACLE |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL32 = SQLORA32.DLL |---- VENDOR INIT = oraclient11.dll |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- ENABLE BCD = FALSE |---- ENABLE INTEGERS = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- LIST SYNONYMS = NONE |---- MAX ROWS = -1 |---- NET PROTOCOL = TNS |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SERVER NAME = TOTALI |---- SQLPASSTHRU MODE = SHARED NOAUTOCOMMIT |---- SQLQRYMODE = SERVER |---- USER NAME = TOTALI |-- ODBC |--- PostgreSQL |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL = IDODBC01.DLL |---- DLL32 = IDODBC32.DLL |---- ODBC DRIVER = PostgreSQL |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- DATABASE NAME = |---- ENABLE BCD = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- MAX ROWS = -1 |---- ODBC DSN = |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SQLPASSTHRU MODE = SHARED AUTOCOMMIT |---- SQLQRYMODE = |---- USER NAME =

Configuração do ODBC:

Options >>> DataSource   Page 1 [X] Disable Genetic Optimizer [X] KSQO (Keyset Query Optimization) [X] Recognize Unique Indexes [_] Use Declare/Fetch [_] CommLog (C:\psqlodbc_xxxx.log) [_] Parse Statements [_] Cancel as FreeStmt (Exp) [_] MyLog (C:\mylog_xxxx.log)   Unknown Sizes (_) Maximum (_) Don't Know (o) Longest   Data Type Options [_] Text as LongVarChar [_] Unknows as LongVarChar [_] Bools as Char   Miscellanous Max Varchar = 4000 Max LongVarChar = 4000 Cache Size = 100 SysTable Prefixes = dd_;   Page 2 [_] Read Only [_] Show System Tables [X] LF <-> CR/LF conversion [X] Updatable Cursors [_] Row Versioning [_] Disallow Premature [_] True is -1   Int8 As (_) default (o) bigint (_) numeric (_) varchar (_) double (_) int4   Protocol (o) 7.X,6.4+ (_) 6.3 (_) 6.2   OID Options [_] Show Column   Connect Settings =

Data que Configuração foi Realizada: 17/07/2015
Por Quem: Rodrigo Petters
Observações da configuração:
Ele é igual a de BDE e ODBC vigente.
Abri um Backoffice, um Delivery e um Order e não ocorreu nenhum erro de BDE.

Configuração da Casa Carneiro ​

Configurações da Máquina:

  • Processador: Intel Xeon CPU E5-2609 v3 @ 1.90 GHz
  • Memória instalada (RAM): 8,00 GB
  • Sistema Operacional: Windows Server 2008 R2 Enterprise Service Pack 1

Versões dos Programas Instalados:

  • Versão da BDE: 5.2.0.2 (32 bits)
  • Versão do Driver PostgreSQL do ODBC: 5.0

Configuração da BDE:

Configuration |- Drivers |-- Native |--- PARADOX |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = Pdox ANSI Intl850 |---- NET DIR = C:\ |---- BLOCK SIZE = 2048 |---- FILL FACTOR = 95 |---- LEVEL = 25 |---- STRINGINTEGRTY = TRUE |--- DBASE |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = 'WEurope' ANSI |---- LEVEL = 25 |---- MDX BLOCK SIZE = 1024 |---- MEMO FILE BLOCK SIZE = 1024 |-- ODBC |--- PostgreSQL |---- VERSION = 5.0 |---- TYPE = SERVER |---- DLL = IDODBC01.DLL |---- DLL32 = IDODBC32.DLL |---- ODBC DRIVER = PostgreSQL |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- DATABASE NAME = |---- ENABLE BCD = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- MAX ROWS = -1 |---- ODBC DSN = |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SQLPASSTHRU MODE = SHARED AUTOCOMMIT |---- SQLQRYMODE = |---- USER NAME =

Configuração do ODBC:

Options >>> DataSource   Page 1 [X] Disable Genetic Optimizer [X] KSQO (Keyset Query Optimization) [X] Recognize Unique Indexes [_] Use Declare/Fetch [_] CommLog (C:\psqlodbc_xxxx.log) [_] Parse Statements [_] Cancel as FreeStmt (Exp) [_] MyLog (C:\mylog_xxxx.log)   Unknown Sizes (_) Maximum (_) Don't Know (o) Longest   Data Type Options [_] Text as LongVarChar [_] Unknows as LongVarChar [_] Bools as Char   Miscellanous Max Varchar = 4000 Max LongVarChar = 8190 Cache Size = 1000 SysTable Prefixes = dd_;   Page 2 [_] Read Only [_] Show System Tables [X] LF <-> CR/LF conversion [X] Updatable Cursors [_] Row Versioning [_] Disallow Premature [_] True is -1   Int8 As (_) default (o) bigint (_) numeric (_) varchar (_) double (_) int4   Protocol (o) 7.X,6.4+ (_) 6.3 (_) 6.2   OID Options [_] Show Column   Connect Settings =

Data que Configuração foi Realizada: 23/03/2017
Por Quem: Guilherme
Observações da configuração:
Foi feita após solicitação da Nathália da Casa Carneiro porque a configuração padrão não permitir abrir o CheckOut Server e o Backoffice ao mesmo tempo.

Configuração na Máquina DI000867 (Rhuan) ​

Configurações da Máquina:

  • Processador: Intel Core i5-3470S CPU @ 2.90 GHz
  • Memória instalada (RAM): 8,00 GB
  • Sistema Operacional: Windows 10 64 bits Enterprise

Versões dos Programas Instalados:

  • Versão da BDE: 5.01 (32 bits)
  • Versão do Driver PostgreSQL do ODBC: 5.0
  • Client Oracle 11g 32 bits versão 11.2.0.1.0.

Configuração da BDE:

Configuration |-- INIT |--- AUTO ODBC = FALSE |--- DATA REPOSITORY = |--- DEFAULT DRIVER = PARADOX |--- LANGDRIVER = Pdox ANSI Intl850 |--- LOCAL SHARE = FALSE |--- LOW MEMORY USAGE LIMIT = 128 |--- MAXBUFSIZE = 4096 |--- MAXFILEHANDLES = 2048 |--- MEMSIZE = 205 |--- MINBUFSIZE = 128 |--- MTS POOLING = FALSE |--- SHAREDMEMLOCATION = 5BDE |--- SHAREDMENSIZE = 4096 |--- SQLQRYMODE = |--- SYSFLAGS = 0 |--- VERION = 4.0 |- Drivers |-- Native |--- PARADOX |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = Pdox ANSI Intl850 |---- NET DIR = C:\ |---- BLOCK SIZE = 16384 |---- FILL FACTOR = 95 |---- LEVEL = 7 |---- STRINGINTEGRTY = TRUE |--- DBASE |---- VERSION = 4.0 |---- TYPE = FILE |---- LANGDRIVER = 'WEurope' ANSI |---- LEVEL = 25 |---- MDX BLOCK SIZE = 1024 |---- MEMO FILE BLOCK SIZE = 1024 |--- ORACLE |---- VERSION = 4.0 |---- TYPE = SERVER |---- DLL32 = SQLORA32.DLL |---- VENDOR INIT = oraclient11.dll |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- ENABLE BCD = FALSE |---- ENABLE INTEGERS = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- LIST SYNONYMS = NONE |---- MAX ROWS = -1 |---- NET PROTOCOL = TNS |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SERVER NAME = TOTALI |---- SQLPASSTHRU MODE = SHARED NOAUTOCOMMIT |---- SQLQRYMODE = SERVER |---- USER NAME = TOTALI |-- ODBC |--- PostgreSQL |---- VERSION = 5.0 |---- TYPE = SERVER |---- DLL = IDODBC01.DLL |---- DLL32 = IDODBC32.DLL |---- ODBC DRIVER = PostgreSQL |---- DRIVER FLAGS = |---- TRACE MODE = 0 |---- BATCH COUNT = 800 |---- BLOB SIZE = 999 |---- BLOBS TO CACHE = 8192 |---- DATABASE NAME = |---- ENABLE BCD = FALSE |---- ENABLE SCHEMA CACHE = FALSE |---- LANGDRIVER = |---- MAX ROWS = -1 |---- ODBC DSN = |---- OPEN MODE = READ/WRITE |---- ROWSET SIZE = 20 |---- SCHEMA CACHE DIR = |---- SCHEMA CACHE SIZE = 8 |---- SCHEMA CACHE TIME = -1 |---- SQLPASSTHRU MODE = SHARED AUTOCOMMIT |---- SQLQRYMODE = |---- USER NAME =

Configuração do ODBC:

Options >>> DataSource   Page 1 [X] Disable Genetic Optimizer [X] KSQO (Keyset Query Optimization) [X] Recognize Unique Indexes [_] Use Declare/Fetch [_] CommLog (C:\psqlodbc_xxxx.log) [_] Parse Statements [_] Cancel as FreeStmt (Exp) [_] MyLog (C:\mylog_xxxx.log)   Unknown Sizes (_) Maximum (_) Don't Know (o) Longest   Data Type Options [_] Text as LongVarChar [_] Unknows as LongVarChar [_] Bools as Char   Miscellanous Max Varchar = 4000 Max LongVarChar = 4000 Cache Size = 100 SysTable Prefixes = dd_;   Page 2 [_] Read Only [_] Show System Tables [X] LF <-> CR/LF conversion [X] Updatable Cursors [_] Row Versioning [_] Disallow Premature [_] True is -1   Int8 As (_) default (o) bigint (_) numeric (_) varchar (_) double (_) int4   Protocol (o) 7.X,6.4+ (_) 6.3 (_) 6.2   OID Options [_] Show Column   Connect Settings =

Data que Configuração foi Realizada: 27/04/2021
Por Quem: Rhuan Ricardo Cattoni
Observações da configuração:
Com essas configurações abri um Backoffice, um Delivery e um Order e não ocorreu nenhum erro de BDE.

Como Obter os Dados ​

Dados da Máquina ​

Dados da máquina devem ser obtidos na ferramenta Sistema do Painel de Controles do Windows.

Bde-1-sistema.png

Dados da BDE ​

Versão da BDE pode ser obtido do BDE Information, normalmente, acessível pelo menu Iniciar.

Bde-2-information-utility.png

Se não tiver, copie o arquivo BDEinfo para a mesma pasta onde está instalada a BDE (pasta onde está o arquivo IDAPI32.CFG).

\\ttadm\Instaladores\BDE\BDEinfo.exe

Dados do ODBC ​

Versão do driver PostgreSQL do ODBC: 4.0

Bde-3-odbc-driver-pg.png