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 -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
