Re: ODBC how to get connection

You appear to be using the "Oracle ODBC Driver for RDB" instead of the "Oracle ODBC Driver for the Oracle7 Server". The drivers (and databases) are different.

To fix your problem, install the correct ODBC driver, and set up the parameters as you have below.

Attach statements are RDB's way of telling which database to connect to.

To be honest though, SQL*Net will be much more efficent to use than ODBC.

• Art Clarke aclarke_at_us.oracle.com

Daniel Poweleit (powi_at_horn-goerwitz.de) wrote:
> Hello World!
 

> I think i am quite experienced in developing application with forms throu
> sql*net, but now I need connection
> to my database via ODBC and I can't get any connections with 'ORACLE ODBC
> TEST' allways I get the
> errormessage :
 

> Driver Message:[Oracle][ODBC][Rdb] Connect Ret 0 Err #10061 WSAECONNREFUSED
> Connection refused
 

> Who can tell me how the ATTACHSTATEMENT has to be.
 

> Servername is : DBMS
> SID : ORCL
> Userid: Scott
> TNSALIAS : Textnt
 

> Thanks a lot in advance.
 

> --
> Daniel Poweleit from Berlin Germany

--