Re: connecting to Oracle/ODBC via winsock

In article <msains.417.2DF4808D_at_sunbird.ru.ac.za>, msains_at_sunbird.ru.ac.za (Malcolm Sainsbury) writes:

>We currently connect to an Oracle6 (and 7) database via ODBC, using
 the
>FTP Inc PC/TCP stack (Ver 2.03). This works well from windows using
 VB.
>
>We are currently investigating a change to the Trumpet Winsock stack
 and
>have successfully installed winsock and can use all the usual
 utilities like
>telnet, ftp, etc.
>
>However we are at a loss when it comes to the parameters to set in
 order
>to connect our working VB apps to the same Oracle6/7 database using
>WINSOCK this time. ie we know that winsock is working, and we know
 that
>our ODBC apps already work, but we cant make the connection with
 winsock.
>
>Would some kind soul please give us the benefit of his/her
 experience and let
>us know how to change the parameters in Windows/Oracle/ODBC to open
 this
>connection again.
>
>Thanks
>
>Malcolm

I believe that you may have to reinstall SQL*Net. Make sure that you install it to use the Winsock protocol stack. When you originally installed it with FTP's software, SQL*Net may have bypassed Winsock and hooked at a lower level with FTP's software. Anyway, try reinstalling SQL*Net.

Good luck,

Rick Received on Wed Jun 08 1994 - 05:29:01 CEST