• Welcome, Guest. Please login.
October 25, 2021, 09:29:41 PM


Welcome to the SQLitening support forums!

Some progress, but no brass ring

Started by ken_anthony, August 10, 2016, 05:16:21 PM

Previous topic - Next topic


This runs both locally on my computer (and its IP) and my server and works, but when I try to connect from my computer to the server it fails. I did open port using the bat provided. I don't know what else to try.

QuoteSub Say(s1 As String)
    MsgBox s1, %MB_TaskModal Or %MB_IconInformation, "Information"
End Sub

Function PBMain () As Long
    slConnect "", 51234
    slOpen "data\gqH_01_01.db"
    slSel "select * from stars where rowID =1;"
    If slGetRow Then
        say "record found."
    End If
End Function

This is my CFG file...

Port = 51234
Hosts = LocalHost,

Test.Sld = Goffy, AnotherPassWord,   ReadOnly%Password,
TestX.Sld = Goffy, AnotherPassWord,  ReadOnly%Password
>AEntry1 = pass
TestData\NewspaperNew.Jpg = *
Test1.Dat =
Test1A.Dat   =*
Test1X.Dat  =!
Test - Copy.Sld=
Test Or Retired\CopyDatabase\New.Sld =
RemoteFileUploadDownloadExample.Txt =


QuoteWhat does open the port using a BAT mean?

I created a bat file using the link you provided full of netsh commands which ran without error. I just got off the phone with godaddy support and apparently they have multiple levels of firewall protection. I have to wait until payday two weeks from now before I can afford the two minutes of support I need from them to solve the problem. At this point patience is all I can afford.

Just to reiterate my status. The service installs and runs fine. My test program has no problem selecting a record when run on the server. I know my test program is using the remote call even when run on the server because when I stop the service it reports no connection as it should. Restart the service and it pulls up a record.

So in 2 weeks I'll pay them 8% of my income and get the problem solved. Then I'll report my success right here.

Thanks for your support. Hopefully one day it will be more than just thanks.


One horrible thought I just had...When I follow slConnect with slOpen how do I know it's actually using the service rather than just working locally? Is it possible for it to connect but not use the connection?


I've got the files. I will run some tests and report the results.


This are file sizes...
                      yours      mine
slClient.Dll                   54,784            missing
sqlite3.dll                         829,669            599,419
sqlite3.exe                        575,488            missing
SQLitening.dll            93,184            91,648
SQLiteningAuxRuts.dll        30,208            same
SQLiteningClient.dll              54,784            same
SQLiteningS.dll                   11,776            same
SQLiteningServer.exe             128,512            124,928
SQLiteningServerAdmin.exe     93,696      same
SQLiteningU.dll                    15,360       same
SQLiteningZlib.dll                    74,240       same
SQLiteningProcsA.Dll            missing      15,872
SQLiteningProcsB.Dll            missing      8,192
SQLiteningServerExits.Dll       missing      21,504
SQLiteningServerMonitor.Exe  missing     12,288

Mine are from 170 zip.

I get error 16 testing against your files.


I'm on a virtual w2012r2 server. I will make the changes so I can see the log. I'm not comfortable making ad hoc changes to code without thoroughly understanding them. Could you put together a new package (version 171?)

It's good that you've been able to establish a connection. Gives me hope.


cj, If you're using Godaddy be aware they have 2 firewalls. One you have access to and the other only they have access to. They will open those ports for you. On the lower cost unmanaged system I have, I have to pay them a fee for any changes they make for me. Since I feel confident I can manage everything I need to with RDP I thought I'd save some of my pitiful income that way. My hope is for this project to change pitiful to plentiful.


Reinstalled with LogConnDcon=Yes.

Also removed LocalHost from list. Still getting error 16.

Quote160811131114 Admn Strt ==========<[ Start Server ]>==========
160811131114 Admn Flgs TrimLogManually=Yes
160811131114 Admn Flgs LogConnDcon=Yes
160811131114 Admn Flgs LogInvalidInMessage=No
160811131114 Admn Flgs CreateDatabaseAllowed=No
160811131114 Admn Data MaxChunkSize=500
160811131114 Admn Data MaxConnections=10000
160811131114 Admn Data ConnectionTimeout=30
160811131114 Admn FACT Loaded
160811131114 Host  Socket=412  Port=51234  ServiceNameSuffix=
160811131130 Conn #3 SK 412 kjmortensonS192-169-142-16192.169.142.164
160811131134 Dcon #3 Dropped


Yes! Your connections did show up in my log. Now if I can just get there as well.

I did further testing and it appears I only connect to LocalHost. I thought perhaps my wifi IP changed, but that wasn't it.


August 13, 2016, 07:19:38 AM #9 Last Edit: February 04, 2020, 07:54:03 AM by cj
I have had bad luck using IpAddress, Computer Name
SQLiteningServer.exe quit starting on one machine using Windows 10 when using the Computer Name.