Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/21' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
can't start the In-process server | Dataphor Forums

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]


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/21', '', '54.196.190.32', 1542384466) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Zr6?3}-34TT7uL\\&amp;quot;!\\rI0\\0hYq/s8}HrǹfnL$v޷O&amp;gt;&amp;gt;d)h/w\\0ߎlÉQ\\&amp;quot;2ax\\ZSt:\\r;TExN:4jN b{o,,\\Z\\n\\rMY&amp;gt;xA^Yl[6¤\\rhÔp~dĵWO8`TD2ӽͯe0 |g{޾\\rύ:+{ ?7! )^i}^*wxidҀ$p,R S혝\\0?&amp;lt;0gwNYʫVHk2 4ߋ@Kb˘ۏ?셖xbz\\r˜Y\\Z}$U,qUϫ ,C?$w6!Gs9d*UM޹?_OJEWb !{Sw3{X in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;ispf70of8ga6epj8pr6rmm8ol7&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:3455:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172