Hi, ALL,
First, let me introduce myself. My name is Igor Korot and I’m a software developer.
I’m trying to write a program that connects to the Oracle DB thru the ODBC interface.
I made a VM on VirtualBox downloaded and installed the DB server, then downloaded instant client alone with the ODBC driver.
I then run the installer for ODBC.
I then start the DM. I can see that there is a driver is present and I can choose it, but trying to set up a connection fails.
During the install I chose to create a DB and I called it “draft”.
So in the DM after I click Add. I enter DSN name and for TNS name I entered “draft” (no quotes). I used “system” for UserID and click OK.
Then I clicked Test Connection and I got an error : TNS: could not resolve the connect identifier specifier
The VM is running Windows 10. .
So now the question is - how to configure the DSN for Oracle database?
Thank you.