.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

complex error :TNS:could not resolve the connect identifier specified

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net

complex error with 12154: TNS:could not resolve the connect identifier specified

I searched to find any solution to solve this problem but I failed
I am trying to solve this problem to connect my XE database
I am using asp.net 2008
Error Description
If I build windows application the connection will be OK
if I test the connection throw server explorer the connection will be OK
but if I try to connect by website page the error will be TNS:could not resolve the connect identifier specified
TNSNAME file is OK because I connected already
main problem happened if I try to connect by running any website
notice : My laptop is 64 bit 

the connection string I am using (Provider=OraOLEDB.Oracle.1;Data Source=XE;Persist Security Info=True;User ID=hos)

provider : .NET Framework Data Provider for OLE DB


XE =

(SID = PLSExtProc)

View Complete Post

More Related Resource Links

ORA-12154: TNS:could not resolve the connect identifier specified


I have a fresh install of 10g ODAC that I have loaded. My Oracle client interface connects to the db just fine but when I attempt to connect with my ASP.NET project, I get the following error: ORA-12154: TNS:could not resolve the connect identifier specified

Can anyone help out on this?

TNS:could not resolve the connect identifier specified


Hi !

I am able to connect to Oracle 10g database server  through OLEDB and ODBC connection object . But I am unable  to connect to through OracleClient Object . Could any one can answer on this.

 Exception Inforamtion:

 An unhandled exception of type 'System.Data.OracleClient.OracleException' occurred in system.data.oracleclient.dll
Additional information: ORA-12154: TNS:could not resolve the connect identifier specified

Application Software:  ASP.NET & .Net  Framework 1.1 , Oracle 10g

 -Thank you

Binding of complex entity turns into validation error

consider classic example: Product and Category editing Product in dropdown Id of Category is selected - Category mapped as object with all fields empty except Id when submitting Product edit form - validation gives an error: "Category name is required" (I have Required attribute on Category Name property) How deal with such errors if I want to use built-in validation (if (!ModelState.IsValid))? Writing custom data binder which would fill all such id-only-objects with values from database comes to mind.upd: I did small research of mvc code and found out that validation happens before binding - so this solution would't work. Do you have any other solutions for this problem?

Error: The search request was unable to connect to the Search Service.

When attempting a search, I get the the error message "The search request was unable to connect to the Search Service. "  The search sevice has been started in Central Administration.  Does anyone have suggesting as to how to troubleshoot this issue?   Thank you in advance for your help.

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied error for a sched

Hi Guys, The subject of this question is the error which I am receiving when running a scheduled job also this is an error which we get at a random intervals and the frequency would be once or twice in a month. I have been through several posts and didn't concluded anything out of it. At the time when we receive this error the memory usage of the database was normal with free resources available and also the network was stable without issues. Our Sql database is in cluster mode with named instance. Can anyone share some information on this, I know this is not the right forum with the error message I have posted but am sure some one might have face the same problem when running some ETL jobs. Source and target both are sql server and the error message is generated in the validation phase of the connection manager connecting to target database. SSIS 2005 SP2 64 bit environmentRaju

Interesting error message with content organiser: Cannot resolve mailbox (null) to a valid user

