Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

On Mon, 19 Jan 2015, Rich Shepard wrote:

> LO-4.3.5, unixODBC-2.3.2, and sqliteodbc-0.9991, and sqlite-3.8.8 on
> Slackware-14.1. I use the build scripts provided on SlackBuilds.org, except
> for sqliteodbc which I built with the usual configure; make; make install.

  Some progress has been made. The sticking point now is Base not seeing the
DSN or driver. Deleted the existing .odb and started over; here are the
steps and the results:

  1.  File -> New -> Base.
  2.  Connect to an existing database; choose ODBC from dropdown list. Next.
  3.  Set up connection to the ODBC database (which I thought established
          the DSN): 'Browse' offers two choice: SQLite and the SQLite3 .db
          file name. I select the latter. Next.
  4.  Ignore user authentification. Next.
  5.  Save and proceed: accept defaults of registering database and opening
        the database for editing. Finish.
  6.  Assign an .odb filename and Save.

  See this error message:

  "The connection to the data source '<filename>' could not be established.
  "[unixODBC][Driver Manager] Data source name not found, and no driver
specified."

  I thought the DSN was specified in step 3, above. In /etc/unixodbc.ini is
[SQLITE3]
Description = SQLite3 ODBC Driver
Driver      = /usr/local/lib/libsqlite3odbc.so
Setup       = /usr/local/lib/libsqlite3odbc.so
Threading   = 2

  What am I doing incorrectly here?

Rich


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted