Technical Failure Management and Root Cause Prediction with an Expert System

General
31

Oracle ODBC driver: notes, which links to downloads.

Once installed, the DSN needs to be set up, within the Oracle ODBC driver. And then referenced, as the first argument in odbc_connect/3.

32

First step is typically to make sure you can connect using the commandline tools that come with the ODBC connector. For non-Windows, that is typically UnixODBC and the commandline tool is isql. Once you have the DSN setup correctly connecting from Prolog is typically easy.

33

By using the debug-predicat I found out that the password also has to be quotet - and after a while I was able to send a first query to my database. :grinning_face: Perhaps I should came up with the complete manual to get in contact with a Oracle database from a windows system. .

image
image999×202 43.2 KB

34

Yes. Small tip: use double quotes to create a Prolog string for passwords. Prolog atoms are global resources that can be enumerated using current_atom/1. That can be a security risk (depending on how users interact with the software).