Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle for odbc error
There seems to be some confusion on which database server you use. The ODBCdriver is suitable for an Oracle Rdb database (probably on an Open VMS machine). You need a server process on the Open VMS node called SQLSERVICES
to connect to an Rdb-database via ODBC.
From Rdb r 7.0 it is possible to make an SQLnet-connection to the Rdb-database. This also requires SQL SERVICES on VMS. SQL*Plus can work via SQL*net directly on SQL-services without the ODBC-driver for Rdb.
If you want to connect via ODBC to an Oracle 7 Server -database, you should use the Oracle7 ODBC-driver.
If you need further help, please be accurate and complete on the information on used DBMS and OS.
regards,
Guus van de Sande
independent Oracle Consultant.
Someone in Sky <hsho_at_cse.cuhk.edu.hk> schreef in artikel
<6de3pt$gcl_at_eng-ser1.erg.cuhk.edu.hk>...
> Hi all,
> I have installed "Oracle ODBC Driver for Rdb 2.0.20.0.0","sql*plus
> 3.3.2.0.2" and sql*net 2.3.2.1.6A".
>
> I can access the server by using sql*plus.But,
> When I used "Oracle ODBC Test" Application to test Oracle ODBC driver, I
> failed to connect to oracle server(7.2.3.0.0). The error code is:
>
> SQLSTATE: S1000
> Native Error Code:-2003
> Driver Message:[Oracle][ODBC][Rbd]
> Connect Ret 0 Err#10061 WSAECONNREFUSED
> Connection Refused.
>
> Can you help me to solve above problem as I want to connect the oracle
server
> by using VC++?
>
> Thanks for your help!
> --
>
> Sam
>
Received on Mon Mar 02 1998 - 00:00:00 CST