Exception Devart.Data.Linq on a server "Devart.Data.Oracle.Linq.Provider" -


i trying deploy application on windows server 2007 32 bit application give me exception

error on opening dbconnection.   bei devart.data.linq.linqcommandexecutionexception.canthrowlinqcommandexecutionexception 

(string message, exception e) bei devart.data.linq.provider.k.a.g() bei devart.data.linq.provider.k.a.b(iconnectionuser a_0) bei devart.data.linq.provider.k.b(iconnectionuser a_0) bei devart.data.linq.provider.dataprovider.executequery(compiledquery compiledquery, object[] parentargs, object[] userargs, object lastresult) bei devart.data.linq.provider.dataprovider.executeallqueries(compiledquery compiledquery, object[] userarguments) bei devart.data.linq.provider.dataprovider.compiledquery.devart.data.linq.provider.icompiledquery.execute(iprovider provider, object[] userargs) bei devart.data.linq.dataquery1.i() bei system.collections.generic.list1..ctor(ienumerable1 collection) bei system.linq.enumerable.tolist[tsource](ienumerable1 source)

while excuting line in program var list = clientcustomers.tolist();

thank much

code

    public repository(string connection, string eventpackagename, string eventscopename)     {         this.connectiondict = this.getconnectioninfo(connection);          //this.context = new datacontext(connection);//old way         this.context = new datacontext(connection, new devart.data.oracle.linq.provider.oracledataprovider());          this.eventcontext = new eventpacdatacontext(connection);         this.econtext = new context.eventpacdatacontext(connection, new devart.data.oracle.linq.provider.oracledataprovider());          this.eventpackagename = eventpackagename;         this.eventscopename = eventscopename;         this.clientusername = this.connectiondict["user id"];     }      /// <summary>     /// collect customers view     /// </summary>     /// <returns>iqueryable<customer></returns>     public iqueryable<customer> getcustomers()     {         try         {              var result = p in this.context.ydevqualibasics                          join extended in this.context.ydevqualibasicextendeds on                          p.accountid equals extended.accountid                          select                          new customer                          {                              base = new customer                              {                                  customerid = p.customerid.tostring(),                                  customerno = p.customerno.tostring(),                                  geburtsdatum = p.detgeburtsdatum.getvalueordefault(new datetime(1900, 1, 1)),                                  email = p.detemail,                                  businessarea = p.accbusinessarea,                                  contracttype = p.acccontracttype,                                  contracttariff = p.acccontractariff,                                  subscribechannel = p.detanmeldekanal,                                  paymentmethod = p.cuscollectionident,                                   customeraddress = new address                                  {                                      city = p.cuscity,                                      street = p.cusstreet,                                      extendedinfo = p.cusehnr,                                      streetnumber = p.cushnr,                                      lcountry = p.cuscountryl,                                      scountry = p.cuscountrys,                                      zipcode = p.cuszipcode                                  },                                       accountperson = new person                                      {                                          salutation = p.accanrede,                                          title = p.accakadem,                                          branche = p.accbranche,                                          lastname = p.acctomername1,                                          firstname = p.acctomername2,                                          name3 = p.acctomername3                                      }                                  },                                  customerperson = new person                                  {                                      salutation = p.cusanrede,                                      title = p.cusakadem,                                      branche = p.cusbranche,                                      lastname = p.customername1,                                      firstname = p.customername2,                                      name3 = p.customername3                                  },                               interngeolocchecked = extended.detinterngeolocchecked,                              interngeolocstatus = extended.detinterngeolocstatus,                          };              return result;          }         catch (reflectiontypeloadexception ex)         {             stringbuilder sb = new stringbuilder();             foreach (exception exsub in ex.loaderexceptions)             {                 sb.appendline(exsub.message);                 if (exsub filenotfoundexception)                 {                     filenotfoundexception exfilenotfound = exsub filenotfoundexception;                     if (!string.isnullorempty(exfilenotfound.fusionlog))                     {                         sb.appendline("fusion log:");                         sb.appendline(exfilenotfound.fusionlog);                     }                 }                 sb.appendline();             }             string errormessage = sb.tostring();             //display or log error based on application.             logger.fatal("aha: " + errormessage);             return null;         }          catch (exception ex)         {             logger.fatal("customer failed: " + ex.message + ex.stacktrace);             throw new dataaccessexception("customer failed", ex);         }     } 

when deploying applications written of linqconnect should register run-time assemblies devart.data.oracle.dll, devart.data.dll, devart.data.oracle.linq.dll , devart.data.linq.dll @ global assembly cache (gac) or place them in folder of application. when deploying asp.net applications necessary have devart.data.oracle.web.dll , app_licenses.dll assemblies available.

if required assemblies available project, please perform following steps:

  1. make sure oracle client software installed on computer;
  2. specify name of oracle home explicitly in home connection string parameter.
  3. place content of oracle_home variable on first position in path variable of operating system;
  4. make sure capacity (x86 or x64) of application , capacity of oracle client same.

if after these steps issue still persists, please contact us more details issue, e.g.:

  • the full stack trace of exception;
  • the connection string;
  • the version of oracle client;
  • the version of oracle server;
  • the definitions of database tables , corresponding entity classes, etc.

Comments

Popular posts from this blog

image - ClassNotFoundException when add a prebuilt apk into system.img in android -

I need to import mysql 5.1 to 5.5? -

Java, Hibernate, MySQL - store UTC date-time -