I know, I know, you're probably saying not again, but please hear me out.
I'm trying to connect to an oracle database, to extract data and also update data using sql. I have tried searching throughout this forum and a few others but I am struggling with the 'language' which is sometimes used and references made which are too technical.
I currently connect to my databse using TOAD. In the connection properties I have a database, username, password. Connecting to Oracle Client 'OraDb10g_home1' which is a driver listed in my ODBC data sources. There is also TNSNames Editor which includes the database mentioned previously with Host & Port number.
I believe I have all the required information & setup but I am struggling to put it all togethar. Any help would be greatly appreciated.
I'm working on a project to automatically generate QTP function scripts to connect and interact with Oracle. If you send me the schema for your database, I'll try it out and send you the resulting script.