This will add the 'Exinda SQL Database' to the list of available data sources that can be used by 3rd party applications on this client. Setup ODBC top Setup the Oracle instant client OCI drivers: Install the latest Oracle ODBC drivers: Open the 64 bit ODBC Administrator: Open the System. Here is what a successful configuration looks like:Ĭlick OK. If the connection attempt is successful, the 'Database' drop down will be populated with a list of available databases. To install with Japanese language support, execute the command odbcinstall.exe JA. If Instant Client is 11g or lower, start the command prompt with the Administrator privilege. Execute odbcinstall.exe from the Instant Client directory. Unzip it in the same directory as your Basic or Basic Light package. So after debugging lots of hours i finally able to. Once the above fields are configured, press the 'Test' button. Download the Instant Client ODBC package. I was also stuck with the MongoDB ODBC connector for windows and did not find any help over the internet. Extract the contents of all the above into a single directory called D:OracleOra11. 'Exinda SQL Database'.Įnter the IP Internet protocol address of the Exinda appliance.Įnter the username you specified when enabling SQL access on the Exinda appliance.Įnter the password you specified when enabling SQL access on the Exinda appliance. First you need to download all three of these files from oracle. You will be prompted to enter details about the SQL access using the form below:Įnter a descriptive name for the DSN.