1.为mysql 建立odbc的时候需要下个Mysql ODBC 3.51 Driver插件
很简单的,首先配一个odbc别名:
控制面版->管理工具->数据源(odbc)->添加->Mysql ODBC 3.51 Driver->Data Source Name就是别名->Server为你MYSQL服务器名,如果是本地,为localhost,下面就是用户名/密码/数据库名 就OK了
2、TNS_ADMIN is an environment variable that points to the directory where the SQL*Net configuration files (like sqlnet.ora and tnsnames.ora) are located.
configure environment variable :
TNS_ADMIN=======D:/Oracle //指向ora文件指向的目录
tnsnames.ora:
# Generated by Oracle configuration tools.
PORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 119.119.115.167)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PORA)
(SERVER = DEDICATED)
)
)