On Tue, 12 Feb 2008 15:07:32 -0500 Drew Jensen <[EMAIL PROTECTED]> dijo:
> > /usr/lib/odbc/libsqliteodbc.so = SQLite 2.x > > /usr/lib/odbc/libsqlite3odbc.so = SQLite 3.x > They arrived as a pair when you did the install in adept. > > 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 > OK - I think I got the situation now - well, under Linux it is not quite > as user friendly as under Windows for working with ODBC. But it's just a > matter of order - under windows you can create a new ODBC source from > the browser window - under Linux you need to have it already defined. > > So - startup ODBCConfig - > > Create a new User level datasource that connects to the Kexi database - > I would (did) use the 3x driver and in my case named it nwind_kexi. ( > note that if you start ODBCConfig with sudo you could also create a > system level datasource ) > > Now you can create a new Base file as you described - select Existing > database - ODBC - now when you click on the browse button you will see > the connection name you created in the step above. Select this, name and > save your Base file. That's it you are good to go. > > You can now create your mail merge document and select the Base file as > the data source. That did it! Yay! I swear that is exactly what I did last night and could not get it to work. I think the problem was in ODBCConfig, because when I fired it up to do this over again I noticed that the User DSN that I created last night was not listed. Maybe I thought I had created it but it was not actually created. In any event, I recreated it and later when I did Connect to Existing Database in Base the User DSN was listed. From then on it just worked perfectly. Now we need to take all these travails and instructions and fix them up in a neat, tidy how-to specifically for connecting Base to a Kexi database on Linux. The existing wiki has a lot of out of date information and side trips that have nothing to do with the specifics of how to connect a Kexi database to Base. Trying to follow the wiki was a large part of my problems. Thanks again for all your help! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
