Sqlitening Local vs Remote connection

[Ross Boyd]

Hi all

I've read and re-read the Sqlitening docs and Googled but to no avail. The Sqlitening forum is not accepting registrations so I'll ask here. Hopefully someone here can shed some light.

My app uses Sqlitening 1.70 to connect in Local mode to a database on my PC. That works fine.

Here's the problem...
When I move the database to another PC on the same local network, install the Sqlitening Server service and try to slConnect it won't connect (error -16)

Here is a brief topology...
Win7 Pro Client PC IP: 192.168.1.50 <- My app runs here
Win7 Pro Server PC IP: 192.168.1.110 <-Sqlitening server running here ONLY
Default port: 51234

SQLiteningServer.cfg

[General]
ServiceNameSuffix=
Port = 51234
Hosts = Localhost
LogConnDcon=Yes
LogInvalidInMessage=Yes
CreateDatabaseAllowed=Yes
TrimLogManually=No
MaxChunkSize=
MaxConnections=
ConnectionTimeOut=

[FACT]
Data\BCM\BCM.db3 = *

On the Client PC, this is the statement that fails... slGetError returns Error -16 (Can' connect)

     
      slConnect("192.168.1.110",51234,"E0")
      iErr = slGetErrorNumber
      If iErr Then
           Appmsg(HWND_MAINFORM,"Database connection error: " &  Trim$(iErr))
           Exit Function
      End If

Things I've tried...
1. Pinged the server PC and opened R/W shares on it - no problems. (so its not a h/w connectivity issue)
2. Turned Windows Firewall OFF on both Win7 Server and Win7 Client (no AV firewall either)
3. Checked all sqlite3.dll versions are the same on client and server
4. Pulled my hair out for a bit...

Of course, I could connect directly in Local mode via a share.
But I'm assuming Remote mode is the way to go for multi-user (2 local concurrent clients are planned) OR IS IT?

Would appreciate some feedback... Thanks!
Ross

[Ross Boyd]

Solved.

The SQLiteningServer.cfg needed the host name of the Server Pc.
ie,
Hosts = SERVERNAME