Help with connection to Oracle
Posted on 2000-05-03
Our company has been using Oracle (version 7.3) on a Unix Platform (sun) with an old 4GL language through a telenet session providing a character based application. I want to move toward a different front end and am thinking VB is the answer using ActiveX. Unfortunately I am having trouble connecting to the Oracle database. I have installed Oracle Net and tried setting up a System DSN using Microsoft ODBC Driver for Oracle, but am not sure if I set it up correctly. I have filled it out as follows: Data Source Name - MYDEV (this is the alias is used in setting up Oracle Net), Description MY DEV, User name dev (this is the the name of my Oracle Database), Connect string sun1 (Wasn't sure what to put here. This is the system name that Oracle resides on). When I try and use Oracle NetTest to see if I am connected it always fails. Any help would be appreciated.