Hi, How to connect the ORACLE

[unirams]

Hi,

How to connect the ORACLE database available in UNIX platform through 32bits ODBC for Windows. Actually, i am going to do the project in VB, but the database is already available in ORACLE under Unix. Just i want to make the connection established to that database (under unix) from my program in VB (ODBC Connectivity calls). Please let me know how do i connect to oracle under unix using ODBC.

Thanks in Advance

Regards,
Ram

 

[bloke]

Hi There,

You need an Oracle ODBC driver AND the Oracle SQLNET
installed on the client. The ODBC driver is usually
on the SQLNET install disk. Once SQLNET is installed,
set up your tnsnames to be the same as that of you Unix
host. The ODBC connection is then the same as any other.

tnsnames goes under your install directory\network\admin

Regards

Chris

 

[unirams]

Hi Chris,

Thanks for your response. I am little bit beginner to these types of programming. Can you explain me in depth.

Thanks again

Regards,
Ram

 

[bloke]

Hi Ram,

I will put something together tomorrow in detail. Is that
OK.

Regards

Chris

 

[varnit]

hi raam..

u can try this connection..

dim cn as adodb.connection

set cn = new adodb.connection
cn.provider="msdaora.1"
cn.open "server","scott","tiger"

where... "server" is ur oracle server connection string..

but i ve never tried on a unix server... this is the connection available for windows platform...
u can try it on unix also..

regards..

Varnit Good Luck
Varnit