OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ora-12500

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12500 [message #66955]

Mon, 14 April 2003 08:54

Alex
Messages: 190
Registered: August 1999

Senior Member

Hi
I have problem in using generic connectivity
when connect to dbf.
Platform : Windows NT4; Oracle 9i release 9.01
entry in tnsnames.ora:
kol.SFTCOMP.RU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=sas1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = kol)
)
(HS = OK)
)

entry in listener.ora:
(SID_DESC =
(PROGRAM = hsodbc)
(ORACLE_HOME = d:ORANTBIN)
(SID_NAME = kol)
)

odbc driver - Microsoft FoxPro VFP Driver
DSN - dbf_kolen

odbc agent inifile (file name - initkol.ora):
HS_FDS_CONNECT_INFO = dbf_kolen
HS_FDS_TRACE_LEVEL = ON

dbf files locates on server host

I have create database link:
create database link link1
connect to m identified by m using 'kol'

when i try to execute test sql statement
select count(*) from table1@link1
I receive error : ora-12500

why ?

Thanks

Report message to a moderator

Previous Topic:	I want to restrict the ORACLE USER by IP address?Can Anybody Help Me(URGETN)
Next Topic:	ado oracle remote connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 12:05:45 CST 2024