Error code-20002

[kumarravik]

Hi Team,

I have set up the Team developer4.2 . but when I am trying to logging in my application it showing an error message "Error - OCI_INVALID_HANDLE" , " 0133 SQL IVE ERROR 20002 NOT FOUND IN ERROR.SQL" . error code is "20002" . please guide me.

Regards:
Ravi

[Jeff Luther]

FYI, I have moved this msg. from General Discussion to this section, Ravi, since it is a TD v4.2-related issue.


2002 -- I recommend you do a google search for help, I did so and find a couple things about Oracle.

As to what you report, there isn't enough info., so a few Q's for you:
* What's the DB for connecting? Oracle?
* Did you modify TD SQL.INI to enable connecting to your DB server brand/
* "Logging" sounds like what 20002 might be: Invalid user name

We'll need more info. for this. If Oracle is the DB, then these INI sections should look at least like this:
[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
; comdll=sqlsyb32
comdll=sqlora32
comdll=sqlodb32
comdll=sqlws32

[oragtwy]
; sample declaring remote Oracle DB for connecting
remotedbname=ora10g,@tns:ora10db

[kumarravik]

Hi Jeff,
I have edited the SQL.ini file. my DB is ORACLE (10g). do I need to mention the full path of my Oracle DB ? please spceify if I need to give the full path of ORACLE DB in SQL.ini file. like below :
remotedbname=ora10g,@D:\oracle\product\10.2.0\client_1\BIN

rest of things mentioned by you is fine.

Regards:
Ravi

[Jeff Luther]

RAVI -- take a look at the CCOD.PDF ebook shipped with the TD Books. That has setup/connect info. for Oracle and other DB brands TD supports.

do I need to mention the full path of my Oracle DB ?

"Path" = no, but that's here's in SQL.INI where you declare the DBs you have defined in your TSNAMES.ORA file:
[oragtwy]
; this is an example
remotedbname=ora10g,@tns:ora10db