Menu
▾
▴
mdbtools-dev
This list is closed, nobody may subscribe to it.
| 2000 |
Jan
|
Feb
(1) |
Mar
(53) |
Apr
(28) |
May
(5) |
Jun
(7) |
Jul
(16) |
Aug
(15) |
Sep
(10) |
Oct
(1) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(9) |
Feb
(7) |
Mar
(1) |
Apr
(7) |
May
(6) |
Jun
|
Jul
(15) |
Aug
(10) |
Sep
(2) |
Oct
(12) |
Nov
(3) |
Dec
(2) |
| 2002 |
Jan
(2) |
Feb
(12) |
Mar
(33) |
Apr
(30) |
May
(5) |
Jun
(18) |
Jul
(18) |
Aug
(47) |
Sep
(8) |
Oct
(7) |
Nov
(8) |
Dec
(13) |
| 2003 |
Jan
(48) |
Feb
(8) |
Mar
(10) |
Apr
(30) |
May
(6) |
Jun
(8) |
Jul
(19) |
Aug
(36) |
Sep
(19) |
Oct
(16) |
Nov
(11) |
Dec
(17) |
| 2004 |
Jan
(11) |
Feb
(22) |
Mar
(52) |
Apr
(45) |
May
(18) |
Jun
(72) |
Jul
(14) |
Aug
(31) |
Sep
(19) |
Oct
(27) |
Nov
(19) |
Dec
(25) |
| 2005 |
Jan
(16) |
Feb
(46) |
Mar
(50) |
Apr
(3) |
May
(21) |
Jun
(3) |
Jul
(24) |
Aug
(33) |
Sep
(25) |
Oct
(23) |
Nov
(30) |
Dec
(20) |
| 2006 |
Jan
(12) |
Feb
(11) |
Mar
(8) |
Apr
(15) |
May
(27) |
Jun
(15) |
Jul
(19) |
Aug
(5) |
Sep
(9) |
Oct
(1) |
Nov
(2) |
Dec
(3) |
| 2007 |
Jan
|
Feb
(3) |
Mar
(18) |
Apr
(5) |
May
(9) |
Jun
|
Jul
(10) |
Aug
(3) |
Sep
(8) |
Oct
(1) |
Nov
(7) |
Dec
(9) |
| 2008 |
Jan
(2) |
Feb
|
Mar
(10) |
Apr
(4) |
May
|
Jun
(5) |
Jul
(9) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(8) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(11) |
Nov
(1) |
Dec
(20) |
| 2010 |
Jan
|
Feb
(2) |
Mar
|
Apr
(7) |
May
|
Jun
(23) |
Jul
(3) |
Aug
(6) |
Sep
(1) |
Oct
(4) |
Nov
(1) |
Dec
|
| 2011 |
Jan
(1) |
Feb
(26) |
Mar
(25) |
Apr
(11) |
May
(5) |
Jun
(5) |
Jul
(2) |
Aug
(39) |
Sep
(12) |
Oct
(6) |
Nov
|
Dec
|
| 2012 |
Jan
(19) |
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(7) |
Jul
|
Aug
(8) |
Sep
|
Oct
(3) |
Nov
(2) |
Dec
(3) |
| 2013 |
Jan
(6) |
Feb
|
Mar
(1) |
Apr
|
May
(7) |
Jun
(5) |
Jul
(2) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2014 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(5) |
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
|
From: Gary S. <ga...@pr...> - 2004-03-19 16:59:09
|
It's been a while since I've heard anything on this list. It's usually = quiet... =20 Gary ________________________________ From: mdb...@li... on behalf of Leonard = Leblanc Sent: Fri 3/19/2004 7:46 AM To: mdb...@li... Subject: [mdb-dev] Hello Hello All, I just wanted to drop a quick note to say hello and notify everyone that I am interested in helping with development of this tool. I just wanted to touch base and find out what other people are working on. From there I can decide where I can help. -- Leonard Leblanc President MacroElite Computers P: 204-782-9233 W: www.macroelite.ca ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli= ck _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Jeff S. <why...@ya...> - 2004-03-19 16:13:23
|
Welcome, there is *plenty* of work left to go around. :-) I have only been here a little while, but from what I have seen, Brian does the bulk of real development. I have submitted several small bug and warnings fixes and have an almost-working implementation of SQLTables for the ODBC driver ready (there is a bug in deleting temporary tables that I have not yet tracked down that is causing problems in testing it). After that on my TODO list is SQLColumns. Implementing SQLTables and SQLColumns should help some of the unixODBC tools work with mdbtools better. -- Jeff Smith --- Leonard Leblanc <lle...@ma...> wrote: > Hello All, > > I just wanted to drop a quick note to say hello and notify everyone that > I am interested in helping with development of this tool. > > I just wanted to touch base and find out what other people are working > on. From there I can decide where I can help. > > -- > Leonard Leblanc > President > MacroElite Computers > P: 204-782-9233 > W: www.macroelite.ca > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev __________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com |
|
From: Leonard L. <lle...@ma...> - 2004-03-19 15:46:49
|
Hello All, I just wanted to drop a quick note to say hello and notify everyone that I am interested in helping with development of this tool. I just wanted to touch base and find out what other people are working on. From there I can decide where I can help. -- Leonard Leblanc President MacroElite Computers P: 204-782-9233 W: www.macroelite.ca |
|
From: fabien r. <ro...@mn...> - 2004-03-17 11:07:28
|
Hello, I'm trying to setup mdbtools on my computer. Unfortunately, it doesn't work neither with source, nor with cvs, nor with rpms. However, I've installed all the necessary packages... When I launched the ./autogen.sh, an error appears: [root@crozet mdbtools]# ./autogen.sh -quiet processing . Running libtoolize... Running aclocal ... Running autoheader... configure.in:21: warning: AC_TRY_RUN called without default to allow cross compiling Running automake --gnu ... Running autoconf ... configure.in:21: warning: AC_TRY_RUN called without default to allow cross compiling autoconf: Undefined macros: configure.in:114:AC_CONFIG_FILES([src/Makefile]) Running ./configure -quiet ... loading cache ./config.cache creating libtool ./configure: line 6400: syntax error near unexpected token `src/Makefile' ./configure: line 6400: `AC_CONFIG_FILES(src/Makefile)' It seems the autogen can't see the Macro AC_CONFIG_FILES... What can I do? Thanks Fabien |
|
From: <br...@br...> - 2004-03-14 02:10:24
|
I don't know for sure, but I'd assume that information is stored in the LvProp column of each database object. It's an OLE column that would need to be parsed out (there's some preliminary code in the mdb-prop program but it's far from complete). Brian On Sat, 13 Mar 2004 14:21:42 -0800 (PST), dang minh long wrote: I'm try to access mdb file and I want to know how to extract the font used in the file. Can you tell me how? Thanks.Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam |
|
From: dang m. l. <min...@ya...> - 2004-03-13 22:21:49
|
I'm try to access mdb file and I want to know how to extract the font used in the file. Can you tell me how? Thanks. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam |
|
From: <br...@br...> - 2004-03-13 15:32:44
|
I'm not having any problems here. Can you 1) run it on the Access 97 sample databases (northwind) and 2) export MDBOPTS="debug_row" and send the results of mdb-tables on your database to me? Cheers, Brian On Fri, 12 Mar 2004 15:38:31 +0000, Will Newton wrote: > > > I have a large Jet3 database that used to work to some extent with CVS > mdbtools (about 3 weeks to a month ago). Unfortunately now it fails to > read the database catalog, so it's rather broken. > > I get a lot of: > > WARNING: number of table columns (17) does not match number of row > columns (1), strange results may occur > > these messages. I added the column numbers in myself, BTW. > > Any ideas what could be going wrong? > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Jeff S. <why...@ya...> - 2004-03-12 22:11:40
|
I now see why I still have this problem: I have unixODBC installed in a non-standard location, and the configure script is not using what I supply with --with-unixodbc to look for libodbcinst. I had managed to work around a related problem in src/odbc/Makefile, but it looks like the whole problem just needs a real fix. BTW, I am not convinced that this SQLGetPrivateProfile stuff is the right way to go (I believe I know how to fix the old method). But maybe I need to take a better look at it before passing judgement :-). -- Jeff Smith --- br...@br... wrote: > This should indeed be fixed very recently in CVS. We now autodetect > libodbcinst and call SQLGetPrivateProfile instead of the old method. > If this is not working, please let me know. > > Brian > > On Thu, 11 Mar 2004 12:23:27 -0800 (PST), Jeff Smith wrote: > > > > > I have had the same problem. I thought it was supposed to be fixed. > > In the mean-time, put it in $HOME/.odbc.ini instead, as it does seem > > to work from there (for me at least). > > > > -- Jeff Smith > > > > > > --- mik...@co... wrote: > > > I seem to get this error with isql no matter what I do > > > > > > LoadDSN returned FALSE[unixODBC]Could not find DSN in odbc.ini > > > [ISQL]ERROR: Could not SQLConnect > > > > > > Here is my odbc.ini file > > > > > > > > > [extreme] > > > Description = MS Access > > > Driver = MDBToolsODBC > > > Database = /home/vipuser/xstreem1.mdb > > > UserName = > > > Password = > > > port = 5432 > > > > > > I am using the driver > > > Driver = /usr/lib/libmdbodbc.so.0 > > > > > > > > > Any ideas why I cannot get this to work? __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: Will N. <wi...@gb...> - 2004-03-12 15:57:33
|
I have a large Jet3 database that used to work to some extent with CVS mdbtools (about 3 weeks to a month ago). Unfortunately now it fails to read the database catalog, so it's rather broken. I get a lot of: WARNING: number of table columns (17) does not match number of row columns (1), strange results may occur these messages. I added the column numbers in myself, BTW. Any ideas what could be going wrong? |
|
From: <br...@br...> - 2004-03-12 01:27:28
|
This should indeed be fixed very recently in CVS. We now autodetect libodbcinst and call SQLGetPrivateProfile instead of the old method. If this is not working, please let me know. Brian On Thu, 11 Mar 2004 12:23:27 -0800 (PST), Jeff Smith wrote: > > I have had the same problem. I thought it was supposed to be fixed. > In the mean-time, put it in $HOME/.odbc.ini instead, as it does seem > to work from there (for me at least). > > -- Jeff Smith > > > --- mik...@co... wrote: > > I seem to get this error with isql no matter what I do > > > > LoadDSN returned FALSE[unixODBC]Could not find DSN in odbc.ini > > [ISQL]ERROR: Could not SQLConnect > > > > Here is my odbc.ini file > > > > > > [extreme] > > Description = MS Access > > Driver = MDBToolsODBC > > Database = /home/vipuser/xstreem1.mdb > > UserName = > > Password = > > port = 5432 > > > > I am using the driver > > Driver = /usr/lib/libmdbodbc.so.0 > > > > > > Any ideas why I cannot get this to work? > > > __________________________________ > Do you Yahoo!? > Yahoo! Search - Find what you�re looking for faster > http://search.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Jeff S. <why...@ya...> - 2004-03-11 20:41:57
|
I have had the same problem. I thought it was supposed to be fixed. In the mean-time, put it in $HOME/.odbc.ini instead, as it does seem to work from there (for me at least). -- Jeff Smith --- mik...@co... wrote: > I seem to get this error with isql no matter what I do > > LoadDSN returned FALSE[unixODBC]Could not find DSN in odbc.ini > [ISQL]ERROR: Could not SQLConnect > > Here is my odbc.ini file > > > [extreme] > Description = MS Access > Driver = MDBToolsODBC > Database = /home/vipuser/xstreem1.mdb > UserName = > Password = > port = 5432 > > I am using the driver > Driver = /usr/lib/libmdbodbc.so.0 > > > Any ideas why I cannot get this to work? __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: <mik...@co...> - 2004-03-11 17:22:50
|
I seem to get this error with isql no matter what I do LoadDSN returned FALSE[unixODBC]Could not find DSN in odbc.ini [ISQL]ERROR: Could not SQLConnect Here is my odbc.ini file [extreme] Description = MS Access Driver = MDBToolsODBC Database = /home/vipuser/xstreem1.mdb UserName = Password = port = 5432 I am using the driver Driver = /usr/lib/libmdbodbc.so.0 Any ideas why I cannot get this to work? |
|
From: Jeff S. <why...@ya...> - 2004-03-09 18:31:10
|
src/libmdb/data.c:1076 is: td = mdb_get_double(mdb, start); should be: td = mdb_get_double(mdb->pg_buf, start); -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: Jeff S. <why...@ya...> - 2004-03-09 16:24:30
|
Line 54 of src/sql/lexer.l has a small bug. Line 54 reads:
(-*[0-9]+|([0-9]*\.[0-9+)([eE][-+]?[0-9]+)?) {
and it should read:
(-*[0-9]+|([0-9]*\.[0-9]+)([eE][-+]?[0-9]+)?) {
-- Jeff Smith
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
|
|
From: <br...@br...> - 2004-03-08 20:56:56
|
On Mon, 8 Mar 2004 11:40:19 -0800 (PST), Jeff Smith wrote: > > 1.) Way down in mdb_crack_row3, col_ptr is defined and initialized. > This is C, so the definition really belongs with the other definitions > at the beginning of the function. This was caught trying to compile > on a machine with a slightly older version of GCC (2.95.3). > Hmm...not my style, probably from a contributed patch. Fixed in my tree, will commit tonight with the others if I finish getting this wood flooring put in (manual labor, ack!). > 2.) In parser.y, I see one can compare constant with identifier, > identifier with constant, and constant with constant. Why would one > compare constant with constant, and why can one not compare identifier > with identifier? Also, comparing constant with constant does not > free() > up the parts of the expression, as the other comparisons do. A common construct is "select * from table where 0=1" The OpenOffice odbc linkage does this for one, to get the list of column names. It's a quite portable and reliable way of doing it actually. As far as identifier = identifier it's just not yet implemented. It needs some support in libmdb which isn't there... > 3.) 'describe table' was giving me some strange values for size, and I > found the bug in src/sql/mdbsql.c, line 655. The second arguement > should be col_size, not tmpstr. cut & paste error...my bad. |
|
From: Jeff S. <why...@ya...> - 2004-03-08 19:56:58
|
1.) Way down in mdb_crack_row3, col_ptr is defined and initialized. This is C, so the definition really belongs with the other definitions at the beginning of the function. This was caught trying to compile on a machine with a slightly older version of GCC (2.95.3). 2.) In parser.y, I see one can compare constant with identifier, identifier with constant, and constant with constant. Why would one compare constant with constant, and why can one not compare identifier with identifier? Also, comparing constant with constant does not free() up the parts of the expression, as the other comparisons do. 3.) 'describe table' was giving me some strange values for size, and I found the bug in src/sql/mdbsql.c, line 655. The second arguement should be col_size, not tmpstr. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: <br...@br...> - 2004-03-08 18:24:24
|
On Mon, 8 Mar 2004 09:04:34 -0800 (PST), Jeff Smith wrote: > > Three things in src/odbc/odbc.c could use fixing. > > 1.) In SQLGetTypeInfo, there are two unusual definitions: > > unsigned char *row_buffer[MDB_PGSIZE] > unsigned char *tmpstr[MDB_BIND_SIZE] > > From the context, I highly doubt you meant to have these as arrays of > pointers. These would make a lot more sense: :-) > > unsigned char row_buffer[MDB_PGSIZE] > unsigned char tmpstr[MDB_BIND_SIZE] Absolutely right, typo (they were pointers, and then.....sloppy me). > 2.) There is a table near the beginning of src/odbc/odbc.c, > TypeInfo type_info[]. Several entries in the table contain NULL if > four > fields that should contain 0. Specifically unsigned_attribute, > sql_datetime_sub, num_prec_radix, and interval_precision. This is a problem I hadn't decided how to handle. NULL there is wrong, but ... my thought is to do something like this: SQLSMALLINT small_sql_false = SQL_FALSE; SQLSMALLINT small_sql_true = SQL_TRUE; then make the field in the structure a SQLSMALLINT * instead of SQLSMALLINT and then store one of NULL, &small_sql_false or &small_sql_true allowing SQLGetTypeInfo to return the correct value (which is a NULL, SQL_FALSE, or SQL_TRUE). It's a little ugly, but better than the alternatives. Note: I often use CVS to move between two machines, so things in CVS will probably compile, but may not always be correct. > 3.) In SQLColAttributes, there is this line: > *((char *)&rgbDesc[namelen])='\0'; > It generates a warning on my compiler. All you should need is: > ((char *)rgbDesc)[namelen]='\0'; > I believe this came directly from the FreeTDS driver, will fix. BTW, I'm still struggling with the order of columns in the null_mask. If you delete a row the row positions in the tdef page retain the old values, but if you add a row on top of that they are reset to sequential. So, in a table with 1 column, 1 deleted column, another column, and an added column the bitmask looks like: 0000 0111 for old rows 0000 1101 for new rows Column 2 is deleted but there is no way as far I can see to determine how many (fixed) columns have been delete between cols 1 and 3. The fixed offset tells you the positon of the columns, but you don't know where they fall in the order. Still looking.... Brian Brian |
|
From: Jeff S. <why...@ya...> - 2004-03-08 17:21:10
|
Three things in src/odbc/odbc.c could use fixing. 1.) In SQLGetTypeInfo, there are two unusual definitions: unsigned char *row_buffer[MDB_PGSIZE] unsigned char *tmpstr[MDB_BIND_SIZE] From the context, I highly doubt you meant to have these as arrays of pointers. These would make a lot more sense: :-) unsigned char row_buffer[MDB_PGSIZE] unsigned char tmpstr[MDB_BIND_SIZE] 2.) There is a table near the beginning of src/odbc/odbc.c, TypeInfo type_info[]. Several entries in the table contain NULL if four fields that should contain 0. Specifically unsigned_attribute, sql_datetime_sub, num_prec_radix, and interval_precision. 3.) In SQLColAttributes, there is this line: *((char *)&rgbDesc[namelen])='\0'; It generates a warning on my compiler. All you should need is: ((char *)rgbDesc)[namelen]='\0'; -- Jeff S __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: <br...@br...> - 2004-03-06 13:57:02
|
Ok, a better fix is in for this I moved mdb_unicode2ascii from libmdb/data.c to libmdb/iconv.c and added a corresponding mdb_ascii2unicode function. This also gets rid of the need to malloc/free. oops, forgot to remove the old function...will do that today. Brian On Fri, 05 Mar 2004 07:45:52 -0800 (PST), br...@br... wrote: > > Yeah that was a quick fix when I noticed the results of the patch as > is. I want to re-visit it today or tomorrow and move it down into > libmdb too. The longer term solution is to use iconv for the > conversion, but I wanted to fix the bug quickly and then have some > time to think about fixing it right. It will be more elegant in the > final version, I think I need to clean up some of the building of temp > table columns too....it's too verbose. Should have it all done by > Monday. > > Please check your patch against the tree, I used the row position > number from the tdef page to get the postion of the null bit instead > of a simple ordering of columns, and I consolidated the building of > the mask between pack_row[3|4] since it's identical. So, please > verify that I didn't screw up the effects of your patch. > > I'm having some problems running "list tables" in odbc which I need to > look at too. > > Brian > > On Fri, 5 Mar 2004 04:58:18 -0800 (PST), Jeff Smith wrote: > > > > > I would like to suggest a parameter change in convert_to_ucs2 > > recently added to src/sql/mdbsql.c. Add an additional > > parameter of int * into which the final size is stored. That > > way, 1. you don't have to calculate it after you return, and > > 2. if logic for convert_to_ucs2 changes, you don't only have > > to update the logic for the string size in one place (high > > cohesion. > > > > -- Jeff S > > |
|
From: <br...@br...> - 2004-03-06 13:52:47
|
This stuff is all checked in. You can now specify the libmdbodbc
library as both the driver and setup libs. I'm going to look into
creating a link to libmdbodbcS for convenience purposes, just not sure
the proper way to do it in the Makefile.am yet.
Brian
On Thu, 04 Mar 2004 07:51:54 -0800 (PST), br...@br... wrote:
>
>
> I actually have code for both the setup library (the libmdbodbc will
> be the setup library as well as the odbc library) and to use the
> odbcinst library to read the odbc.ini file instead of the current
> scheme. This stuff will be going in in the next week or so.
>
> Brian
>
> On Thu, 4 Mar 2004 07:12:22 -0800 (PST), Jeff Smith wrote:
>
> >
> > --- Barrie Backhurst <bar...@nt...> wrote:
> > > Hi
> > >
> > > I have just installed mdbtools 0.5, along with unixodbc on
> slackware
> > 9.1
> > >
> > > The tools work fine with a test mdb file, but I am having
problems
> > configuring
> > > the odbc. I have edited odbc.ini as advised in your post install
> > > instructions, but OpenOffice will not connect. I have tried using
> > ODBCConfig,
> > > but there does not appear to be a setup library available and
when
> I
> > try to
> > > configure the DSN, the folowing error is generated:-
> > >
> > > Could not construct a property list for
> > (/usr/local/lib/libmdbodbc.so)
> >
> > You are correct, there is a driver, but no setup library. The
> > convention seems
> > to be that setup libraries end with a capital S (e.g.
libodbcmyS.so,
> > libtdsS.so).
> > I have not seen anything like that from unixODBC or from mdbtools.
> >
> > I have had problems with having it in the system DSN's
> > (/etc/odbc.ini), so I
> > put the definitions in the user DSN's instead ($HOME/.odbc.ini).
Try
> > this if
> > you have not already.
> >
> > To test, use unixODBC's isql tool. Run 'isq your_DSN' and try
> > executing a
> > select statement ('select * from some_table').
> >
> > > I guess I am missing something simple here, but I have been over
it
> > several
> > > times and cannot find the answer.
> > >
> > > Barrie
> >
> > Hope some of this helps.
> >
> > -- Jeff S
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Search - Find what you�re looking for faster
> > http://search.yahoo.com
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials
> > Free Linux tutorial presented by Daniel Robbins, President and CEO
of
> > GenToo technologies. Learn everything from fundamentals to system
> >
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> > _______________________________________________
> > mdbtools-dev mailing list
> > mdb...@li...
> > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
|
|
From: <br...@br...> - 2004-03-05 17:44:16
|
fields[].colnum is a match to the index of the table->columns hash. It represents the current column structure of the table. col->row_col_num (its a bad name) represents the columns position within the row. Example, take a table with 5 columns and delete the 3rd. colnum is still 1,2,3,4.....whereas row_col_num is 1,2,4,5. For tables with no deleted columns there is no difference between the two, but it's needed to properly read tables with deleted columns. Newly generated rows continue to write out deleted (fixed) columns with garbage so the row_col_num is constant for all rows, both pre and post deletion. Good eye spot on the colstart, will remove. I have more work to do on crack_row4 with deleted var cols and added columns (deleted fixed cols works). Then I need to translate that to crack_row3. Brian On Fri, 5 Mar 2004 08:37:39 -0800 (PST), Jeff Smith wrote: > > I noticed this change in your patch to write.c: > > before: > byte_num = i / 8; > bit_num = i % 8; > > after: > col = g_ptr_array_index (table->columns, i); > row_pos = col->row_col_num; > byte_num = row_pos / 8; > bit_num = row_pos % 8; > > If col->row_col_num really could be different than i, then I > think a change (in four places) is needed for consistency: > > this: > fields[i].colnum = i; > > should become this: > fields[i] = col->row_col_num; > > > -- Jeff S > > P.S. > Because of code you commented out in mdb_crack_row4 (which is already > rotting, BTW), you no longer need the initilization 'col_start = 2'. > > > --- br...@br... wrote: > > I found out something with the position of the column in the > > null_mask. There is a field in the tdef page that determines the > > order, and it's important for tables with deleted columns. I'm just > > about finished with my fixes for deleted columns, so I'm going to > wrap > > them up together and commit them. Patch looks good though, and I > > merged it into my tree this morning. > > > > Stay tuned. > > > > Brian > > > > On Tue, 2 Mar 2004 22:05:33 -0800 (PST), Jeff Smith wrote: > > > > > > > > FYI, I have submitted it to the patches page at sf. > > > > > > -- Jeff S (sf username: whydoubt) > > > > > > --- br...@br... wrote: > > > > Excellent! I'll add a note to the HACKING file about the order. > > The > > > > mdb_crack_row() stuff is a fairly recent change, and not all of > it > > > may > > > > have made it from the old data.c routine (although I hope it > did). > > > > I'm working on this area myself at the moment trying to get > > > > deleted/added columns working correctly. > > > > > > > > Sorry about the Jet4 thing, been working on write support under > > Jet3 > > > > primarily and haven't gotten to the point of translating that to > > > > Jet4....doh! > > > > > > > > I'll be looking forward to your patch. > > > > > > > > Brian > > > __________________________________ > Do you Yahoo!? > Yahoo! Search - Find what you�re looking for faster > http://search.yahoo.com |
|
From: Jeff S. <why...@ya...> - 2004-03-05 16:52:24
|
I noticed this change in your patch to write.c: before: byte_num = i / 8; bit_num = i % 8; after: col = g_ptr_array_index (table->columns, i); row_pos = col->row_col_num; byte_num = row_pos / 8; bit_num = row_pos % 8; If col->row_col_num really could be different than i, then I think a change (in four places) is needed for consistency: this: fields[i].colnum = i; should become this: fields[i] = col->row_col_num; -- Jeff S P.S. Because of code you commented out in mdb_crack_row4 (which is already rotting, BTW), you no longer need the initilization 'col_start = 2'. --- br...@br... wrote: > I found out something with the position of the column in the > null_mask. There is a field in the tdef page that determines the > order, and it's important for tables with deleted columns. I'm just > about finished with my fixes for deleted columns, so I'm going to wrap > them up together and commit them. Patch looks good though, and I > merged it into my tree this morning. > > Stay tuned. > > Brian > > On Tue, 2 Mar 2004 22:05:33 -0800 (PST), Jeff Smith wrote: > > > > > FYI, I have submitted it to the patches page at sf. > > > > -- Jeff S (sf username: whydoubt) > > > > --- br...@br... wrote: > > > Excellent! I'll add a note to the HACKING file about the order. > The > > > mdb_crack_row() stuff is a fairly recent change, and not all of it > > may > > > have made it from the old data.c routine (although I hope it did). > > > I'm working on this area myself at the moment trying to get > > > deleted/added columns working correctly. > > > > > > Sorry about the Jet4 thing, been working on write support under > Jet3 > > > primarily and haven't gotten to the point of translating that to > > > Jet4....doh! > > > > > > I'll be looking forward to your patch. > > > > > > Brian __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: <br...@br...> - 2004-03-05 16:00:32
|
Yeah that was a quick fix when I noticed the results of the patch as is. I want to re-visit it today or tomorrow and move it down into libmdb too. The longer term solution is to use iconv for the conversion, but I wanted to fix the bug quickly and then have some time to think about fixing it right. It will be more elegant in the final version, I think I need to clean up some of the building of temp table columns too....it's too verbose. Should have it all done by Monday. Please check your patch against the tree, I used the row position number from the tdef page to get the postion of the null bit instead of a simple ordering of columns, and I consolidated the building of the mask between pack_row[3|4] since it's identical. So, please verify that I didn't screw up the effects of your patch. I'm having some problems running "list tables" in odbc which I need to look at too. Brian On Fri, 5 Mar 2004 04:58:18 -0800 (PST), Jeff Smith wrote: > > I would like to suggest a parameter change in convert_to_ucs2 > recently added to src/sql/mdbsql.c. Add an additional > parameter of int * into which the final size is stored. That > way, 1. you don't have to calculate it after you return, and > 2. if logic for convert_to_ucs2 changes, you don't only have > to update the logic for the string size in one place (high > cohesion. > > -- Jeff S > > __________________________________ > Do you Yahoo!? > Yahoo! Search - Find what you�re looking for faster > http://search.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Jeff S. <why...@ya...> - 2004-03-05 13:13:00
|
I would like to suggest a parameter change in convert_to_ucs2 recently added to src/sql/mdbsql.c. Add an additional parameter of int * into which the final size is stored. That way, 1. you don't have to calculate it after you return, and 2. if logic for convert_to_ucs2 changes, you don't only have to update the logic for the string size in one place (high cohesion. -- Jeff S __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com |
|
From: <br...@br...> - 2004-03-04 16:06:07
|
I actually have code for both the setup library (the libmdbodbc will
be the setup library as well as the odbc library) and to use the
odbcinst library to read the odbc.ini file instead of the current
scheme. This stuff will be going in in the next week or so.
Brian
On Thu, 4 Mar 2004 07:12:22 -0800 (PST), Jeff Smith wrote:
>
> --- Barrie Backhurst <bar...@nt...> wrote:
> > Hi
> >
> > I have just installed mdbtools 0.5, along with unixodbc on
slackware
> 9.1
> >
> > The tools work fine with a test mdb file, but I am having problems
> configuring
> > the odbc. I have edited odbc.ini as advised in your post install
> > instructions, but OpenOffice will not connect. I have tried using
> ODBCConfig,
> > but there does not appear to be a setup library available and when
I
> try to
> > configure the DSN, the folowing error is generated:-
> >
> > Could not construct a property list for
> (/usr/local/lib/libmdbodbc.so)
>
> You are correct, there is a driver, but no setup library. The
> convention seems
> to be that setup libraries end with a capital S (e.g. libodbcmyS.so,
> libtdsS.so).
> I have not seen anything like that from unixODBC or from mdbtools.
>
> I have had problems with having it in the system DSN's
> (/etc/odbc.ini), so I
> put the definitions in the user DSN's instead ($HOME/.odbc.ini). Try
> this if
> you have not already.
>
> To test, use unixODBC's isql tool. Run 'isq your_DSN' and try
> executing a
> select statement ('select * from some_table').
>
> > I guess I am missing something simple here, but I have been over it
> several
> > times and cannot find the answer.
> >
> > Barrie
>
> Hope some of this helps.
>
> -- Jeff S
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Search - Find what you�re looking for faster
> http://search.yahoo.com
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
|
26 messages has been excluded from this view by a project administrator.
