I would like to use the ODBC driver for Oracle (to test a C++ programme) however I have only installed O8i.
What are the steps I need to go through in order to create a connect with a service name (is this the SID?) User name and the password. I have tried the defaults and I have tried the Configuration Assistant. I was not confident enough to edit the tnsnames.ora file ( I realize their should be one for the machine and one for each user).

So do I have to just make a TNSNAmes.ora file for an ODBC connection? What does all the info in the Oracle ODBC Driver really mean?. I am running the database (server) and the client on the same machine. Please help me get started.