Re: usage of ODBC

Quinton Raj Yogeswaran Gregory (quintong_at_ifi.uio.no) wrote:

:*Does anyone have any ide about to connect oracle which
:*resides in unix maskin from pc by using ODBC.
:*
:*any comments will be appreciated.
 

:*Thanks in advance.
 

:* regards
:* Quinton Gregory.

I will assume you have installed your ODBC software properly and are having trouble connecting to your host. Go into your Control Panel and open the ODBC package. Select the Data Source(Driver) you set up to use for your connection to your host. Select the setup button and in the Network Address box enter the following.

        {net_prefix}:{hostname}:1024

        Select the help button in the ODBC Setup window for an explanation of what net_prefix and hostname mean. The 1024 is not documented in the help, this is the buffer size and the default is 4096, which if you allow the default to occur you will get a complaint from ODBC about the buffer size being mismatched or to large, I cannot remember the exact error message.

        We first set our host name to the name we have given the host but Oracle recommended we use the IP address. The network address we set was:

        T:{IP address}/1525:oracle:1024

The 1525 after the IP address was added by the recommendation of Oracle, I am sorry I cannot remember where that is set in the configuration of SQL Net or on the host, but I rember the tech support from Oracle saying it is standard.

Try this and if you have any more questions please feel free to ask.

Robert J. McCallister Received on Sat Mar 19 1994 - 16:24:34 CET