Oracle conexion problem

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

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

Quote:

---

Originally Posted by mutley

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

---

Ummm.. what's the difference between those two connection strings? I don't see any difference. :confused:

okk.. So data source is changed. So have you checked that those two data sources are correct?

Have a look here:
http://www.connectionstrings.com/oracle

Maybe this helps.

Thank you I put in my Datasource

Code:

---

Source="(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =IPSERVER)(PORT = 1545)))(CONNECT_DATA=(SID = lbpiq)(SERVER = DEDICATED)))"

---

AND work , but is there other way ?, Because the DataSoruce is in INI file, and size max section in inifile is 20, then I musto change de code VB

I want to connect in same SERVER , but in different PORT