can't start the In-process server

Hi,

I've installed dataphor. I'm working on the following machine:
- Vista
- SQL Server 2005

When trying to accept the in-process server i'm receiving the following error:

Access to the path 'C:\Program Files\Alphora\Dataphor 2.1\Dataphoria\Alphora.Dataphor.DAE.Device.Simple.dll' is denied.
----
Runtime error: Access to the path 'C:\Program Files\Alphora\Dataphor 2.1\Dataphoria\Alphora.Dataphor.DAE.Device.Simple.dll' is denied.

When trying to create a script
Object reference not set to an instance of an object.

I'd think the vista security messed something up, I installed it from my vista admin account.

I'm having a thin version of visual studio 2005, the one which comes with sql server.

regards,

Johan

Device.Simple.dll

Hi Johan,

A few questions:

1) Are you running the latest service packs of Vista?
2) Are you able to copy the file Alphora.Dataphor.DAE.Device.Simple.dll from the Libraries\SimpleDevice folder where it is installed to the Dataphoria directory manually using Windows Explorer or some other file copy?

Bryn Rhodes
Database Consulting Group LLC

I'm running the latest

I'm running the latest updates of vista.
Copying the dll works.

The problem is the access to the path of the simple dll is denied.
I went over there and manually changed permissions, but I am still getting the notification about the in process server not working.

UnauthorizedAccessException --->
Access to the path 'C:\Program Files\Alphora\Dataphor 2.1\Dataphoria\Alphora.Dataphor.DAE.Device.Simple.dll' is denied.
---- Stack Trace ----
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemRegisterLibraryNode.RegisterLibraryFiles(ServerProcess AProcess, Library ALibrary, LoadedLibrary ALoadedLibrary)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemRegisterLibraryNode.RegisterLibrary(ServerProcess AProcess, String ALibraryName, Boolean AWithReconciliation)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemRegisterLibraryNode.EnsureLibraryRegistered(ServerProcess AProcess, LibraryReference ALibraryReference, Boolean AWithReconciliation)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemRegisterLibraryNode.RegisterLibrary(ServerProcess AProcess, String ALibraryName, Boolean AWithReconciliation)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemEnsureLibraryRegisteredNode.EnsureLibraryRegistered(ServerProcess AProcess, String ALibraryName, Boolean AWithReconciliation)
at Alphora.Dataphor.DAE.Runtime.Instructions.SystemEnsureLibraryRegisteredNode.InternalExecute(ServerProcess AProcess, DataVar[] AArguments)
at Alphora.Dataphor.DAE.Runtime.Instructions.InstructionNode.InternalExecute(ServerProcess AProcess)
at Alphora.Dataphor.DAE.Runtime.Instructions.PlanNode.ProtectedExecute(ServerProcess AProcess)
at Alphora.Dataphor.DAE.Runtime.Instructions.PlanNode.StandardExecute(ServerProcess AProcess)
Application:104229 --->
Runtime error: Access to the path 'C:\Program Files\Alphora\Dataphor 2.1\Dataphoria\Alphora.Dataphor.DAE.Device.Simple.dll' is denied.
---- Details ----
Exception occurred while executing the following code: .System.EnsureLibraryRegistered(.System.Name('Frontend'))
---- Server Context ----
at Alphora.Dataphor.DAE.Server.ServerBatch.Alphora.Dataphor.DAE.IServerBatch.Execute(DataParams AParams)
at Alphora.Dataphor.DAE.Server.ServerScript.Alphora.Dataphor.DAE.IServerScript.Execute(DataParams AParams)
at Alphora.Dataphor.Dataphoria.Dataphoria.ExecuteScript(String AScript, DataParams AParams)
at Alphora.Dataphor.Dataphoria.Dataphoria.EnsureServerConnection()

Simple.dll

You might try running as Administrator or turning off UAC. If if your user has access to the path, UAC runs apps as a user with less rights therefore preventing the access.

Best,

--
Nathan Allan [Alphora]