This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi all,
we have a registered version of LightSpeed.
I'm building a data entry for users in our company. We work on a legacy Oracle DB.
The application, to authenticate each user runs a procedure on an Oracle Schema (same schema specified in the connection string). This procedure calls internally a function made by vendors for enabling users to view data. If the combination of user and passwords passed to the internal function returns true, than data for the user are loaded in a sys_refcursor and out putted from the connect enabling procedure.
This procedure works fine on my PC (both in Debug and Release mode) where LightSpeed is installed, but deploying it on couple of users PC it arrives to the call of the procedure inside the model unit of work and after setting the parameters, it stops without any error message...
This is the procedure call:
ThreadContext.Properties["user"] = "DEGIF";
ProcedureParameter connuserParameter = new ProcedureParameter("connuser", connuser);
ProcedureParameter connpwdParameter = new ProcedureParameter("connpwd", connpwd);
ProcedureQuery procedureQuery = new ProcedureQuery("PR_DBCONNECT", connuserParameter, connpwdParameter);
System.Collections.Generic.IList<PrDbconnectResult> valueToReturn = Find<PrDbconnectResult>(procedureQuery); return valueToReturn;
I'm not able to understand what happens!!!! Could you, please help me? Thanks in advance for your help Francesco
|
|
|
"Stops" = crashes or hangs? If it crashes, hook up a debugger (or add an exception handler) and find out what the exception is. What do you see if you hook up a logger? What if you attach a database monitor -- does the query get to Oracle? From the fact that it works on your machine but not on the user machine I would check: - Correct version of Oracle DLLs |
|
|
Hi Ivan,
sorry for the delay, but I have been in the central headquater...
Anyway, in the meanwhile I asked our technicians to restore completely my PC in order to have a clean situation with Frameworks.
Just yesterday the new machine was ready.
Unfortunately this morning trying to run in Debug the application (Visual Studio Team Suite 2005, Framework 2.0 only and Oracle 10g), when, at the very beginning of the application, I try to call a Procedure on the Oracle main schema, I receive this error message:
Could not load file or assembly 'System.Runtime.Serialization, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
We have your commercial version LightSpeed 3.0 at the moment.
The code line that generates the error is: IList <PrDbconnectResult> valueToReturn = Find<PrDbconnectResult>(procedureQuery); in the procedure
At the moment, we have installed the LightSpeed version 3.0. I tried also to remove the [Serializable] attribute, but the error gets out again... Do you have any idea about the reason for the problem and a possible solution? Thanks in Advance Francesco public IList<PrDbconnectResult> PrDbconnect(string connuser, string connpwd) { try
{ ProcedureParameter connuserParameter = new ProcedureParameter("connuser", connuser);
ProcedureParameter connpwdParameter = new ProcedureParameter("connpwd", connpwd); ProcedureQuery procedureQuery = new ProcedureQuery("PR_DBCONNECT", connuserParameter, connpwdParameter); IList<PrDbconnectResult> valueToReturn = Find<PrDbconnectResult>(procedureQuery); return valueToReturn; } catch (Exception ex) { log.Error(ex.Message, ex); return null; } } |
|
|
System.Runtime.Serialization is part of WCF, which is part of .NET 3.0. Your technician has installed only .NET 2.0; LightSpeed 3 requires .NET 3.5. Either revert to LightSpeed 2.2, use the .NET 2.0 compatibility build of LightSpeed 3 (Mindscape.LightSpeed.20.dll), or install .NET 3.5. The SerializableAttribute is NOT related to System.Runtime.Serialization and removing it will not make any difference. |
|