oracle11g - Delphi XE2 with Zeoslib and Oracle Connection -


can me in setting zeoslib 7.1.4a connect oracle 11g release 2 standard database.

currently using delphi xe2, oracle installed , tnsnames.ora file specifies connections our different servers , databases, , set within bde.

we need move away bde components no longer available delphi xe3 , upwards. use direct oracle access components, paid 3rd party software, why want move on zeoslib.

what settings need set on zconnection component in order connect oracle database, there database parameter , librarylocation parameter looking actual files, , there hostname parameter?

i never used oracle, don't think should different firebird, mysql, sql server , others i've tried on zeos.

the properties need set are:

  • protocol = oracle;
  • hostname = database server ip best bet; maybe don't need oracle due tnsnames... try leaving empty
  • database = database name. filename (in server) or database alias;
  • user = user name connect database;
  • password = well, password...

librarylocation location of client-side library (a dll) use connection. don't need set property if library installed system folder or comes along executable.

you may need set port if it's not default one.


Comments

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

javascript - Complex json ng-repeat -

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -