Devart Forums

I fixed it by reinstall oracle db.

Thanks

daniel

I have no problem to query oracle 10g table via SQL*Plus.

I tried to install 10204_vista_w2k8_x64_production_db.zip and 10204_vista_w2k8_x64_production_client.zip, neither working, same error message.

Is it the right version of oracle to install? if not, would you tell the correct url to download oracle client?

Is ther any other ways I could try to fix this problem?

Thanks a lot.

Hi,

I had same problem on my windows 2008 server(64bit), Oracle 10g and Devart, tried all the above ways, still not working.

Anyone could help?

thanks

daniel

Hi,

I installed dcoracle525pro.exe on Windows 2008 server(64 bit), I also installed Oracle 10g client on the same
Windows 2008 server(64 bit), my asp.net application get following error:

Can not load Oracle client. Check your PATH environment variable and registry settings.

I checked server, Devart was installed under "C:/Program Files(x86)" folder, and there is no Devart under "C:/Program Files" folder.

Is it because dcoracle525pro.exe only works for 32 bit Windows 2003 servers? or do you have any dotConnect for Oracle for Windows 2008 server(64 bit)?

Thanks

daniel

Hi,

I used dotConnect for Oracle and Entity Frameworks for our asp.net project, everything working fine on my local machine.

But after I deployed to our test web server, could not connect to Oracle 10g database anymore:

Error:
ORA-12541: TNS:no listener

Stack trace: at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.b__2[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
at USC.Advancement.Web.ExcelDataEF.loadGridByWorksetCD(String workcd)
at USC.Advancement.Web.ExcelDataEF.btnImportFromWorkset_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Would you help?

thanks

O.K., here is the code:

string entitySql = String.Format("SELECT VALUE p FROM context.GIVING_FACT_TOTAL_BYUNITYEAR AS p WHERE p.BUSINESS_UNIT IN {{{0}}}", String.Join(",", units.ToList().ConvertAll(e => e.ToString()).ToArray()));
ObjectQuery query = new ObjectQuery(entitySql, context);


And Here is the error:


base {System.Data.EntityException} = {"The query syntax is not valid., near term '}', line 2, column 0."}


Would you help?

thanks

Thanks, but your sample code is not working, here is the error:

Cannot create an instance of the abstract class or interface 'System.Data.Objects.ObjectQuery'

Would you please provide the correct code sample?

thanks

It seems timeout error, is it anyway to set timeout value for dotConnect for Oracle?

thanks

Hi,

We have a long script to run on oracle from webpage, we used dotConnect for Oracle, there is following error:

Devart.Data.Oracle.OracleException: ORA-03113: end-of-file on communication channel

would you please tell how to fix?

thanks

Hi,

Is it anyway to accomplish the same functionality as a SQL WHERE IN statement in Entity Framework?

Like:
SELECT *
FROM Foo
WHERE blah IN (1, 3, 5, 7)

I tried following linq, but not working well:
var query = from e in context.tblFACT
join id in ids on
e.ID equals id
select e;

The error we received was:

"Unable to create a constant value of type 'System.Collections.Generic.IEnumerable`1'. Only primitive types (for instance Int32, String and Guid) are supported in this context."


Thanks for any help.

Hi,

Is it anyway to build sharepoint 2007 with Oracle 10g using dotConnect for Oracle?

thanks

Thanks, will try it later.

Thanks

Hi,

I have a problem to add some oracle views to my edmx file. I use "Update Model from Database" wizard to add several oracle views to a edmx file, no error, most views added successfully, but only some views (using Union All) could not be found in edmx file.

Seems Union not supported?

Would you help?

thanks

thanks a lot for your support. We will check other options to fix our problem.