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).
More informations are found at the ORACLE web pages concerning to ORACLE INSTANT CLIENT.
A robust and faster way to connect to ORACLE DB services as ODBC is the OCI (Oracle Call Interface), part of the instant client - but you need the clarion oracle driver.
If the Oracle-Server is on another machine, than change the above “localhost” to the oracle sever IP adress e.g. 192.168.1.200
And the connection string for Clarion is:
GLO:dbOwner=‘erpsyn/[email protected]’
As far as I know, on a remote client you also have to setup a LISTENER - there is an oracle tool in your installation (Net-Configuration assistant) to create that.