我的系统为：win2k svr oracle版本为8i安装ORACLE时我选用了最小安装用ODBC TEST测出如下错误： There is something wrong with the datasource you set up. Specifically, Oracle doesn't recognise the alias you placed in the "SQL*Net ConnectString" field of the datasource setup. Go to control panel-->ODBC32 Run the ODBC Administrator. In the list of datasources, double click on the datasource that is giving you trouble. Check out the "SQL*Net Connect String" field.If you intend to use Sqlnet version 2, this should be a single word with no prefix (for example "mydb") which corresponds to an alias located in \ORAWIN95\NETWORK\ADMIN\TNSNAMES.ORA or \ORANT\NETWORK\ADMIN\TNSNAMES.ORA that you set up using the "Sqlnet Easy Config" icon.Note that prefixes such as "x:" or "t:" should not be used unless you are using sqlnet v1.Before you proceed, this value you entered in the "SQL*NET Connect String" field should first be tested out using ORAWIN95\BIN\PLUS3X.EXE or \ORANT\BIN\PLUS3X.EXE or NETTEST.EXE or TNSPING.EXE. (Don't just run the icon for these programs -- you need to make sure you don't accidentally run a version of the program located in \ORAWIN\BIN which is 16 bit and will not help).Once one of these programs accept the alias, then ODBC applications using a datasource associated with that alias will too. If these programs also get the 12154, forget about ODBC for the time being and concentrate on setting up a sqlnet alias that works with one of these programs.If this suggestion does not fix the problem, please go to the ODBCTEST menu and click on HELP->'Advanced ODBC Debugging'.
There is something wrong with the datasource you set up. Specifically, Oracle doesn't recognise the alias you placed in the "SQL*Net ConnectString" field of the datasource setup. Go to control panel-->ODBC32 Run the ODBC Administrator. In the list of datasources, double click on the datasource that is giving you trouble. Check out the "SQL*Net Connect String" field.If you intend to use Sqlnet version 2, this should be a single word with no prefix (for example "mydb") which corresponds to an alias located in \ORAWIN95\NETWORK\ADMIN\TNSNAMES.ORA or \ORANT\NETWORK\ADMIN\TNSNAMES.ORA that you set up using the "Sqlnet Easy Config" icon.Note that prefixes such as "x:" or "t:" should not be used unless you are using sqlnet v1.Before you proceed, this value you entered in the "SQL*NET Connect String" field should first be tested out using ORAWIN95\BIN\PLUS3X.EXE or \ORANT\BIN\PLUS3X.EXE or NETTEST.EXE or TNSPING.EXE. (Don't just run the icon for these programs -- you need to make sure you don't accidentally run a version of the program located in \ORAWIN\BIN which is 16 bit and will not help).Once one of these programs accept the alias, then ODBC applications using a datasource associated with that alias will too. If these programs also get the 12154, forget about ODBC for the time being and concentrate on setting up a sqlnet alias that works with one of these programs.If this suggestion does not fix the problem, please go to the ODBCTEST menu and click on HELP->'Advanced ODBC Debugging'.