Fog Creek Software
Discussion Board




connection to the database server

Am unable to ge the connection to the oracle database server. The return value to the SQLOpen()  method is '-1' .
The following steps have been written to get the connection

Dim connection as long
connection = SQLOpen("DSN=KRQA")

swarna
Monday, February 23, 2004

Did you try to tnsping your remote oracle database to see
if the Oracle Net8 client works, and the tnsnames.ora file is properly configured.

ODBC lives ontop of Net8, so thats where I would start.

Patrik
Monday, February 23, 2004

checked the tnsping utility and the tnsnames.ora file but the problem is same

swarna
Tuesday, February 24, 2004

swarna, surprised you picked here to get debugging help instead of www.experts-exchange.com. :)

Li-fan Chen
Tuesday, February 24, 2004

*  Recent Topics

*  Fog Creek Home