Setup Database 101??
Posted: Wed 21 Dec 2011 15:46
Hi,
I just need a "Hello World" app or help setting up my first table with data in it using DBXpress driver for SQLite in DXE2 Professional.
I have installed the driver and it now appears in the XE2 data Explorer window. I tried "add new connection" and see it there with a little red "x" by it. When I try to "modify connection parameters" from there, I think i need to make some entries for Server Name, database Name, User, and Password - but have no idea what to enter. I have no established connection or database at this time. I am trying to create my first simple connection and table as a LOCAL database.
When I try a simple app of my own, or the demo app supplied with the installation from Devart, I get errors:
1) SimpleDataSet.dproj from Devart demos compiling:
file not found: Exceptionlog.dcu
2) my own form with a connection, simple dataset, and table on it:
form compiles, but if I try to add a field to the table which is new and blank, I get the message "Cannot load client library: sqlite3.dll".
I will be creating a relational database with about 60 tables, all Local for now - but plan to create the database and with new tables and indexes in the DataBase Explorer of Delphi. But for now, all I need is a start on getting a basic connection and making a table in a form!
Thanks!
P Scott
I just need a "Hello World" app or help setting up my first table with data in it using DBXpress driver for SQLite in DXE2 Professional.
I have installed the driver and it now appears in the XE2 data Explorer window. I tried "add new connection" and see it there with a little red "x" by it. When I try to "modify connection parameters" from there, I think i need to make some entries for Server Name, database Name, User, and Password - but have no idea what to enter. I have no established connection or database at this time. I am trying to create my first simple connection and table as a LOCAL database.
When I try a simple app of my own, or the demo app supplied with the installation from Devart, I get errors:
1) SimpleDataSet.dproj from Devart demos compiling:
file not found: Exceptionlog.dcu
2) my own form with a connection, simple dataset, and table on it:
form compiles, but if I try to add a field to the table which is new and blank, I get the message "Cannot load client library: sqlite3.dll".
I will be creating a relational database with about 60 tables, all Local for now - but plan to create the database and with new tables and indexes in the DataBase Explorer of Delphi. But for now, all I need is a start on getting a basic connection and making a table in a form!
Thanks!
P Scott