Devart Forums

joao88

Hi, i am using devart oracle provider 6.10 and a silverlight app+asp.net(using
the provider)+oracle+wcf ria services+windows server 2008(iis 7) 32 bits. so
in windows 2008 r2 64 bits the application works fine. When deployed in a windows server 2008 32 bits i get this error:

Unable to find the requested .Net Framework Data Provider. It may not be
installed.

in this post:

http://www.devart.com/forums/viewtopic.php?t=3285

him add this section, end solve the problem:

in my case this doesn't work(obviously i change provider name,version etc.. like this:
http://www.devart.com/dotconnect/oracle ... yment.html)...can help me with this issue?

joao88

AndreyR wrote:This is a known situation. Yes, executables compiled with "Any CPU" Platform will execute with 64-bit CPU.
The issue is that 64-bit Oracle Client expects 64-bit application to work with. Please recompile the project in 64-bit mode.
Let me know if this advice isn't helpful.

i have the same issue here, my app doesnt compile if i set 64-bit, but compile
any-cpu. i am using silverlight+asp.net+ef4 code only. in same application i am
using edm and connect oracle client works, but if i use code only crashes with
error above. I cannot use direct mode because i am using oracle RAC

i am work 1 week in this issue can help me solve?

joao88

i have the same problem here. I am stuck too.

I am use code only and EDM in the same project but when i use piece of
application with EDM works. when i use code only piece of software got:

Erro: Unhandled Error in Silverlight Application Submit operation failed. The provider did not return a ProviderManifestToken string. Inner exception message: Can not load Oracle client library oci.dll from home .

so i think "i will use 32bit" but when i use 32bit oracle home, devart doest not found oracle home.

need some help.

joao88

I am use code only and EDM in the same project but when i use piece of
application with EDM works. when i use code only piece of software got:

Erro: Unhandled Error in Silverlight Application Submit operation failed. The provider did not return a ProviderManifestToken string. Inner exception message: Can not load Oracle client library oci.dll from home .

so i think "i will use 32bit" but when i use 32bit oracle home, devart doest not found oracle home.

need some help.

.net framework 4:
Silverlight4+Code only+EDM+ASP.NET

joao88

Hi i will deploy my application tomorrow and need how i can configure devart to Oracle RAC?. With EDM i use oracle home but with Code Only RC how i can configure?

joao88

Hi, i try do this:

Code: Select all

 
string esql = "SELECT VALUE test  FROM Entities.test AS test WHERE CAST(test.NumeroRA as Edm.String) like @param";

ObjectQuery QueryTest = new ObjectQuery(esql, Context);
QueryTest .Parameters.Add(new ObjectParameter("param", "%'" +id.ToString() + "'%"))

but i get error:"Edm.String type no found", i want perform a like with a numeric value, so i want cast/convert field to use like operator...with sql server provider this query run fine, but when i try with devart provider i get this error, how i can peform a like with devart using linq or esql?

Devart Forums

Search found 6 matches

IIS 7 vs 7.5 - Unable to find provider

Code only deploy error.

Connection string for Code Only RC+Oracle RAC??

how Cast/Convert numeric to string to perform like?linq/esql