Exporting

[dcalp]

Hello:
Fantastic software, congratulations!

I can't make export to work. After selecting File - Export a dialog informs xdodbc not fount, please reinstall. Ie just installed it.
After that the exporting wizard continues, but I wasn't able to export to Excel or CSV.

I'm working on Ubuntu Feisty.

Thanks!

Diego

[Ben]

Hello,

My guess is that you need to install unixodbc. Please note there are two odbc's for linux, unixodbc and iodbc. My understanding is that strata runs with unixodbc. After you install unixodbc, that error message should disappear.

All the best,
Ben

[ericschrauth]

I have unixodbc installed, but get the same message. What I am trying to do is create a connection to an Oracle database (xe on my local (ubuntu) machine). Any clues?[quote]

[Ben]

Hello,

Are you sure that your unixodbc is installed in a path which is included in your /etc/ld.so.conf file? If it is, can you tell me what version number of unixodbc you have? I will attempt to duplicate your problem.

All the best,
Ben

[amk]

This also looks like a problem I get.

kubuntu 7.04 Fiesty Fawn (I rather doubt the "k" makes a difference here)
strata 4.0 beta 3
unixodbc 2.2.11-13, from Fiesty's main apt repository

'cat /etc/ld.so.conf' gives 'include /etc/ld.so.conf.d/*.conf'
The only file in '/etc/ld.so.conf.d' is 'i486-linux-gnu', which contains:
# Multiarch support
/lib/i486-linux-gnu
/usr/lib/i486-linux-gnu

Both these directories are empty.

unixodbc .so files are in /usr/lib and /usr/lib/odbc

I've tried adding another file to /etc/ld.so.conf.d/ with the the above directories, and also with the actual .so files, run sudo ldconfig and restarted Strata to no apparent affect. My understanding is that ldconfig should look in /usr/lib regardless of /etc/ld.so.conf

'/lib/ld-linux.so.2 --list /opt/kstrata/bin/kstrata | grep odbc' gives nothing.

'/lib/ld-linux.so.2 /opt/kstrata/bin/xdodbc.so' gives 'undefined symbol: _ZN3xcm5mutexC1Ev' which strikes me as odd.

'/lib/ld-linux.so.2 --list /opt/kstrata/bin/xdodbc.so | grep odbc' gives
libodbc.so.1 => /usr/lib/libodbc.so.1 (0xb7ddf000)
libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0xb7dd4000)

'sudo ldconfig -v | grep odbc' gives
libodbccr.so.1 -> libodbccr.so.1.0.0
libodbcinst.so.1 -> libodbcinst.so.1.0.0
libodbc.so.1 -> libodbc.so.1.0.0

So it looks like libodbc.so is being linked correctly.

The MD5 of xdodbc.so is 68336eeb85e328a7f666507ad0765426

Hopefully some of that lot will be of use

[Ben]

Hi,

Many thanks for the excellent bug report. I'll use this information in my testing. I'll keep you posted.

All the best,
Ben

[Ben]

Hello,

I think I've nailed this bug. Thanks for your post, it helped me fix the problem. You'll see the fix in the upcoming Beta 4 (real soon now).

Thanks,
Ben

[amk]

I've tested Beta 4 with the table on the default start page. There's no more complaining about xdodbc, and no error messages unless noted.

Testing "save as external" and "export" with each file type:

Save as external...

csv OK
tsv File contains column headers only
dbf OK, loads correctly into Strata
mdb No file
xls No file
kpg OK

Export
For csv and dbf files, Strata tests for existing directory from filesystem root but then saves files using user's home directory as root, creating extra directories as needed. For example, I try to save to
/home/me/myexportedfiles/
Strata saves in
/home/me/home/me/myexportedfiles/

If I try to save to /home/ or / Strata seg faults.

Saving to a kpg file creates it in the correct place.

kpg Cannot import back into Strata
csv Column headers only
dbf Column headers only using "open", an extra line of apparent garbage with "import"

mdb and xls: After offering to create the file in a popup, gives a popup with:
"There was an error connecting to the specified Microsoft (Access|Excel) file.
Please make sure that the file exists and that it is not currently in use."
Checking the append box seems to make no difference.

Retrying something I tried before...
/lib/ld-linux.so.2 /opt/kstrata/bin/xdodbc.so
Segmentation fault (core dumped)

Running /lib/ld-linux.so.2 --list on each .so in /opt/kstrata/bin
xdaccess.so: error while loading shared libraries: libmdb.0: cannot open shared object file: No such file or directory
xdmysql.so OK
xdodbc.so OK
xdsqlserver.so: error while loading shared libraries: libtds.so.5: cannot open shared object file: No such file or directory
xdfs.so OK
xdnative.so OK
xdoracle.so: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Still on kubuntu 7.04, unixodbc Version: 2.2.11-13

[Dave]

Hello,

Thanks so much for this thorough bug report. We'll definitely look into each of these issues and keep you posted.

Thanks!

Dave.

#356