share|improve this answer edited Jan 13 at 15:34 answered Jan 13 at 14:59 John 1068 add a comment| up vote 0 down vote If you are using ApplicationPoolIdentity, Make sure ApplicationPoolIdentity string connString = "user id=*****;password=*****;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= IP Address or Host Name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME= *****)));"; oracleConnection1.ConnectionString = connString; oracleConnection1.Open(); Posted on Tuesday, March 13, 2012 10:51 PM .Net | Back to top Related Posts on Loading... Thank you very much! weblink
This feature is not available right now. Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. 4. When you drag and drop a table onto the aspx form, all you get is text with a select statement. Not the answer you're looking for? http://stackoverflow.com/questions/4228739/vs2010-oracle-driver-ora-12154-tsncould-not-resolve-the-connect-identifier
Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Thank you in advance! .net visual-studio oracle driver share|improve this question asked Nov 19 '10 at 19:40 Matt 1,82131834 add a comment| 4 Answers 4 active oldest votes up vote 3 Here is what you need to do: a) Install both ODT 11g *and* ODP.NET 10g or 9i. Scenario: I have read about interesting new Visual Studio features contained in Oracle Developer Tools 11g but I am standardized on Oracle Data Provider for .NET version 10.x or 9.x in
c# oracle excel-addins share|improve this question edited Jun 2 at 11:09 Alex Weitz 7292519 asked Dec 3 '13 at 20:46 محمد النعيمي 1761315 1 don't you have to specify the try this... Please note that sometimes new features may be included in a beta release. In IIS -> AppPool, I set ApplicationPoolIdentity to my Pool.
Has the same issue as you and this blog post helped me resolve my issue.Thanks ......... Ora 06413 share|improve this answer answered Aug 24 '11 at 17:33 rick schott 18.3k53366 Yeah, I granted access to the C:\oracle\instantclient_10_2 directory, and it has worked! up vote 6 down vote favorite 5 I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select userId from tblusers"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader Dealing with a nasty recruiter Are there textual deviations between the Dead Sea Scrolls and the Old Testament?
Your Email This email is in use. Sign in to add this video to a playlist. Verify that "LDAP" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).2. The Visual Studio wizard told me: "ORA-12154: TNS:could not resolve the connect identifier specified".
This message is provided "AS IS" with no warranties... http://www.oracle.com/technetwork/topics/dotnet/odt-faq-085407.html Loading... Ora 12154 Could Not Resolve The Connect Identifier Specified How or where should I add a required connection string for a feature in Helix? Oracle Developer Tools For Visual Studio Advisor professor asks for my dissertation research source-code Seasonal Challenge (Contributions from TeXing Dead Welcome) Is there a name for the (anti- ) pattern of passing parameters that will only be
Verify that the LDAP directory server is up and that it is accessible.3. have a peek at these guys This way you can take advantage of all new features, many of which were added in the 11g release. Quicker and quieter than a mouse, what am I? I didn't have access to adjusting the folder permissions and setting the Application Pool Identity did nothing. Ora-12545: Connect Failed Because Target Host Or Object Does Not Exist
What happens to all of the options when they expire? You get a ORA-12154 error when you attempt to connect. Name: *And who are you? check over here Please try again later.
Solution: Upgrade to ODT version 18.104.22.168.2 or later. pls help me.. I try login in IIS->AppPool with my Windows Account and either not work.
Where can I get a file/list of the common and scientific names of species? See more: (untagged) The following Error Occured while Connecting to Database. "ORA-12154 :TNS:Could not resolve the connect identifier specified". The virtual account "IIS AppPool\MyAppPoolName" had been granted read and execute permission on the Oracle folder, however, permissions weren't being inherited from this folder. Which Means that I changed the Identity of application pool to Custom Account.
rhina disouza 2,023 views 1:24 how to solve ORA-12560: TNS:protocol adapter error - Duration: 2:27. In case the TNS is not defined you can also try this one: If you are using C#.net 2010 or other version of VS and oracle 10g express edition or lower BTW, when you access the TNSNAMES.ORA file, I hope you can detect the identity of web application with the code below: System.Security.Principal.WindowsIdentity.GetCurrent().Name Please mark the replies as answers if they help http://prcflow.com/visual-studio/error-c3861-39-exit-39-identifier-not-found.html Autoplay When autoplay is enabled, a suggested video will automatically play next.