Announcement

Collapse
No announcement yet.

Sqlitening Local vs Remote connection

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sqlitening Local vs Remote connection

    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
    Code:
    [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)
    Code:
         
          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

  • #2
    Solved.

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

    Comment

    Working...
    X