Hi
I must to connect in database oracle ,different database are in same Server (same IP) , but with different SID(Data source) , see tnsname below
, I tried to connect using in VB
See my connectstring
Code:Provider=MSDAORA.1;Password="mypass";User ID=user1;Data Source=islq;Persist Security Info=True
work fine , but when use
Code:Provider=MSDAORA.1;Password="mypass";User ID=user1;Data Source=lbpiq;Persist Security Info=True
Not work
my tnsnames.ora
PHP Code:islq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.176.13.25)(PORT = 1548))
)
(CONNECT_DATA =
(SID = islq)
(SERVER = DEDICATED)
)
)
islp.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.176.13.31)(PORT = 1558))
)
(CONNECT_DATA =
(SID = islp)
(SERVER = DEDICATED)
)
)
lbpiq.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.176.13.25)(PORT = 1545))
)
(CONNECT_DATA =
(SID = lbpiq)
(SERVER = DEDICATED)
)
)
lbpiq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.176.13.25)(PORT = 1545))
)
(CONNECT_DATA =
(SID = lbpiq)
(SERVER = DEDICATED)
)
)
Using external tools (PLSQL DEVELOPER, TOAD ...ETC ) work fine boths connections using same user and password ( user1 and mypass)
Is there some other way to connect , using IP and PORT ?
Tia




Reply With Quote