*Well,* ** *The problem was with the connection string, I have changed the connection string as follows,* Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password= myPassword; It works good !!! *Thanks,* *Karthik*
*On Sun, Aug 9, 2009 at 9:09 PM, Karthikeyan R <[email protected]> wrote: * > > *Dear Dan,* > * * > *I have asked to him to give access to his machine but he refused, he is > telling that the problem is with the code I have used in the program & he > asked me to verify the code again. He further said TNSNAMES is there & it > is running. * > * * > *Oracle client and server are in the same machine & he told me not to > worry about the hostname, port etc which are used in the TNSNAMES file.* > * * > *Wondering what to do now? > > * > ** > *On Sun, Aug 9, 2009 at 10:56 AM, santhosh vs <[email protected]>wrote: > * >> >> *Ensure that you could connect through some oracle client app such as >> sqlplus with the same credentials you used in the app. >> Normally it happends when the service is not running, or issue appear on >> multiple database instance active(each may have own listeners). >> * ** >> >> *On Sat, Aug 8, 2009 at 8:59 PM, ZCSI <[email protected]> wrote: >> * >>> >>> >>> *Would this be a TNS-Names file issue? I don't know much about this >>> development, but this site gave a few ideas on how to research the >>> issue, but you'd need access to your boss's machine. >>> ** >>> http://dbaspot.com/portal/oracle/error-guide/2-ora-12541-tns-no-listener-.html >>> *<http://dbaspot.com/portal/oracle/error-guide/2-ora-12541-tns-no-listener-.html> >>> >>> *Can you ping his listener from your machine? Are the versions of >>> Oracle and drivers the same on both machines? >>> >>> Good luck. >>> Dan >>> * >>> >>> *On Aug 8, 2:02 am, Karthikeyan R >>> <**[email protected]*<[email protected]> >>> *> 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. >>> > >>> * >>> ** >>> *> I will be really thankful if some one guide me in solving the issue. >>> > >>> > -- >>> > Thanks & Regards, >>> > Karthikeyan >>> * >>> >> >> >> >> *-- >> >> Santhosh V >> **http://techplex.wordpress.com* <http://techplex.wordpress.com/> >> >> > > ** > > *-- > Thanks & Regards, > **Karthikeyan > * ** *-- Thanks & Regards, Karthikeyan *
