/
Exemplos de conexão Oracle
Exemplos de conexão Oracle
- Tiago Alex dos Santos (Unlicensed)
- Ezequiel de Lima
Owned by Tiago Alex dos Santos (Unlicensed)
Conexão pelo Serviço do Oracle, normalmente usado no Oracle cloud devido instalação do client no ambiente.
[AGRO_IMPLANTACAO]
Database=TESTE
User_Name=VIASOFT
Password=
DriverName=DevartOracle
DriverUnit=DBXDevartOracle
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver210.bpl
MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver210.bpl
ProductName=DevartOracle
GetDriverFunc=getSQLDriverORA
LibraryName=dbexpoda40.dll
VendorLib=C:\app\client64\primedb\product\19.0.0\client_1\bin\oci.dll
MaxBlobSize=-1
LocaleCode=0000
Oracle TransIsolation=ReadCommitted
RoleName=Normal
LongStrings=True
EnableBCD=false
UseQuoteChar=False
CharLength=0
UseUnicode=False
UnicodeEnvironment=False
IPVersion=IPv4
BlobSize=-1
ErrorResourceFile=
HostName=
Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE"
Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL
Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'
Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
Conexão por SID, normalmente usado com instalação locais em Windows:
[AGROTITAN]
DriverName=DevartOracleDirect
Hostname=127.0.0.1:1521:ORCL2
RoleName=Normal
User_Name=VIASOFT
Password=
CharSet=WE8ISO8859P1
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Oracle TransIsolation=ReadCommitted
GetDriverFunc=getSQLDriverORADirect
LibraryName=dbexpoda40.dll
VendorLib=dbexpoda40.dll
EnableBCD=False
DriverUnit=DBXDevartOracle
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver240.bpl
MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver240.bpl
ProductName=DevartOracle
MaxBlobSize=-1
LongStrings=True
UseQuoteChar=False
CharLength=0
UseUnicode=False
UnicodeEnvironment=False
IPVersion=IPv4
Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE"
Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL
Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'
Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
Execute05=ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'MM/DD/RR HH24:MI:SSXFF'
Execute06=ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'MM/DD/YYYY HH24:MI:SSXFF TZR'
Conexão DF-e por SID, pode ser utilizado para a conexão do Server Agro também, caso a anterior não se adeque.
[IMPLANTACAO]
DriverName=DevartOracleDirect
Hostname=127.0.0.1:1521:ORCL
User_Name=VIASOFT
Password=330370080971721821921721821921721821921721821921721821921721821921721821921620580960470881921721821921721821921721821921721821921721821921721821921721720250
DriverUnit=DBXDevartOracle
GetDriverFunc=getSQLDriverORADirect
LibraryName=dbexpoda40.dll
VendorLib=C:\app\client64\PC\product\19.0.0\client_1\bin\oci.dll
BlobSize=-1
LocaleCode=0000
Oracle TransIsolation=ReadCommitted
ProductName=DevartOracle
IPVersion=IPv4
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver240.bpl
MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver240.bpl
CharSet=WE8ISO8859P1
ErrorResourceFile=
UnicodeEnvironment=False
UseQuoteChar=False
UseUnicode=False
EnableBCD=False
Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE"
Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL
Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'
Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'