Re: SQL*NET V2 & ODBC

Well I managed to make it work!

But here are a few things that caught me along the way :-

1. The TCP/IP protocol adapter installation manual intimates that the installer leads you by the hand to the next step of the installation - It doesn't -- But that's only a minor gripe.
2. Since I was installing at the end of a soggy piece of string
   (known as a PPP connection!) I found that the default CONNECT_TIMEOUT
   (10) on the server end was too short and needed to be increased to 50.
   After much analysis with tcpdump et.al. it seems that the units are CENTIseconds - not seconds as advertised. Thus 1/2 a second wait time for the first SQL*NET message on a new TCP/IP connection is reasonable.
3. Familiarity with tnsnames.ora/listener.ora is very useful before attempting to put together the full software stack on your PC. I did this by using SQL*NET V2 on my Un*x server ahead of time.

Apart from that it just works! All you need to do is set the ODBC connect string to <your database>.<your community> and away you go.

BTW: The initial release of the Oracle7 ODBC driver loses ~64k per fetch. I have a later release (V1.10.0001) from Oracle (UK) which seems much more friendly. Received on Thu Oct 06 1994 - 11:27:06 CET