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

Rich Shepard schreef op 19/01/2015 om 20:40:
> 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.
did you tested the connection ? (button right under)
>   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