An error is: the ORA - 12154: TNS: unable to process the service name

Through up sqlplus can connected to the data, through PLSQL can be connected, but through the program is even not, find reason, hope to here, put on all my points

Before can normal connection, found that even not after reshipment system, reshipment twice already

Now system is a 64 - bit database is ORACLE10 32-bit system

Application of the connection string as follows:
Data Source=(DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=* * * * * * * * *) (1521) PORT=) (CONNECT_DATA=https://bbs.csdn.net/topics/(=DEDICATED SERVER (SID=oracle9))); User Id=* * * * *; Password=* * * * *;

Development program is written by c #,

The following tnsname.org
Oracle9=
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=* * * * * * * * * * *) (1521) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=oracle9)
)
)

Please see great god to find reasons

CodePudding user response:

1, check the path, look to whether have two path, whether the tnsname. Ora under the correct path
2, the tnsname. Ora configuration is completed, tnsping oracle9, look to whether unicom
3, c # application can directly reference configured oracle9 the servername

CodePudding user response:

Vs tools to connect to the database, in an interview there can see ~ or you want to install the ODBC connection

CodePudding user response:

Compile time selected target CPU for X64

CodePudding user response:

There is something wrong with the connection string, in the middle can't Spaces,
Data Source to the DataSource
Try again ~