Make an tns-entry of the instance at the client machine in the file tnsnames.ora
Regards, Sonty On Aug 8, 12:00 pm, Karthikeyan R <karthi...@gmail.com> wrote: > Hi, > > I am developing a small tool using Visual c#2005 which is used to get the > Oracle Schema version. When I tested it in my machine it works fine. When > my boss tested the same in his machine it brings out the message TNS-NO > LISTENER. He says listener is running in his machine & says the problem is > in the code (He is an Oracle DBA and is in this field for nearly 15 years). > The code is just a few lines & I think there is nothing wrong in it. I > don't know how to solve this problem. I have tested it in my machine at > home, it works good there also. > > I am a novice when it comes to Oracle & wondering where the problem could > be. Please find below the code I have used. > > private void VERSIONANALYZER() > > { > > try > > { > > //Connection method :1 > > sconnect = "Server = Servername; Uid = username; password = password"; > > //Connection method :2 > > //sconnect = "user id = username e; password = password;data source = // > Servername;"; conn.ConnectionString = > sconnect.ToString(); > > try > > { > > string squery = "SELECT VERSION FROM VERSIONS"; > > cmd = new OracleCommand(squery, conn); > > cmd.Connection = conn; > > this.conn.Open(); > > dr = cmd.ExecuteReader(); > > bool abc; > > abc = dr.Read(); > > if (abc == true) > > { > > string sversion = "Oracle Schema Version : " + dr["VERSION"].ToString(); > > MessageBox.Show(sversion.ToString()); > > } > > } > > catch (Exception EXE) > > { > > MessageBox.Show(EXE.Message, "VERSION ANALYZER", > MessageBoxButtons.OK, MessageBoxIcon.Warning); > > } > > finally > > { > > this.conn.Close(); > > } > > } > > } > > I will be really thankful if some one guide me in solving the issue. > > -- > Thanks & Regards, > Karthikeyan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---