Databases :: ORA-12154: TNS:could Not Resolve The Connect Identifier Specified?
Oct 6, 2010
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
I need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??
I am developing an ASP.NET application in which i need to provide support for two databses MySql and MSSQLServer 2005 and 2008 (one database will be used at a time).1)How will i configure the ASP.net app to connect with different databases without reinstalling the app i.e use configuration?2)How will i configure the LINQ?3)Shouldn't i use NHibernate?
i want to connect Db2 database with my .net application.how to fetch data from my DB2 database through my Asp.net application then how to genrate crystal report through this data.
I've had a site up and running for quite some time with "ASPNETDB.MDF" as database. I recently got a request to make a second site with it's own database, but that also includes a admin interface to manage the first site's database.
"Fine", I thought. "I'll just add a new connection string and point to the first database.". But unfortunately it seems to involve a few more steps then that.
But whenever I start up my first website I can't access the database through my second one. I just keep receiving the error: "Cannot open user default database. Login failed. Login failed for user 'MYCOMPUTERWEB01ASPNET'."
And if I were to start up my second one first I can do what I want, but then the first site would get the same error. So I guess the error is somehow related to the database already being in use.
I am trying to connect asp.net with mysql on remote pc. When i am connecting asp.net with localhost mysql it is working properly but when i change "localhost" with IP address it show error.
I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':
We have an MVC application where we have put an excell loader. It works fine in the VS studio environment but on the IIS (64 bit) we get an error message .->
Microsoft.ACE.OLEDB.12.0 provider is not registrated on the local machine.The excell (2010) is 32 bit, but the IIS is 64 bit. Here the code
i have used the following connection string, but it only works for localhost, when i am trying to upload it on server it gives error.,error is specied below..it urgent plz resolve as soon as possible...
<add name="connectionname" connectionString="Server=servername;port=3307;User Id=xyz;Password=abc; database=databasename"/> Error - Unable to connect to any of the specified MySQL hosts. Exception Details: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
I can't connect to both 9i and 10g from asp.net,when i installed 9i client in a machine which already contain 10g xpress edition and no 10g client 9i client used to connect 9i db in another machine. Both 9i and 10g can be connected with TOAD. i got the following error msg from the asp.net application. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I want to insert some values (from asp.net web application) in a table on oracle DB that hosted on a machine rather than the machine that hosts the asp.net application
i use "oracle.dataaccess.client" and the following function
[Code]....
but i get the following exception
The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts
In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.
[code]....
I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.
Say for my ASP.NET application, I have implemented my custom RoleProvider by using my existing Users table on my Oracle 11g database. Then, for my Membership Provider, can I still use the AspNetSqlMembershipProvider that comes with the .NET framework and uses SQL Server?
I am having an issue coinnecting to Oracle using the Oracle Database (OracleClient). I can connect to Oracle using other tools such as TOAD, POWERBUILDR, SQL PLUS but not Visual Studio. These other tools use the TNSNAMES.ORA file so that is not the problem. I can use use oledb and it connects ORACLE but not the ODP.Net.