| generic connectivity [message #56528] |
Mon, 07 April 2003 02:05  |
Alexander
Messages: 109
Registered: May 2000
|
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
what's problem ?
Thanks
|
|
|
|
|
|
| Re: generic connectivity [message #167497 is a reply to message #56528] |
Thu, 13 April 2006 06:50  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| Alexander wrote on Mon, 07 April 2003 09:05 |
kol.SFTCOMP.RU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=sas1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = kol)
)
(HS = OK)
)
|
| Alexander wrote on Mon, 07 April 2003 09:05 |
I have create database link:
create database link link1
connect to m identified by m using 'kol'
|
Shouldn't that be : "connect to kol.SFTCOMP.RU"?
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
