Data Exception while connecting go Oracle 9i

anilrawat · Post by **anilrawat** » Thu 16 Jul 2009 15:33

Hi,

I am evaluating your provider to use with Entity Framework for connecting to Oracle 9i and Oracle 10g.

I have tried to connecto to orcale 10g which works fine but when I change connection string and connect to Oracle 9i i got exception on execution of query.

Below are the connection string I am using:
// Oracle 10g

public static string getConStrIntegrated()
{

string conStrIntegratedSecurity = new System.Data.EntityClient.EntityConnectionStringBuilder
{
Metadata = "res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl",
Provider = "Devart.Data.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
DataSource = "XE",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;

return conStrIntegratedSecurity;
}

Oracle 10g is intalled in same maching where code is.

//Oracle 9i
public static string getConStrIntegrated()
{

string conStrIntegratedSecurity = new System.Data.EntityClient.EntityConnectionStringBuilder
{
Metadata = "res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl",
Provider = "Devart.Data.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
DataSource = "ANIL",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;

return conStrIntegratedSecurity;
}
Oracle 9i is intalled in different maching and below is the definition is given in tnsname for oracle 9i client side:
ANIL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC05489)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = ANIL)
)
)

Can you help on this its urgent as I need to finalise the Oracle provider to use for entity framework.
Is there any phone number where I can talked to your concern person?

Thanks,
Anil

anilrawat · Post by **anilrawat** » Thu 16 Jul 2009 15:40

I have added below code before quering data:

context.Connection.Open();

And get same exception
System.Data.EntityException] = {"The underlying provider failed on Open."

It seems there is problem with opening connection.

it might help you to investigate.

AndreyR · Post by **AndreyR** » Fri 17 Jul 2009 12:37

We have replied to you here:
http://devart.com/forums/viewtopic.php?t=15349