Page Comparison

...

Expand

title	PostgreSQL - ODBC

Connect to PostgreSQL with ODBC:

Set up the ODBC data source: PostgreSQL ODBC Setup
Use a component to connect to the database:

Code Block

language	lua

function main()
      local conn = db.connect{   
      api=db.POSTGRES,
      name='<your_odbc_server_name>',
      user='<your_login>',
      password='<secret>',
      use_unicode = true,
      live = true
   }
 
   conn:execute{sql='SELECT * FROM <your table>', live=true}
end

Expand

title	Oracle - ODBC, Oracle OCI (with TNS Alias, or Easy Connect, or ODBC)

Connect to Oracle with OCI (TNS Alias):

Set up the Oracle OCI drivers and create a TNS Alias: Oracle TNS Alias OCI Configuration
Use a component to connect to the database:

Code Block

language	lua

function main()
      local conn = db.connect{   
      api=db.ORACLE_OCI, 
      name='<Oracle OCI name>', -- Oracle tns_alias
      user='<your_login>', 
      password='<secret>',
      use_unicode = true,
      live = true
   }
 
   conn:execute{sql='SELECT * FROM <your table>', live=true}
end

Connect to Oracle with Easy Connect (EZConnect):

Set up the Oracle OCI drivers and EZConnect String: Oracle OCI Easy Connect String (EZCONNECT)
Use a component to connect to the database:

Code Block

language	lua

function main()
      local conn = db.connect{   
      api=db.ORACLE_OCI, 
      name='<Oracle EZCONNECT string>', --[//]host[:port][/service_name]
      user='<your_login>', 
      password='<secret>',
      use_unicode = true,
      live = true
   }
 
   conn:execute{sql='SELECT * FROM <your table>', live=true}
end

Connect with Oracle with ODBC:

Set up the Oracle OCI and ODBC drivers: Oracle ODBC Setup
Use a component to connect to the database:

Code Block

language	lua

function main()
      local conn = db.connect{   
      api=db.ORACLE_ODBC, 
      name='your_odbc_server_name',
      user='your_login',
      password='secret',
      use_unicode = true,
      live = true
   }
 
   conn:execute{sql='SELECT * FROM <your table>', live=true}
end

...

Versions Compared

Old Version 6

New Version 7

Key