Just fyi, this may help
http://oraclespin.wordpress.com/2008/10/07/how-to-pass-host-port-sidservice-name-to-connect-to-a-database/ Regards, Sonty On Aug 8, 2:44 pm, Karthizen <karthi...@gmail.com> wrote: > Hi Sonty, > > Thanks for reply.. > > The Tnsnames.Ora is already there in the machine & my boss says the > problem with the connection method. so far I have used the following > methods > > 1. sconncectin = "Server = Servername; Uid = username; password = > password"; > > 2. sconncectin = "user id = username e; password = password;data > source = Servername;"; > > 3. Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost) > (PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User > Id=myUsername;Password=myPassword; > > Is there any other connection methods available? > > On Aug 8, 12:07 pm, sonty <saurabh.zen...@gmail.com> wrote: > > > > > 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- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
