oracle Client

[shereem khaleel]

Hi i have a C# 2005 and oracle 9i database i was install client component for the .NET from oracle 9i but when i try to run the program he give me an error message "Need Client Component version x.x.x" where x is some number i do not remember it then i was install client component for the .NET from oracle 10g but he give me an error message "Can not Resolove TNS name" ? how i can solve this problem ?????

[Rick van Woudenberg]

Hey there, slightly puzzled here. You mention two errors. "Need component ... " and "TNS resolving .. " There reason why I'm confused is that the TNS resolution error cannot occur unless you've established a proper connection to the host, regardless it's local or remote. And to establish a successful connection you need the Oracle Client Binary referenced in your code. If you've referenced the Oracle Client , the DataAdapter will then use that particular Library. I cannot comment on why it would give the "Need Client .." error, as it seems almost impossible to me. Basically all you need to do is copy the Oracle DLL to your /Release or /Debug directory and add that DLL as a reference. As for your "Cannot resolve TNS name" you need to know a little bit about how Oracle works. An Oracle TNS name is basically an entry pointing in the TNSNAMES.ORA file that points to a particular oracle database instance. You might want to check that and set it up. Once this configuration is done you can use the ODBC Administrator to add an Oracle DSN. In the Oracle ODBC Driver Configuration window, in the TNS Name Service text box, you can enter the net service name as you entered it in the setup , or you can enter the fully qualified net service name as it appears in the tnsnames.ora file. I personally think it's not really an error in your code but merely a configuration mistake in setting up Oracle or the DSN. Hope this helped. Cheers