mORMot Open Source

BrentG

Member

Registered: 2012-04-05

Posts: 31

TestSQL3.exe fails on one computer but not another

I compiled TestSQL3.dpr using Delphi XE2 32-bit and it fails on Win7 32-bit (Computer A) because it can't connect to the server:

=====================
! Exception ECommunicationException raised with messsage:
The system cannot find the file specifiedct to server "Test"

D:\TMP\TestSQL3\TestSQL3.exe 0.0.0.0 (2012-04-08 19:14:02)
Host=Brent3500 User=Brent CPU=2*0-15-8962 OS=12.0=6.1.7600 Wow64=0 Freq=3579545
TSynLog 1.16 2012-04-08T19:57:45

20120408 19574520 EXC   ECommunicationException ("TSQLRestClientURINamedPipe can't connect to server \"Test\"\rvia \"\\\\.\\pipe\\Sqlite3_Test\":\rThe system cannot find the file specified") at 00523512  stack trace 00544E5F 00466FE9 0058596A 004086DC 0058B259 77931114 77ABB299 77ABB26C
20120408 19574520 EXC   ECommunicationException ("TSQLRestClientURINamedPipe can't connect to server \"Test\"\rvia \"\\\\.\\pipe\\Sqlite3_Test\":\rThe system cannot find the file specified") at 00523512  stack trace 0058596A 004086DC 0058B259 77931114 77ABB299 77ABB26C
=====================

I can copy the same TestSql3.exe file to another computer (B), this time Win7 64-bit (instead of 32-bit) and it runs fine if run as Administrator. I have the same Firewall (ZoneAlarm Free) and Antivirus(Nod32) enabled on both machines.

I suspect TestSQL3.exe can't find the named pipe because I had this problem with "03-NamedPipe Client-Server" last week on Computer A.
I downloaded oRMot again today (Sunday) and recompiled TestSQL3.dpr with sqlite3.obj and sqlite3fts3.obj dated 3/27/2012 1:21PM (like I did before). Same problem on computer A but works fine on Computer B.
I deactivated the antivirus and firewall on Computer A, but problem remains.
I do have other programs on computer A that use Sqlite3, so maybe it is finding something on the path? I opened a DOS window as Administrator and set the path=\ and ran TestSQL3.exe from its directory. Still fails at the same point.

So is there something with Computer A that is preventing Named Pipes from being used?
What do I need to activate to enable Named Pipes on Computer A?

TIA
Brent

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: TestSQL3.exe fails on one computer but not another

This is a known issue, due to some security changes of Windows.

See http://blog.synopse.info/post/2010/07/0 … nd-Service

If you have some code to offer, you're welcome!

Locally, you could use GDI messages communication instead (which is faster), and TCP/HTTP over a network, which works as expected.