InControl Community

Hi,
I would like to know if I can read and write into database without instantiating ODBC.

I would prefer to use SQLite as database.

Thanks for your commitment

Fabio

Hello Fabio,

If you take a look in the section Help --> Quickstart, you see a "Quickstart guide to ADO (PDF)". I would suggest that you read this quickstart guide and use the ADO functions to connect to your database.

Regards,

Bart

Now I have my database: TestDB.db (create using SQLite Express), How I can connect the DB with one ED project?

Where should I find the Data Link Proprieties?

Where should I write the connection string?

Thanks!!

Fabio

Have you an example?

Hi Fabio,

What you then need to do is to get a SQLite OLE DB Provider. There seem to be more versions available.
I found one here: http://cherrycitysoftware.com/ccs/Provi ... QLite.aspx
When you have it installed you can build a connectionstring that looks something like:
When the link works, and you can perform operations on the database, you can include it in your model (e.g. on reset or when you need to make the connection).

This is my code:
and I always get this msg:

Why?

Which errors I do?

Fabio

Hello Fabio,
There could be many reasons for this to occur.
Perhaps you can post a small example database here that can be used for reproduction?

Matthijs

This is the table STUDENTE of my database TestDB:

Could you make an example using this table?