Hello,
Recently i bought UniDAC. My primary goal is to use it for SQLite.
I used the UniLite Demo and the UniDAC demo before i bought UniDAC, so i was sure that what i wanted would work. In both demos i made a connection to an SQLite database, and in both demos it worked. I used a TUniConnection, TUniTable and a TUniDataSource (or the Lite equivalent). Nothing more and i had a running connection. It took me some time to set that up. And because of that, now that i have the full version, i seem to have forgotten how to make the connection again. Sadly, i dont have the code for the demo that i used anymore. How stupid can i be.
Can anyone tell me what i need to enter in designtime to make the connection valid?
How to make a SQLite connection with UniDAC
Re: How to make a SQLite connection with UniDAC
Before, i had the database file in the Database Property. That did not work. In the FAQ it says that SQLite is not supported in this way?
Here is what i did:
ProviderName: SQLite
Server: Database.s3db
When i try to connect, it says.....
SQLite provider is not registered
You should add the SQLiteUniProvider unit to the uses clause of any unit in your project or place the TSQLiteUniProvider component on the form.
I do not have the ....UniProvider component.
How do i set up this connection?
All i want is the connection to work in design time. The rest i can figure out myself, since it is basically the same as Delphi and ADO.
Here is what i did:
ProviderName: SQLite
Server: Database.s3db
When i try to connect, it says.....
SQLite provider is not registered
You should add the SQLiteUniProvider unit to the uses clause of any unit in your project or place the TSQLiteUniProvider component on the form.
I do not have the ....UniProvider component.
How do i set up this connection?
All i want is the connection to work in design time. The rest i can figure out myself, since it is basically the same as Delphi and ADO.
Re: How to make a SQLite connection with UniDAC
I found a bug in UniDAC. Or at least, i consider it a bug.
In deinstalled the full version and installed the Demo again. When i install the demo en connect, NO Problem. Everything works as it should.
After that, i install the Full version OVER the demo version. This i did intentionally, because the previous time, i deinstalled the demo first, which caused the problem (i thought).
After installing the full version i tried to connect again. I could NOT connect.
The reason was the following.....
In the demo version, i can enter the Database field where my database file on disk is.
In the full version, i can NOT enter the Database field in the connection screen. It is grayed out there. Please tell me what i need to do to correct this.
In deinstalled the full version and installed the Demo again. When i install the demo en connect, NO Problem. Everything works as it should.
After that, i install the Full version OVER the demo version. This i did intentionally, because the previous time, i deinstalled the demo first, which caused the problem (i thought).
After installing the full version i tried to connect again. I could NOT connect.
The reason was the following.....
In the demo version, i can enter the Database field where my database file on disk is.
In the full version, i can NOT enter the Database field in the connection screen. It is grayed out there. Please tell me what i need to do to correct this.
Re: How to make a SQLite connection with UniDAC
Hello,
You are using the standard UniDAC version which includes no data access providers and may only be used together with the other DAC products (ODAC, MyDAC, IBDAC, PgDAC, SDAC, LiteDAC). Data access providers are available only in the professional UniDAC version. Therefore, you need to update the Standard edition to Professional. To update the version, you need to contact our Sales Department at sales*devart*com.
Detailed information about UniDAC versions is available at our website: http://www.devart.com/unidac/editions.html
You are using the standard UniDAC version which includes no data access providers and may only be used together with the other DAC products (ODAC, MyDAC, IBDAC, PgDAC, SDAC, LiteDAC). Data access providers are available only in the professional UniDAC version. Therefore, you need to update the Standard edition to Professional. To update the version, you need to contact our Sales Department at sales*devart*com.
Detailed information about UniDAC versions is available at our website: http://www.devart.com/unidac/editions.html