[2005] get the details of the Oracle10g

[mmary]

hi to all,
i need to find the details of the table(column name and the datatype). how can i find that?. plz help me to solve the problem .i am using Oledb Connection for oracle. when i am using the oracle connection, it giving the error "ORA-12154 TNS: could not resolve the connect identifier specified".
thank u

with thanks and regards
mmary

[jmcilhinney]

Call the GetSchema method of your connection object, whatever type it may be.

[mmary]

hi to all, plz somebody help me to solve the problem in getting the details of the Oracle table and also help me to solve the establishing the oracleconnection. plz somebody help me.

thank u.
with thanks and regards
mmary

[mmary]

thank u for ur kind reply. plz somebody help me solve these problems

with thanks and regards
mmary

[GaryMazzone]

Acouple of thngs here. First Orcle client software must be installed on the machine (If the DB was installed ther then client was also installed.). Next an entry in the TNSNames file must be made for the database. This can be con manually but I would not recommed this if you are not compltely fluent (please forgive my spelling), use then tools installed with the client installation (the net configuration assisant).

Next look at this the database section FAQ's for a post I made about Orqcle and VB (both 6 and .Net the thread is : http://www.vbforums.com/showthread.php?t=393457)

Next Look at post in thread http://www.vbforums.com/showthread.php?t=459103 Look at post number 18 I supplied a method for getting table information to you in that thead. I also sent you a PM about it.