[SOLVED] Anyone can tell me why I can't connect?
lazarus / 16-Databases

----------------------------------------------------------------------
1HuntnMan · 2025-05-14 19:14

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TFrmCntksMain.FormCreate(Sender: TObject);begin  SQLiteLibraryName:=
'sqlite3.dll';  //-> Connect the CONTACTS table... 
ConnectCntks.DatabaseName:= SysUtils.ExtractFilePath(ParamStr(0)) + 
 'ContactsDB.sqlite3';  ConnectCntks.Connected:= True; //--> ERROR
HERE 'Unknown Connector Type' :(  TransCntks.DataBase:= ConnectCntks; 
TransCntks.Action:= caCommit;  TransCntks.Active:= True; 
QryCntks.Transaction:= TransCntks;  QryCntks.Options:=
[sqoAutoApplyUpdates];  DSrcCntks.DataSet:= QryCntks; 
QryCntks.SQL.Text:=   'SELECT * FROM CONTACTS ContactsDB ORDER BY
LASTNAME, FIRSTNAME, MI';  QryCntks.UpdateSQL.Text:=   'UPDATE
CONTACTS SET CNTKID=:CNTKID, DATESTAMP=:DATESTAMP, LASTNAME=:LASTNAME,
'+   'FIRSTNAME=:FIRSTNAME, MI=:MI, CATEGORY=:CATEGORY, DOB=:DOB,
COMPANY=:COMPANY, '+   'TITLE=:TITLE, SPOUSE=:SPOUSE,
ADDRESS=:ADDRESS, ADDRESS2=:ADDRESS2, '+   'CITYTOWN=:CITYTOWN,
COUNTY=:COUNTY, STATEPROV=:STATEPROV, POSTALCODE=:POSTALCODE, '+ 
 'COUNTRY=:COUNTRY, CELLNO=:CELLNO, MAINPHONE=:MAINPHONE,
PHONE=:PHONE, '+   'FAX=:FAX, EMAIL=:EMAIL, EMAIL2=:EMAIL2,
WEBURL=:WEBURL, NOTES=:NOTES '+   'WHERE CNTKID=:OLD_CNTKID'; 
FormShow Procedure
  QryCntks.Open;

----------------------------------------------------------------------
CharlyTango · 2025-05-14 20:15

as I cannot recognize which object is ConnectCntks I have to rely on
guesswork

since you want to connect to SQLite, only TSQLConnector or
TSQLite3Connection comes into question.

Based on the error message, I assume that you are using TSQLConnector.
This type of connection acts as a kind of proxy connector that is able
to handle different connections to different databases. However, the
correct unit must be included in the uses clause (in your case
SQLite3Conn) and the type of connection must be specified

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ConnectCntks.ConnectorType:='SQLite3';
but these are only guesses because essential parts are not shown in
your code

----------------------------------------------------------------------
1HuntnMan · 2025-05-14 21:25

Fixed it, deleted the TSQLConnector and replaced it with
TSQLite3Connection.

----------------------------------------------------------------------
CharlyTango · 2025-05-15 06:50

TSQLConnector has its justification because you can use a different
SQL database just by changing the ConnectorType without having to
adapt or compile the program.
And since it is bad style for me to hard-code the user name/password
into the program, another parameter is not important.
You just have to be careful to stay close to the SQL-92 standard and
avoid individual special functions of each SQL server to stay
portable.
But this is not a problem for smaller applications IMO