Configuration issue with Team Developer while connecting

[kirakala]

Hi,

I am trying to connect to my oracle database from TeamDeveloper 5.2, but it is giving me the following error. I am pasting my sql.ini and tnsnames.ora below. Please help us to resolve this issue.


Error
-------------------------------------------------
Reason: FOR SQLBASE: The specified database cannot be found. SQLBase
cannot find the file named "x:\dbdir\dbname\dbname.DBS" where
x:\dbdir is either the default, c:\SQLBASE, or modified with
the DBDIR SQL.INI configuration keyword. In a multiuser
network configuration, this error indicates that your network
is working correctly, but the database system was unable to
locate the specified database filename.

FOR NON-SQLBASE DATABASES: This problem can also occur with a
SQLGateway when leaving out the protocol type in the SERVERNAME
parameter that the client uses to communicate with the gateway
(like SQLNBIOS). For example,

SERVERNAME=SERVER33,SQLQUEUE
DBNAME=DB2DBMS, SQLQUEUE, SQLNBIOS

will nott allow a remote client process (using SQLNBIOS on the LAN
to communicate with the SQLGateway machine) to connect to the
SQLGateway machine.

For SPX connectivity from DOS or MS Windows to a Unixware
SQLBase Server check for the omission of the "serverpath=..."
parameter in the SQL.INI file under the client section.

------------------------------------
My SQL.ini file is shown below
----------------------------------
[win32client]
clientname=User

[win32client.dll]
comdll=sqlora32
comdll=sqlws32
comdll=sqlodb32

[win32client.ws32]
serverpath=server1,hp-con-sdg3,2155/teamrepo

[odbcrtr]
odbctrace=off
odbctracefile=sql.log
ferslong=off
longbuffer=8000


[oragtwy]
remotedbname=integloc,@tns:integloc
remotedbname=vmfgloc,@tns:vmfgloc
remotedbname=integra,@tns:integra
remotedbname=intgtest,@tns:intgtest
remotedbname=ref,@tns:ref
remotedbname=reftest,@tns:reftest
remotedbname=edp,@tns:edp
remotedbname=edptest,@tns:edptest




; Substitutions currently needed by VISUAL Mfg
; NOTE: The first four lines must precede the other substitutions
; (specifically, they must precede the other @DATEVALUE substitutions)
;nodefparse=no
longbuffer=64000
fetchrow=20
maperror=OFF
substitute=@DATEVALUE(''),TO_DATE(NULL)
substitute=@datevalue(''),TO_DATE(NULL)
substitute=@DATEVALUE(NULL),TO_DATE(NULL)
substitute=@datevalue(NULL),TO_DATE(NULL)
substitute=@DECODE,DECODE
substitute=@DATEVALUE,TRUNC
substitute=@ROUND,ROUND
substitute=@round,ROUND
substitute=@NULLVALUE,NVL
substitute=@TRIM,RTRIM
substitute=@VALUE,TO_NUMBER
substitute=@LENGTH,LENGTHB
substitute=@SDV,STDDEV
substitute=@upper,UPPER
substitute=@UPPER,UPPER
substitute=@left,LPAD
substitute=@LEFT,LPAD
substitute=@SCAN,INSTR
substitute=@scan,INSTR
substitute=@PROPER,INITCAP
substitute=@proper,INITCAP
substitute=SYSSQL.,
substitute=SYSADM.,
substitute=SYSUSERAUTH,SYS.USER$
substitute=@decode,DECODE
substitute=@datevalue,TRUNC
substitute=@nullvalue,NVL
substitute=@trim,RTRIM
substitute=@value,TO_NUMBER
substitute=@length,LENGTHB
substitute=@sdv,STDDEV
substitute=syssql.,
substitute=sysuserauth,SYS.USER$
substitute=sysadm.,
substitute=SYSDATETIME,SYSDATE
substitute=sysdatetime,SYSDATE

---------------------------------------------
and tnsnames.ora is shown below
-----------------------------
# tnsnames.ora Network Configuration File: d:\oracle\ora11gr2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_INTEGLOC =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


REF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ref)
(SERVER = DEDICATED)
)
)

INTGTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-sdg3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = intgtest)
(SERVER = DEDICATED)
)
)

VMFGLOC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vmfgloc)
)
)

LISTENER_VMFGLOC =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


INTEGLOC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = integloc)
)
)

EDPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-sdg3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = edptest)
(SERVER = DEDICATED)
)
)

INTEGRA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-integra)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = integora)
(SERVER = DEDICATED)
)
)

EDP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = edp)
(SERVER = DEDICATED)
)
)

REFTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-con-sdg3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = reftest)
(SERVER = DEDICATED)
)
)

[Jeff Luther]

Looks like the problem is with your [win32client.dll] section. Here's a note I have in my SQL.INI file:
[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=sqlora32
; comdll=sqlsyb32
; comdll=sqlodb32
comdll=sqlws32

Thus, I think your win32client listing should be in this order:
[win32client.dll]
comdll=sqlora32
; odb32 should be 2nd to the last
comdll=sqlodb32
; ws32 must be listed last
comdll=sqlws32


It is possible there's another issue as well, since you don't show what the Oracle DB name is. But, try the change to win32client first and that. you can use SQLTalk to test the connection.

[kirakala]

Hi Jeff,

Thanks for the reply. can you help me out where are I need to specify the oracle db name ?

[kirakala]

Hi Jeff,

Thanks for the reply. Where I need to specify the Oracle DB name ?

Thanks
Karthik

[Jeff Luther]

Oracle DB Name + parameters are specified in the Oracle tnsnames.ora file, like this example entry:
ORACLE10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host DB name>) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=oracle10g)
(SERVER=DEDICATED)
)
)


Then in your SQL.INI file, this entry ties your TD app or SQLTalk to that entry:
oragtwy]
; ...
;remotedbname=oracle10g,@tns:oracle10g

You will want to see the TD book ccod.pdf for details about Oracle and other DBs.

[FRBhote]

I'm having a similar problem. Sqltalk connects, but when I do a select it hangs and I have to end task. Sqlplus connects and works ok.

Would appreciate any help.

The sql.ini is:

Code: Select all

[win32client]
clientname=frbctd

[win32client.dll]
comdll=sqlora32
comdll=sqlodb32
comdll=sqlws32
;comdll=sqlwsspx

[win32client.apipe]
;debug=15,client.dbg

[win32client.ws32]

serverpath=server1,192.168.1.10/*

[win32client.spx32]
[win32client.ntnbi]


[oragtwy]
remotedbname=LKP1,@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521))(CONNECT_DATA=(SID=LKP1)))