vb6 and oracle server

I am bit of a newbie to VB6 and need help connecting to a remote Oracle server.

The servers name is swindon.city.ac.uk and is based at my university, i am able
to connect to it normally using telnet, which takes me to a Unix server, where oracle
must then be added in using the commands

module add oracle8

sqlplus /

If this makes any difference

The problem that i am having is that i am trying to use the ADODC to connect to the
database tables so that they can be displayed, edited, deleted etc in VB6, however i
am unable to get the connection string to connect to this remote server.

If anybody is able to help me i would be extremly gratefull. As i need this for an important
university project.

Thanks

Make sure you have oracle client files installed, this is the most common problem people have when trying to connect to an Oracle database with a VB application. Sometimes you need to set some system variables to run your vb application in to have access to those oracle files. Also, sometimes a file called tnsnames.ora is needed for this. In that file is a port and host defined where the connection has to be made on.


Hope this will get you on the road to your solution.