>Hi BOB.
>
>I found out your name exploring messages, I suppose that your are user of VFP and ORACLE.
>
>I have the following problem.
>
>There are 3 sessions open VFP 5.0 in the same workstation running a program that access ORACLE tables in a NETWARE server.
>
>When I close the sessions(outside VFP), I lose future connections to the oracle listener TNSLSNR (sql*net v2) from my workstation and any workstation in the network.
>
>CLIENT ENVIRONMENT :
>WIN95
>VFP 5.0
>ORACLE ODBC DLL’S OBTAINED FROM
WWW.ORACLE.COM>OCI 7 2 2 3 1
>SPX ADAPTER 2 3 2 1 3
>ODBC DRIVER 1 13 5 0 04
>RSF 7 2 2 3 1
>SQL ADD ON 2 2 2 1 0
>
>SERVER ENVIRONMENT:
>Novell v3.12
>ISA-Bus Ethernet Adapter v4.03 (951108)
>NetWare 3.11 Forward Compatibility Support v3.0.5
>NetWare 386 Console Monitor
>NetWare 386 Remote Console
>NetWare 386 Remote Console SPX Driver
>NetWare C NLM Runtime Library V3.12
>NetWare C NLM Runtime Math Library (387 Support) V3.12
>NetWare Direct File System Interface
>NetWare ISA Device Driver
>NetWare OS Loader
>NetWare Server Operating System
>NetWare SPX STREAMS Driver
>NetWare STREAMS
>NetWare Transport Level Interface Library
>Network Management NLM
>Novell Ethernet Topology Specific Module
>Novell Generic Media Support Module
>Oracle Bequeath Protocol Adapter v2.1.3.0.2 - Production
>Oracle CORE v3.0.10.1.1
>Oracle Driver for NetWare v7.1.3.3.1
>Oracle SPX Protocol Adapter v2.1.3.0.2 - Production
>Oracle SQL*Net V2 Driver v2.1.3.0.2 - Production
>Oracle SQL*Net V2 TNS Library v2.1.3.0.2 - Production
>Oracle TNS Listener v2.1.3.0.3 - Production
>
>The ORACLE response codes are ORA-12545 (TNS LookUp Name Failure, ora ORA-12203
>
>Other problem is when the SQL sentence into the SQLEXEC statement produce an error ORA-xxxx you can not continue the processing of the aplication with the same handel connection (odbc), in my case I must disconnect from oracle and reconnect again losing the transaction,
>It is really ???.
>
>I appreciate if you could help in this topics.
>
>By the way if you Known other people that are using VFP and ORACLE, please tell me their names to contact with them.
>
>Thank you in advance.
>DAVID.
I wish I could help, but I use Informix and I am only really familiar with the VFP side of the connection. Sorry.
Bob
Bob Tracy
Never engage in a battle of wits if you're only half armed.