Using Database without ODBC
Using Database without ODBC
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
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
Re: Using Database without ODBC
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
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
Re: Using Database without ODBC
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
Where should I find the Data Link Proprieties?
Where should I write the connection string?
Thanks!!
Fabio
Re: Using Database without ODBC
Have you an example?
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
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).
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:
Code: Select all
Provider=OleSQLite.SQLiteSource;Data Source=Path\To\TestDB.db
Re: Using Database without ODBC
This is my code:
and I always get this msg:
Code: Select all
ADOConnect([Provider=OleSQLite.SQLiteSource;Data Source=C:\Program Files (x86)\Enterprise Dynamics 8 Developer\Work\TestDB.db]),
ADOSetTable([Studente]),
ADOSetQuery([Select * from Studente]),
test := string(ADOReadQuery(2,2)),
msg(test),
ADOClose
Re: Using Database without ODBC
Why?
Which errors I do?
Fabio
Which errors I do?
Fabio
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
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
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
Re: Using Database without ODBC
This is the table STUDENTE of my database TestDB:
Re: Using Database without ODBC
Could you make an example using this table?