• Welcome, Guest. Please login.
August 03, 2020, 11:46:18 pm


Welcome to the SQLitening support forums!

I need some enlightenment

Started by Marty Francom, February 07, 2011, 01:32:25 am

Previous topic - Next topic

Marty Francom

    I have a report writer that I would like to use to create reports from my SQLite database.  However, it can not connect. (Or at least it I can't find a way to connect to it).  In the docs it says to use an ODBC driver.  I am not sure what an ODBC driver is.     Can someone enlighten me?

   Would SQLiteningServer be an ODBC driver?   

    Fred,  if not,  would it be possible to compile the SQLiteningServer into an ODBC driver?

Fred Meier

QuoteWould SQLiteningServer be an ODBC driver?

Open Database Connectivity (ODBC) refers to a software API method for
using database management systems (DBMS).  ODBC was created so as to be
independent of programming languages or operational systems and offers
access to different database systems.  The standard ODBC consists of an
ODBC core and the respective specific ODBC database drivers.  The core,
also known as Driver manager, is independent of the database and acts as
an interpreter between the application and the database drivers.  The
database drivers, on the other hand, contain DBMS-specific details and
offer a mechanism for connecting with different ODBS-enabled database

SQLitening is also a software API method but only for SQLite and tailored
for PowerBasic.  So ODBC and SQLitening do the same thing but in a very
different way.  There is an ODBC driver for SQLite here
http://www.ch-werner.de/sqliteodbc/.  I have not used it.  I assume it will only
work on local databases not with SQLiteningServer. 

QuoteFred,  if not,  would it be possible to compile the SQLiteningServer into an ODBC driver?

Anything is possible with software but....  ODBC is very complex and I
have no current desire (nor may live long enough)to learn it. 

If you want to use a ODBC report writer with a SQLite database located on
a SQLiteningServer then it appears you options are (among others):
1. Copy the SQLite file to your local computer unsing FTP.
2. If the SQLite file is not huge use slGetFile.
3. Create a local SQLite file using slSel statements.   
4. Don't use ODBC, rather write a program that creates a CSV file
   on local computer and then use the report writer.  This would be my
   first choice cause ODBC drive are complex and must be installed on each
   local computer.

Fred Meier

My 2-cents worth about report writers.  I don't use them.  I tried but
found them to be too complex and normally can't handle all of the required
customization most reports need.  I wrote my own formatter and print
preview and can now produce custom reports with ease.  Also beware of the
following new feature to be available in PB10. 
QuotePrint Preview
Print Preview is a powerful concept which should be considered in most
applications that provide printed reports. Briefly, the idea involves
displaying a replica of a printed document on the screen before it is
committed to printing on paper. There are other related benefits as
well, such as the opportunity to save this replica report permanently
to a disk file. PowerBASIC offers a simple and straightforward method
to create printed reports which can be previewed on the screen.

I would be interested in hearing the Report Writing experience from other

Fredrick Ughimi


I use DDOC Print and Preview Report writter  by Don Dickinson (one of PB great programers). Its a shareware software that goes for $25. Been using it since I started using PB. Its been great. Used it with Cheetah and now with SQLitening. There is a demo download on his site (http://www.greatwebdivide.com/software.htm) .

Best regards,
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet