a*****a 发帖数: 438 | 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**s 发帖数: 16 | 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*****a 发帖数: 438 | 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.
|
|