Thanks for your response.
Is there any example, which we can look at?
Search found 12 matches
- Thu 05 Nov 2009 16:05
- Forum: dotConnect for Oracle
- Topic: dotConnect deployment to test/production environment
- Replies: 3
- Views: 1528
- Thu 05 Nov 2009 15:11
- Forum: dotConnect for Oracle
- Topic: Oracle client required?
- Replies: 1
- Views: 1511
Oracle client required?
Hi,
We are using dotConnect professional edition version 5.25 to access oracle 10g Database and using entity framework.
As we know from your site that we don't require to install oracle client to access oracle using dotConnect. But we are not able access database without installing oracle Client.
We are getting following exception message:
"Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server."
Can you please let us know how can we access oracle using dotConnect without installing oracle client or is it mandatory to install client?
Thanks,
Anil
We are using dotConnect professional edition version 5.25 to access oracle 10g Database and using entity framework.
As we know from your site that we don't require to install oracle client to access oracle using dotConnect. But we are not able access database without installing oracle Client.
We are getting following exception message:
"Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server."
Can you please let us know how can we access oracle using dotConnect without installing oracle client or is it mandatory to install client?
Thanks,
Anil
- Thu 05 Nov 2009 14:16
- Forum: dotConnect for Oracle
- Topic: dotConnect deployment to test/production environment
- Replies: 3
- Views: 1528
dotConnect deployment to test/production environment
Hi,
We have got dotConnet professional licence and we are using for Connecting to Oracle (entity framework). We are trying to deploy our application to the test environment. We have not installed dotConnect provider into test environment.
How can we deploy provider as part of code deployment packet to test / production environment?
Thanks,
Anil
We have got dotConnet professional licence and we are using for Connecting to Oracle (entity framework). We are trying to deploy our application to the test environment. We have not installed dotConnect provider into test environment.
How can we deploy provider as part of code deployment packet to test / production environment?
Thanks,
Anil
- Wed 22 Jul 2009 13:43
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
- Wed 22 Jul 2009 13:16
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
- Tue 21 Jul 2009 15:05
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
Do I need to install Oracle 9i client on machine from where I am trying to connect oracle 9i server?
I have oracle 9i installed on different maching, and .net application and provider are installed on my laptop, from where I am trying to connect to oracle 9i which is on another machine. I have oracle 10g also installed on laptop where I am using .net application.
Is there anything to do with oracle client?
Thanks,
Anil
I have oracle 9i installed on different maching, and .net application and provider are installed on my laptop, from where I am trying to connect to oracle 9i which is on another machine. I have oracle 10g also installed on laptop where I am using .net application.
Is there anything to do with oracle client?
Thanks,
Anil
- Tue 21 Jul 2009 13:57
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
- Tue 21 Jul 2009 10:01
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
Hi,
This exception is wrapped by dotConnect provider, I am not sure if I can get inner exception. I will try if I get and send you details.
I need to goto client site to connect with oracle and see the exception. Is there any phone where I can contact you as soon as I get error? Otherwise it may time to resolve this issue.
Thanks,
Anil
This exception is wrapped by dotConnect provider, I am not sure if I can get inner exception. I will try if I get and send you details.
I need to goto client site to connect with oracle and see the exception. Is there any phone where I can contact you as soon as I get error? Otherwise it may time to resolve this issue.
Thanks,
Anil
- Thu 16 Jul 2009 15:40
- Forum: Entity Framework support
- Topic: Data Exception while connecting go Oracle 9i
- Replies: 2
- Views: 2671
- Thu 16 Jul 2009 15:33
- Forum: Entity Framework support
- Topic: Data Exception while connecting go Oracle 9i
- Replies: 2
- Views: 2671
Data Exception while connecting go Oracle 9i
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
- Thu 16 Jul 2009 15:04
- Forum: dotConnect for Oracle
- Topic: System.Data.EntityException while query
- Replies: 9
- Views: 7031
System.Data.EntityException while query
Hi,
I am evaluating dotConnect oracle provider for my project with Oracle 9i (ver 9.2.0. and Oracle 10g.
I have tested code with Oracle 10 and 9i. The code works fine with Oracle 10g and when I change connection string from connecting to Oralce 9i then i get exception :
System.Data.EntityException] = {"The underlying provider failed on Open."}
I get this exception while executing query.
Can you help me to understand what is the issue.
I am pasting connection string I am using:
Connection string inside app.config which was generated while generating entity model from database.
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",
//Provider = "DDTek.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
// User Id=hr;Password=manager;Server=XE;Persist Security Info=True
//InitialCatalog = "Northwind",
DataSource = "XE",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;
return conStrIntegratedSecurity;
}
and 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",
//Provider = "DDTek.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
// User Id=hr;Password=manager;Server=XE;Persist Security Info=True
//InitialCatalog = "Northwind",
DataSource = "ANIL",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;
return conStrIntegratedSecurity;
}
Code works with Oracle 10g but same code doesn't work with Oracle 9i.
Can you please help in this I need to decide provider for the project.?
Do you have any phone number where i can reach out for further queries?
Thanks,
Anil
I am evaluating dotConnect oracle provider for my project with Oracle 9i (ver 9.2.0. and Oracle 10g.
I have tested code with Oracle 10 and 9i. The code works fine with Oracle 10g and when I change connection string from connecting to Oralce 9i then i get exception :
System.Data.EntityException] = {"The underlying provider failed on Open."}
I get this exception while executing query.
Can you help me to understand what is the issue.
I am pasting connection string I am using:
Connection string inside app.config which was generated while generating entity model from database.
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",
//Provider = "DDTek.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
// User Id=hr;Password=manager;Server=XE;Persist Security Info=True
//InitialCatalog = "Northwind",
DataSource = "XE",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;
return conStrIntegratedSecurity;
}
and 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",
//Provider = "DDTek.Oracle",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
// User Id=hr;Password=manager;Server=XE;Persist Security Info=True
//InitialCatalog = "Northwind",
DataSource = "ANIL",
UserID = "hr",
Password = "manager",
}.ConnectionString
}.ConnectionString;
return conStrIntegratedSecurity;
}
Code works with Oracle 10g but same code doesn't work with Oracle 9i.
Can you please help in this I need to decide provider for the project.?
Do you have any phone number where i can reach out for further queries?
Thanks,
Anil
- Mon 13 Jul 2009 16:30
- Forum: dotConnect for Oracle
- Topic: Transactions with Entity Framework using DotConnect provider
- Replies: 1
- Views: 1450
Transactions with Entity Framework using DotConnect provider
Hi,
I am evaluating DotConnect Oracle provider 5.20 for using in my with ADO.NET Entity Framework. I am able to do CRUD operation. I want to know how can I use Transactions with this provider and also how can I use ProfileProvider using DotConnect Oracle provider.
Thanks,
Anil
I am evaluating DotConnect Oracle provider 5.20 for using in my with ADO.NET Entity Framework. I am able to do CRUD operation. I want to know how can I use Transactions with this provider and also how can I use ProfileProvider using DotConnect Oracle provider.
Thanks,
Anil