Difference between revisions of "Oracle/es"
From Free Pascal wiki
Jump to navigationJump to search| Line 7: | Line 7: | ||
* '''oraclew''' contiene algunas rutinas para el interface Oracle, para un manejo más fácil del conjunto resultante. Necesita la unidad classes del FCL. | * '''oraclew''' contiene algunas rutinas para el interface Oracle, para un manejo más fácil del conjunto resultante. Necesita la unidad classes del FCL. | ||
* '''test01''' es un simple programa para demostrar la interface. | * '''test01''' es un simple programa para demostrar la interface. | ||
| + | |||
| + | == OOP access to Oracle == | ||
| + | Built over the low-level interface, the SQLDB framework supplied with FPC supports accessing Oracle (using TOracleConnection); see also [[Lazarus_Database_Overview#Lazarus_and_Oracle]] | ||
| + | |||
| + | Lazarus also has a component: | ||
| + | |||
| + | [[Image:sqldbcomponents.png]] | ||
| + | |||
| + | * Hostname: as with other sqldb connectors, use hostname or IP address. Leave empty if you use a TNSNAMES.ORA net service name in DatabaseName | ||
| + | * Username/password: same as with other sqldb connectors | ||
| + | * DatabaseName: | ||
| + | ** instance/SID of the Oracle server you want to connect to '''or''' | ||
| + | ** net service name in a TNSNAMES.ORA file | ||
| + | |||
| + | {{Note|Released FPC/Lazarus x64 versions on Windows do not include an Oracle connector. If you enable it and test successfully, please submit a patch with the changes so it can be included}} | ||
Revision as of 11:36, 7 May 2015
Interface de bajo nivel del Servidor de BBDD Oracle
La interface de bajo nivel al servidor de BB.DD de Oracle existe en una unidad, oraoci, la cual es una traducción directa de los ficheros de cabecera del interface Oracle.
Hay dos programas de ejemplo:
- oraclew contiene algunas rutinas para el interface Oracle, para un manejo más fácil del conjunto resultante. Necesita la unidad classes del FCL.
- test01 es un simple programa para demostrar la interface.
OOP access to Oracle
Built over the low-level interface, the SQLDB framework supplied with FPC supports accessing Oracle (using TOracleConnection); see also Lazarus_Database_Overview#Lazarus_and_Oracle
Lazarus also has a component:
- Hostname: as with other sqldb connectors, use hostname or IP address. Leave empty if you use a TNSNAMES.ORA net service name in DatabaseName
- Username/password: same as with other sqldb connectors
- DatabaseName:
- instance/SID of the Oracle server you want to connect to or
- net service name in a TNSNAMES.ORA file
Nota: Released FPC/Lazarus x64 versions on Windows do not include an Oracle connector. If you enable it and test successfully, please submit a patch with the changes so it can be included