Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?


This question is answered.


Permlink Replies: 4 - Last Post: Oct 8, 2015 1:32 PM Last Post By: Ted Falasco
Ted Falasco

Posts: 3
Registered: 12/30/11
Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 7:03 AM
Hello,

I am trying to connect an SQLite database to my VCL application. I am using C++ Builder 2010 professional. I drop a TSQLConnection component on my form, but when I go to select the driver, I only get options for BlackFishSQL, Datasnap, InterBase, and MySQL.

To be clear, I can already connect to an SQLite database using the C++ API by adding sqlite3.c to my project, including sqlite3.h, and doing something like this:

void __fastcall TMainFrm::OpenDb(void)
{
	sqlite3 *db;
	int returnCode = sqlite3_open("test.db", &db);
 
	if(returnCode)
	{
		ShowMessage("Couldn't open the database.");
	}
	else
	{
		ShowMessage("Opened database.");
	}
 
	sqlite3_close(db);
}


That all works fine. But I would like to connect some excellent DevEx components, which requires having a connection component such as TSQLConnection or TADOConnection.

I can buy a dbExpress license for SQLite3 from DevArt, but I was hoping there was one that either came with my Builder purchase or that Embarcadero provided for free. I've Googled around and explored the Embarcadero Developer Network, but I haven't found a definitive answer either way. The closest I came was a post that claimed to allow a free driver, but it was only the 30-day demo version of DevArt's.

Any ideas, folks?

Thanks!
-Ted
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 9:50 AM   in response to: Ted Falasco in response to: Ted Falasco
Ted Falasco wrote:
Hello,

I am trying to connect an SQLite database to my VCL application. I am using C++ Builder 2010 professional. I drop a TSQLConnection component on my form, but when I go to select the driver, I only get options for BlackFishSQL, Datasnap, InterBase, and MySQL.

To be clear, I can already connect to an SQLite database using the C++ API by adding sqlite3.c to my project, including sqlite3.h, and doing something like this:

void __fastcall TMainFrm::OpenDb(void)
{
	sqlite3 *db;
	int returnCode = sqlite3_open("test.db", &db);
 
	if(returnCode)
	{
		ShowMessage("Couldn't open the database.");
	}
	else
	{
		ShowMessage("Opened database.");
	}
 
	sqlite3_close(db);
}


That all works fine. But I would like to connect some excellent DevEx components, which requires having a connection component such as TSQLConnection or TADOConnection.

I can buy a dbExpress license for SQLite3 from DevArt, but I was hoping there was one that either came with my Builder purchase or that Embarcadero provided for free. I've Googled around and explored the Embarcadero Developer Network, but I haven't found a definitive answer either way. The closest I came was a post that claimed to allow a free driver, but it was only the 30-day demo version of DevArt's.

Any ideas, folks?

Thanks!
-Ted

No, SQLLite is part of the C/S add-on pack for Pro (well is currently, not sure
it was available for 2010).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Ted Falasco

Posts: 3
Registered: 12/30/11
Re: Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 1:09 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thanks for the response, Jeff.

Jeff Overcash (TeamB) wrote:
SQLLite is part of the C/S add-on pack for Pro

What is the C/S add-on pack? Maybe I just need to install that.

-Ted
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 1:16 PM   in response to: Ted Falasco in response to: Ted Falasco
Ted Falasco wrote:
Thanks for the response, Jeff.

Jeff Overcash (TeamB) wrote:
SQLLite is part of the C/S add-on pack for Pro

What is the C/S add-on pack? Maybe I just need to install that.

-Ted

It is the client server add on pack you could buy separately.

http://store.embarcadero.com/542/catalog/category.44669/language.en/currency.USD/?id=IeuTAd7i39

Problem is I am not sure they still offer it for 2010. You will need to contact
sale directly more than likely and not use the shop. In XE3 it was renamed the
FireDac C/S add-on but still delivers the DBX drivers I believe. The 2010
version was DBX only (predates the introduction of FireDAC)

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Ted Falasco

Posts: 3
Registered: 12/30/11
Re: Does C++ Builder 2010 Pro come with a dbExpress driver for SQLite?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 1:32 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Fantastic. Thank you very much, Jeff. I'll give them a call.

-Ted
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02