我用sqlplus system/manager@Test可以连接,说明tns配置应该没有问题
但我用odbc连接时却不行,不知道大家有没有遇到过?
;
;odbc.ini
;
[ODBC Data Sources]
Test = OpenLink32[Test]
Driver = /usr/local/lib/ora90_mt_lt.so
Server = 168.192.1.222
SID = Test
ServerType = Oracle 9.x
Username = system
Password = manager
Database = Test
Options =
FetchBufferSize = 99
ReadOnly = no
DeferLongFetch = no
JetFix = no
Description = Sample Oracle 9.x Lite Connection;
;odbcinst.ini
;
[ODBC Drivers]
OpenLink Oracle 9.x Lite Driver = Installed
OpenLink Oracle 9.x Lite Driver (multi threaded) = Installed
OpenLink Oracle 9.x Lite Driver (Unicode) = Installed
OpenLink Oracle 9.x Lite Driver (Unicode)(multi threaded) = Installed[OpenLink Oracle 9.x Lite Driver]
Driver = /usr/local/lib/ora90_st_lt.so[OpenLink Oracle 9.x Lite Driver (multi threaded)]
Driver = /usr/local/lib/ora90_mt_lt.so[OpenLink Oracle 9.x Lite Driver (Unicode)]
Driver = /usr/local/lib/ora90_st_lu.so[OpenLink Oracle 9.x Lite Driver (Unicode)(multi threaded)]
Driver = /usr/local/lib/ora90_mt_lu.so
但我用odbc连接时却不行,不知道大家有没有遇到过?
;
;odbc.ini
;
[ODBC Data Sources]
Test = OpenLink32[Test]
Driver = /usr/local/lib/ora90_mt_lt.so
Server = 168.192.1.222
SID = Test
ServerType = Oracle 9.x
Username = system
Password = manager
Database = Test
Options =
FetchBufferSize = 99
ReadOnly = no
DeferLongFetch = no
JetFix = no
Description = Sample Oracle 9.x Lite Connection;
;odbcinst.ini
;
[ODBC Drivers]
OpenLink Oracle 9.x Lite Driver = Installed
OpenLink Oracle 9.x Lite Driver (multi threaded) = Installed
OpenLink Oracle 9.x Lite Driver (Unicode) = Installed
OpenLink Oracle 9.x Lite Driver (Unicode)(multi threaded) = Installed[OpenLink Oracle 9.x Lite Driver]
Driver = /usr/local/lib/ora90_st_lt.so[OpenLink Oracle 9.x Lite Driver (multi threaded)]
Driver = /usr/local/lib/ora90_mt_lt.so[OpenLink Oracle 9.x Lite Driver (Unicode)]
Driver = /usr/local/lib/ora90_st_lu.so[OpenLink Oracle 9.x Lite Driver (Unicode)(multi threaded)]
Driver = /usr/local/lib/ora90_mt_lu.so
我的iodbc使用的是single tier所以不行