HELP!!! how can I connect to Oracle with this error?? [modified]

[meki_2118]

I've been working my first web site and I'm trying to connect in my oracle with this code.. and i'm using Microsoft web developer 2008 Dim oraCommand As OracleCommand = New OracleCommand(strSQLRecords, oraConnection) Dim oraDataAdapter As OracleDataAdapter = New OracleDataAdapter(oraCommand) Dim oraDS As New Data.DataSet oraDataAdapter.Fill(oraDS) Return oraDS but I always get the error in the oraDataAdapter.Fill(oraDS) line "ORA-12154: TNS:could not resolve the connect identifier specified" hope you can help me with this problem.. thanks in advance :)

modified on Wednesday, September 10, 2008 11:42 PM

[Gamzun]

your tnsnames.ora is not configured correctly Click Here

[meki_2118]

my tnsname is fine. and I've already re-installed the oracle 10g in my computer but it only producing the same error..

[Rich Edwards]

It does sound like your tnsnames.ora file is not configured correctly. Can you connect to the DB via tools such as SQL Tool or Toad. They can utilise the TNSNames file settings to connect to the relevant DB, as least with this way you can establish if the tns.ora file at fault or not. You can also try manually connecting to the DB using these tool to validate any credentials etc.. Other options are to check the listeners are configured correctly and will accept connections Hope these ideas help Rich