[SOLVED] Anyone can tell me why I can't connect?

[1HuntnMan]

 

Code: Pascal  [Select][+][-]

1. procedure TFrmCntksMain.FormCreate(Sender: TObject);
2. begin
3.   SQLiteLibraryName:= 'sqlite3.dll';
4.   //-> Connect the CONTACTS table...
5.   ConnectCntks.DatabaseName:= SysUtils.ExtractFilePath(ParamStr(0)) +
6.    'ContactsDB.sqlite3';
7.   ConnectCntks.Connected:= True; //--> ERROR HERE 'Unknown Connector Type' :(
8.   TransCntks.DataBase:= ConnectCntks;
9.   TransCntks.Action:= caCommit;
10.   TransCntks.Active:= True;
11.   QryCntks.Transaction:= TransCntks;
12.   QryCntks.Options:= [sqoAutoApplyUpdates];
13.   DSrcCntks.DataSet:= QryCntks;
14.   QryCntks.SQL.Text:=
15.    'SELECT * FROM CONTACTS ContactsDB ORDER BY LASTNAME, FIRSTNAME, MI';
16.   QryCntks.UpdateSQL.Text:=
17.    'UPDATE CONTACTS SET CNTKID=:CNTKID, DATESTAMP=:DATESTAMP, LASTNAME=:LASTNAME, '+
18.    'FIRSTNAME=:FIRSTNAME, MI=:MI, CATEGORY=:CATEGORY, DOB=:DOB, COMPANY=:COMPANY, '+
19.    'TITLE=:TITLE, SPOUSE=:SPOUSE, ADDRESS=:ADDRESS, ADDRESS2=:ADDRESS2, '+
20.    'CITYTOWN=:CITYTOWN, COUNTY=:COUNTY, STATEPROV=:STATEPROV, POSTALCODE=:POSTALCODE, '+
21.    'COUNTRY=:COUNTRY, CELLNO=:CELLNO, MAINPHONE=:MAINPHONE, PHONE=:PHONE, '+
22.    'FAX=:FAX, EMAIL=:EMAIL, EMAIL2=:EMAIL2, WEBURL=:WEBURL, NOTES=:NOTES '+
23.    'WHERE CNTKID=:OLD_CNTKID';
24.  

FormShow Procedure
  QryCntks.Open;

[CharlyTango]

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][+][-]

1. ConnectCntks.ConnectorType:='SQLite3';

but these are only guesses because essential parts are not shown in your code

[1HuntnMan]

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

[CharlyTango]

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