Data Exception while connecting go Oracle 9i
Posted: 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
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