On Mon, 11 Feb 2008 03:40:36 +0000
"Drew Jensen" <[EMAIL PROTECTED]> dijo:
I am getting closer, but it still isn't working for me.
> You need to install the files libslq3odbc.so ( under adept that is
> libsqliteodbc )
Done.
> Then you need to configure ODBC ( I installed ODBCConfig I needed to reboot
> after install but it then automatically recognized the SQLite driver- you
> must start this from a command line also )
> Using ODBCConfig I created a User DSN that connected to nwind.kexi ( the file
> I created in Kexi )
The above instructions is where I think my problem is. I launched ODBCConfig
and configured the drivers. I now have:
Name Description Driver Lib
Setup Lib
SQLite SQLite ODBC Driver /usr/lib/odbc/libsqliteodbc.so
/usr/lib/odbc/libsqliteodbc.so
SQLite SQLite3 ODBC Driver /usr/lib/odbc/libsqlite3odbc.so
/usr/lib/odbc/libsqlite3odbc.so
I did that yesterday and I can't recall now why I have two drivers. I know I
got one of them from the wiki (same as the PDF).
I created the User DSN for my Kexi database and it went OK.
> Then create the Base file that uses this ODBC connection...LOL...ok it isn't
> that much..
Can you tell me exactly which buttons you used to do this. I still cannot
connect to the Kexi database, but the options in the Base wizard are not
comprehensible to me. Did you start with Create a New Database, Open an
Existing Database, or Connect to an Existing Database? And if I'm supposed to
Connect to an Existing Database, do I select ODBC, or which of the other
options in the drop-down box? I did this and clicked on Next, whereupon I got a
window asking for the "name of the ODBC database on your system." I tried the
browse button, but it opens a window that is blank (file browser function does
not work). I have typed in the Kexi database and path, but that didn't work. Or
should I enter here the User DSN name from ODBCConfig? I tried entering the
name of the User DSN, but that also did not work. Does it need a path?
I think I have all the components and files installed, but there are too many
options with no explanations of what they really do.
Thanks for the suggestions. I'm close, but I need step by step instructions.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
