help! oracle8i client installation on Windows2000/NT4 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

help! oracle8i client installation on Windows2000/NT4

help! oracle8i client installation on Windows2000/NT4# Database - 数据库

a*a2000-09-15 07:09

1 楼

*pulling my hair* how should I configure this Oracle8i
client on a win2000 pro/NT4 workstation?
I installed oracle client 8.1.6 for app user and run net8
configure agent to set up a listener. Using Oracle ODBC test
works without any problem - *but*, when I switched to use
"Microsoft OLEDB Provider for Oracle" or "Oracle Provider
for OLEDB", I always get the dreaded ORA-12514 error
TNSPING to my oracle8i server is okay. using sqlplus
scott/tiger also gives me the same error:(
oracle client setup

j*s2000-09-15 07:09

2 楼

Have you tried to configure using Tnsnames.ora file?
It's usually a better way.

【在 a*****a 的大作中提到】

: *pulling my hair* how should I configure this Oracle8i
: client on a win2000 pro/NT4 workstation?
: I installed oracle client 8.1.6 for app user and run net8
: configure agent to set up a listener. Using Oracle ODBC test
: works without any problem - *but*, when I switched to use
: "Microsoft OLEDB Provider for Oracle" or "Oracle Provider
: for OLEDB", I always get the dreaded ORA-12514 error
: TNSPING to my oracle8i server is okay. using sqlplus
: scott/tiger also gives me the same error:(
: oracle client setup

a*a2000-09-15 07:09

3 楼

problem solved. it's not installation problem.
The real problem is, in the data link dialog when I am
prompted to enter a 'server name', it's actually expecting
the 'service name'!
thanks anyway.

【在 j**s 的大作中提到】

: Have you tried to configure using Tnsnames.ora file?
: It's usually a better way.