To install 64Bit Datasources in 64Bit ODBC you neet to setup the oracle 64 Bit ODBC drivers.
Look for “oracle odbc driver for windows 64”.
But CLARION 8 is an 32Bit application and will work with the 32Bit ODBC setup. This is also true for the output targets (the exe-files). So it makes sense to setup your 32Bit ORACLE ODBC datasource, import the required tables to the Clarion dictionary manager and generate your app(s).
In addition to my first reply: Since you see the ORA-12154 the ODBC driver setup seems OK but the database service of your database is not defined in the file “tnsnames.ora”. There are other methods to define the target database service but “tnsnames.ora” is a common way. Are you able to locate and understanding to use tnsnames.ora? Do you have done the setup of the ORACLE client? There are plenty informations to setup the client (known as “ORACLE INSTANT CLIENT”).
There are also settings in the windows environment to define the default language, admin folder (where to look after tnsnames.ora and sqlnet.ora). If using LDAP there has to be a LDAP.ORA to define where to look after the LDAP server(s).