Here is a site with content organiser site feature enabled, as well as the email integration feature. Emails are successfully delivered to the "Submitted Email Records" list, but is never routed to the Drop Off Library. (the content organiser web service works fine and the drop off library works as a custom send to destination and happily processes its rules. If I turn up the debug juice I get the error "Cannot resolve mailbox (null) to a valid user" for every item in any "Submitted Email Records" in the site collection. Area: Document managagement Category: Content organiser EventID: 8000 Message: Cannot resolve mailbox (null) to a valid user I have temporarily worked around the problem by email enabling the drop off library but it creates an intermittent race condition (similar to certain workflow and event receiver situations), so its not a real solution (and in fact I assume thats why the Submitted Email Records hidden list exists in the first place). I've run procmon, specifically focusing on OSWTIMER and nothing interesting shows up at all. The error message is intriguing and I can't really think of what it is trying to do. In troubleshooting I noted that this farm had configured inbound email but not outbound email. I have since rectified this and de/reactivated the content organiser features and reset the timer service and IIS, b

Intermittent SharePoint database connect error on SQL cluster

SQL 2008 Cluster has two SQL instances. Two separate SharePoint farms are "connected" with each SQL instance. SharePoint frontend servers eventlog is flooded with "unable to connect with database.." kind of errors for few minutes during diferent time interval. This erros occurs at the same time on both SharePoint farms. (Note that both SharePoint farm doesn't share any info, that is, each farm is running independantly). Someone suggests SQL box has some bandwidth/network issue. Enabled SQL trace. But not sure how to analyze. Can someone help? Thanks in advance    

Error when programmatically connect filter webpart with excel webpart

Hello, On MOSS 2007 SP2 64bit I am trying to programmatically connect a SPSlicerTextWebPart with an ExcelWebRenderer but I am getting the error: "The connection point "IFilterValues" on "g_046273fe_af27_4064_86b1_70f2c57c326c"(the excel webpart)   is disabled" and I can't find a way to enable it... I'm using the folowing code: using(SPLimitedWebPartManager webPartMgr = web.GetLimitedWebPartManager("Stats.aspx", PersonalizationScope.Shared)) { Microsoft.SharePoint.Portal.WebControls.SPSlicerTextWebPart filterWebPart = (Microsoft.SharePoint.Portal.WebControls.SPSlicerTextWebPart)webPartMgr.WebParts[0]; if (filterWebPart.ConnectionID == Guid.Empty) { filterWebPart.ConnectionID = Guid.NewGuid(); } webPartMgr.SaveChanges(filterWebPart); ProviderConnectionPoint providerCP = webPartMgr.GetProviderConnectionPoints(filterWebPart)[0]; Microsoft.Office.Excel.WebUI.ExcelWebRenderer excelWebPart = (Microsoft.Office.Excel.WebUI.ExcelWebRenderer)webPartMgr.WebParts[1]; if (excelWebPart.ConnectionID == Guid.Empty) { excelWebPart.ConnectionID = Guid.NewGuid(); } excelWebPart.AllowConnect = true; webPartMgr.SaveChanges(excelWebPart); ConsumerConnectionPoint consumerCP = webPartMgr.GetConsumerConnectionPoints(excelWebPart)[2]; TransformableFilterValuesToFilterValuesTransformer t = new TransformableFilterValue

Error Message: The attempt to connect to the report server failed. Check your connection informatio

I have a web page that contains a ReportViewer control.  I am trying to display a report, which is an .rdl file located on the SSRS server, in this ReportViewer control.  I have set the ReportPath and ReportServerUrl correctly.  I am getting an error message. Am I suppose to use an .rdlc file rather than a .rdl file?  Does the web server configuration need to use a certain account?  I am getting the following error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.

ORA-12154: TNS:could not resolve the identifier specified

HiI have been trying to connect to Oracle from .net now for a working day and a bit.I have solved a number of errors and each time i do i get another one.The above error is where i am at nowhttp://ora-12154.ora-code.com/this link gives some pointers on how to avoid or solve it, i think all the suggestions are covered and it still occurs.could anyone shed any light please?thanks in advance 

Help to resolve an error "The conversion of a char data type to a datetime data type resulted in an

Why am I getting an error when executing this: select convert(datetime, '2010-09-12T18:11:48', 120) The message is: "Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." I don’t get the error if I remove “T” from the string. But I need it to work with “T”.

SQLServer Express 2008 R2 - Cannot connect Error: 18456, Severity: 14, State: 11.

I have just installed  running MSSQL Server 2008 R2 (Express), along with Visual Web Developer 2010 Express In SQL Server Configuration Manager I can see the SQL Server Service running (SQLEXPRESS) and the SQL Server Browser service running. On running SQL Server Management Studio when trying to log on I get the message Login failed for user Phil-PC`Phil (Microsoft SQL Server, Error: 18456) In the SQL Server Error log I see this error 2010-09-16 10:24:16.07 Logon       Error: 18456, Severity: 14, State: 11. 2010-09-16 10:24:16.07 Logon       Login failed for user 'Phil-PC\Phil'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] I have been unable to find anything useful on Google on how to resolve this problem. I have tried running the command line utility sqlcmd -L and this lists the following Servers:     Phil-PC     Phil-PC\SQLEXPRESS   In my list of Installed programs in Control Panel I see both MS SQL Server 2008 & MS SQL Server 2008 R2, is that correct?

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Cannot Connect to Remote MS SQL Express (error: 26)

Hey guys,
I have tried 
but non of them are working.

I have tried all the settings, without any success.

I am using 
windows 7 ultimate, 
 Visual Studio 2008, 
 linksys wireless router.

I currently disabled my firewall, and have enable traffic on 1037,1434,1433,52369 ports for my router.

So, does anyone have any solution(s) for me to connect to my database remotely?

My codes is as follow:

// attempt 1 : using external IP
String databaseName = "testDB";

string dataSource = @"xx.xx.xx.34\SQLEXPRESS";

Unable to connect to BDC Db_Instance error


I am getting this error "Unable to connect to BDC Db_Instance" while connectinng a Business Data List web part to a BDC application.

It might be the authentication problem.Dont know how to provide sql DB access to users.

Can anyone tell me how to sort out this please?


While trying to connect a WAN IP, i am getting some error(WCF Chat Application)


Hi Everybody 

I am new to this WCF and WCF forum. I want to develop a chat application using wcf , so  i  have downloaded a chat application from "http://www.codeproject.com/KB/WCF/Chat_application_using_WC.aspx ". It works fine in my "LAN" but if i am trying to connect to a wan ip i am getting err ors. I have used "Port forwarding" also in that applicatiion. But still i am getting this error. I have mentioned the error code below. Please provide any solution for this. 

Error code:

System.InvalidOperationException: Could not find endpoint element with name 'ChatEndPoint' and Contract 'ChatClient.ICharService' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this name could be found in the client element. at System.servieModel.Description.ConfigLoader.LoadChannelBehaviours(ServiceEndPoint serviceEndpoints, String ConfigurationName)

at System.ServiceModel.ChannelFactory.ApplyConfiguration(String configurationName)

at System.ServiceModel.ChannelFactory.InitializeEndpoint(String confgurationName, Endpoint Address address)

at System.ServiceModel.DuplexChannelFactory '

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend