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: Paul S. <psc...@gm...> - 2006-05-04 05:35:23
|
Greetings,
Please find attached a patch which provides a '-p' option to
mdb-export, which when used with the -I and -S, allows data to be
directly imported into PostgreSQL.
Using 'mdb-export' with the -I and -S options produces INSERT
statements that almost work except for:
- " (double quotes) are used to delimiter data, instead of single quotes.
- The is no semicolon (';') at the end of each line.
The patch add this.
There is another issue with '\'s in the data still being passed
directly without being escaped. This is a problem where I have
'windows' pathnames stored, and a training '\' will inadvertently
escape the single quote delimiter.
Cheers,
Paul Schulz
(Please cc. me on any reply to the list as I am not subscribed.)
|
|
From: Craig T. <CT...@ma...> - 2006-04-26 14:48:14
|
Does the latest CVS version support writing rows to existing tables. All I
need to do is a simple "INSERT INTO blah(x,y,z) VALUES("X","Y","Z")
I heard there are limitations on creating the tables but this I can live
with for the moment.
If this is possible then you will have alleviated an enourmous headache for
me,
cheers
Craig Thomson
Graduate IT Specialist
<mailto:ct...@ma... <mailto:ct...@ma...> >
Phone +44 (0) 1224 783700
Fax +44 (0) 1224 783701
Masterpower Electronics Ltd company registered in Scotland SC129203.
Contents of this e-mail are confidential. Viewing or interception by an
unauthorised third party is a breach of privacy and confidentiality which
will result in a court action. If this message is received by anyone other
than the addressee, please return the message to the sender by replying to
it and then delete the message from your computer.
Internet e-mails are not necessarily secure. Masterpower Electronics Ltd
does not accept responsibility for changes made to this message after it was
sent.
|
|
From: SourceForge.net <no...@so...> - 2006-04-25 07:30:19
|
Bugs item #1475976, was opened at 2006-04-25 07:30 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1475976&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Bastiaan Wakkie (bwakkie) Assigned to: Nobody/Anonymous (nobody) Summary: Can't compile in Mdk 10 Initial Comment: Hello, I can't run make and it ends like this: (0.6 pre 1) ./configure make . table_export.c:237: error: conflicting types for 'gmdb_table_export_populate_dialog' table_export.c:233: error: previous implicit declaration of 'gmdb_table_export_populate_dialog' was here make[3]: *** [table_export.o] Error 1 make[3]: Leaving directory `/home/bw/tmp/mdbtools-0.6pre1/src/gmdb2' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/home/bw/tmp/mdbtools-0.6pre1/src/gmdb2' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/bw/tmp/mdbtools-0.6pre1/src' make: *** [all-recursive] Error 1 Also I tried the suggested form: ./configure --enable-sql --with-unixodbc=/usr/local make make[2]: Entering directory `/home/bw/tmp/mdbtools-0.6pre1/src/odbc' ... odbc.c:21:17: sql.h: No such file or directory odbc.c:22:20: sqlext.h: No such file or directory In file included from odbc.c:28: ../../include/mdbodbc.h:28:22: odbcinst.h: No such file or directory ... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1475976&group_id=2294 |
|
From: Shahriar O. <sha...@po...> - 2006-04-20 20:15:01
|
More info:
I did this command:
DROP TABLE dbo_SECURITY_M020A;
CREATE TABLE dbo_SECURITY_M020A
(
SECURITY_NUMBER Text (22),
SECURITY_NAME Text (60),
REPORT_NAME1 Text (120),
REPORT_NAME2 Text (120),
CUSIP Text (24),
TICKER Text (24),
CEDOL Text (24),
ISIN Text (24),
ISSUER_NUMBER Text (22),
ISSUER_CODE Text (20),
SECURITY_TYPE Text (12),
INSTRUMENT Text (4),
ACTIVE_STATUS Text (2),
ISSUE_CURRENCY Text (6),
INCOME_CURRENCY Text (6),
INCOME_FREQUENC Unknown 0x00 (2),
Text (8),
Text (2),
Text (4),
Double (8),
Text (8),
Text (40),
Text (40),
Text (4),
Double (8),
Text (8),
Text (40),
Text (40),
Text (2),
Double (8),
Text (22),
Double (8),
Double (8),
Text (2),
Integer (2),
DateTime (Short) (8),
DateTime (Short) (8),
DateTime (Short) (8),
DateTime (Short) (8),
DateTime (Short) (8),
DateTime (Short) (8),
Text (4),
Integer (2),
...
It seems that mdbtools doesn't show column names for this table some how.
Thanks
-----Original Message-----
From: Shahriar Ofavezi [mailto:sha...@po...]
Sent: Thursday, April 20, 2006 3:33 PM
To: mdb...@li...
Subject: mdbtools problem
Hi,
I have a problem. I was working with mdbtools and ms access 97 on Linux OS
with no problem.(JET4)
I could load the data from access to text file and load it with Oracle
sqlloader into Oracle database.
Now I am getting the same tables and data in MS Access 2000 database. I make
a text file from my tables, all of them work, except one of the tables. It
shows bad characters in text file and some how I get null in some of the
columns. When I open it in access, I can see the data with no problem. When
I load data from MSAccess2000 (the same table) to Oracle with Visual Basic,
i don't get any problem. Just when I use mdb-export in Linux environment and
MS Access2000, the text file which it creates, has bad data.
Data is look like this:
," ","
Y "," Y
"," "," "," "," ","
"," NL","G CAD "," N"," "," ","CA ",," "," "," ",100.000000,"
"," N "," "," ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
û<94>~|fP:86&$^P^L
or another column:
:00:00","06/09/06 00:00:00","06/09/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"06/09/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","04/13/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2
and another sample:
ô","ò",100.000000,"â<9a><96>nF>:80*",0.000000,1.000000,"$",0,"","","03/0
6/06:00:00","03/06/06 00:00:00","03/06/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"03/06/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","01/30/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2
," ","
N "," N
"," "," "," "," ","
"," NL","E CAD "," N"," "," ","CA ",," "," "," ",100.000000,"
"," "," "," ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
ô","ò",100.000000,"â<9a><96>nF>:û<94>~|fP:86&$^P^L,"$",0,"","","04/2
7/06
Thanks
|
|
From: Shahriar O. <sha...@po...> - 2006-04-20 19:33:22
|
Hi,
I have a problem. I was working with mdbtools and ms access 97 on Linux OS
with no problem.(JET4)
I could load the data from access to text file and load it with Oracle
sqlloader into Oracle database.
Now I am getting the same tables and data in MS Access 2000 database. I make
a text file from my tables, all of them work, except one of the tables. It
shows bad characters in text file and some how I get null in some of the
columns. When I open it in access, I can see the data with no problem. When
I load data from MSAccess2000 (the same table) to Oracle with Visual Basic,
i don't get any problem. Just when I use mdb-export in Linux environment and
MS Access2000, the text file which it creates, has bad data.
Data is look like this:
," ","
Y "," Y
"," "," "," "," ","
"," NL","G CAD "," N"," "," ","CA ",," "," "," ",100.000000,"
"," N "," "," ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
û<94>~|fP:86&$^P^L
or another column:
:00:00","06/09/06 00:00:00","06/09/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"06/09/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","04/13/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2
and another sample:
ô","ò",100.000000,"â<9a><96>nF>:80*",0.000000,1.000000,"$",0,"","","03/0
6/06:00:00","03/06/06 00:00:00","03/06/06
00:00:00","","""^^",0,"^Rþèø <88>^P<9,"03/06/06
00:00:00",0.000000,0,"F",100.000000,0.000000,0,0.000000,0.000000,0.000000,""
,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.0
00000,"Bÿÿç¿^?ûÿ",0.000000,0.000000,0.000000,"<9f>","·","^C","",0.000
0?",0.000000,"",0.000000,"",0,"","","",0.000000,0.000000,0.000000,0.000000,"
","","","","","","","",0.000000,"","",0.000000,"",0.000000,"","",0.000000,""
,"",0.000000,"",0.000000,"","",0.000000,"","","01/30/06 00:00:00","12/13/01
20:45:52","","","","","",0.000000,0.000000,0.000000,0.000000,0.000000,"",0.0
00000,0.000000,0,0,"",0,"",,"","",0.000000,0.000000,0.000000,"","","","","",
2
," ","
N "," N
"," "," "," "," ","
"," NL","E CAD "," N"," "," ","CA ",," "," "," ",100.000000,"
"," "," "," ",100.000000,"
 ","<94><8>|\Z2*"" ^^^\^V^P^NøòðêèÃ","ÃÃÃ
ô","ò",100.000000,"â<9a><96>nF>:û<94>~|fP:86&$^P^L,"$",0,"","","04/2
7/06
Thanks
|
|
From: Michael B. <mi...@lu...> - 2006-04-19 20:28:49
|
> I tried to checkout the cvs version of mdb-tools, but I don't know > what the anonym password is. Just press enter. Michael |
|
From: SourceForge.net <no...@so...> - 2006-04-17 13:57:52
|
Bugs item #1471748, was opened at 2006-04-17 06:57 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1471748&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: cmd line utils Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: File does not appear to be...(again with attch) Initial Comment: Attach my MDB files that i'd tried with practically all tools of MDBtools, but don't work. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1471748&group_id=2294 |
|
From: Sam M. <pa...@gm...> - 2006-04-15 16:20:27
|
Install a compiler, which could be any command since you don't include what distro you are using. Ask someone who knows more about your distro as this is more than likely their issue and not an issue with mdbtools sam On 4/15/06, Sameer Kulkarni <sam...@ya...> wrote: > Hi All, > > I am really sorry to mail you directly. But i am stuck up badly. Please h= elp > me if you can... > > I want to convert an MS Access - MDB file into an .CSV file in Linux > platform . Means all the tables in the MDB file should be converted into > *.CSV file. > > For this , after searching on net, i found that mdb-tools are available. > Which we need to install in linux environment. I have already downloaded > the mdbtools-0.6pre1.tar.gz > file and perform following steps for installation. > > > tar -xzvf mdbtools-0.5.tar.gz > cd mdbtools-0.5 > ./configure > make > su -c make install > > > But while running the 3 step ./configure is get following error > > checking for C compiler default output... configure: > error: C compiler cannot cr > eate executables > See `config.log for more details. > > > Can you please help me to resolve this error or else is there anyother wa= y > to acheive the requirement . > > > Regards > > Sameer > > > ________________________________ > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rate= s > starting at 1=A2/min. > > |
|
From: Brian <bn...@ne...> - 2006-04-15 15:09:25
|
Hi, I am trying to view some .mdb files using the MDB Viewer 0.6pre1, running on SUSE 10. All the .mdb files are JET 4 (2000/XP). I believe the hk_classes are installed correctly. However, when I attempt to view the tables I can only view ONE of them. All the others do not show the tables. Is there something else I can check? Is there a limit to the size that the viewer can handle? Thanks, Brian |
|
From: Sameer K. <sam...@ya...> - 2006-04-15 12:50:45
|
Hi All, I am really sorry to mail you directly. But i am stuck up badly. Please help me if you can... I want to convert an MS Access - MDB file into an .CSV file in Linux platform . Means all the tables in the MDB file should be converted into *.CSV file. For this , after searching on net, i found that mdb-tools are available. Which we need to install in linux environment. I have already downloaded the mdbtools-0.6pre1.tar.gz file and perform following steps for installation. tar -xzvf mdbtools-0.5.tar.gz cd mdbtools-0.5 ./configure make su -c make install But while running the 3 step ./configure is get following error checking for C compiler default output... configure: error: C compiler cannot cr eate executables See `config.log for more details. Can you please help me to resolve this error or else is there anyother way to acheive the requirement . Regards Sameer --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. |
|
From: Nagy <nag...@po...> - 2006-04-13 08:24:47
|
Hi! I tried to checkout the cvs version of mdb-tools, but I don't know what=20 the anonym password is. Could you inform me about the progress of the Access 2003 mdb filetype=20 support? Thx for this great project and have Fun! =2D-=20 Zolt=E1n Nagy P.O.P. KFT. |
|
From: Jonathan D. <dix...@ly...> - 2006-04-05 20:02:43
|
> I believe primitive update support is available through a command-line > tool. I'm not sure about insert support. Since this was brought up, I would like to be able to do a few "basic" task= s from a C program (actually from a Perl XM module, but it works the same):= modify the values of fields in a database row, insert a row into a table, = and delete a row from a table. Is there a reference anywhere on how to go about doing these (or are these = even possible to do currently)? What is the command-line tool and where mi= ght I look in it for how they do these? Thanks, Jon Dixon dix...@ly... http://dixonjon.tripod.com/ --=20 _______________________________________________ Search for businesses by name, location, or phone number. -Lycos Yellow Pa= ges http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as= p?SRC=3Dlycos10 |
|
From: Jeff S. <why...@ya...> - 2006-04-03 14:08:59
|
--- Francisco Dalla Rosa Soares <dal...@gm...> wrote: > I was asked to create a migratory tool from DBF to MDB that would also > be able to run under linux, so I decided for MDBtools with unixODBC. > Now I'm having some problems with insertion and deletion. I believe primitive update support is available through a command-line tool. I'm not sure about insert support. As for the SQL interface, it only supports SELECT, CONNECT, DISCONNECT, DESCRIBE TABLE, and LIST TABLES at this time. -- Jeff Smith __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
|
From: Francisco D. R. S. <dal...@gm...> - 2006-04-03 13:15:54
|
Hello everyone,
My name is Francisco and I'm having some trouble here.
I was asked to create a migratory tool from DBF to MDB that would also
be able to run under linux, so I decided for MDBtools with unixODBC.
Now I'm having some problems with insertion and deletion.
My actual code is:
//------------------------------------CODE
START---------------------------------------------------------//
<html>
<head>
<title>PHP Database Example</title>
</head>
<?php
$db =3D odbc_connect("GDB","","");
$result =3D odbc_exec($db, "INSERT INTO Products VALUES (100, 'Jill',
'555-1040')");
odbc_commit($db);
?>
</body>
</html>
//------------------------------------CODE
END---------------------------------------------------------//
but I always get this message from the interpreter:
//--------------------message------------------------------//
bash-3.00$ php index.php
<html>
<head>
<title>PHP Database Example</title>
</head>
Error at Line : parse error near INSERT
</body>
</html>
//--------------------message------------------------------//
Though I can't see errors at all.
Isn't inserting and deleting supported yet?
Am I doing something wrong?
thanks in advance,
Francisco Dalla Rosa
|
|
From: Shanon M. <sha...@gm...> - 2006-04-03 11:29:09
|
I'm reading data from a jet database which has binary fields in it. When vewing the data in access, the binary fields appear as either a "/" or "%" (This is not the actual data - just how it is displayed when viewing the table in access). Now I'm fairly certain that this means something important. But when I read the fields using mdb-tools, the data is read the same for all records (whether they appear as "/" or "%" in access). Can anyone help me tell the difference between these using mdb-tools? (If it helps, I'm using this to read an Adobe Photoshop Elements 3.0 database). Thanks. |
|
From: SourceForge.net <no...@so...> - 2006-04-02 13:23:57
|
Bugs item #1463036, was opened at 2006-04-02 15:23 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1463036&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: cmd line utils Group: None Status: Open Resolution: None Priority: 5 Submitted By: micha137 (micha137) Assigned to: Nobody/Anonymous (nobody) Summary: mdb-sql treats columns case sensitive Initial Comment: I was desparate about mdb-sql returning emtpy records for a selection of a column subset, but working properly when selecting all columns using "*". It turned out that it treats the column names case sensitive. Say "table1" has two columns, "Column1" and "Column2". This didn't work: SELECT column1 FROM table1 Resulted in empty records. This worked: SELECT * FROM table1 This is the corrected first query: SELECT Column1 FROM table1 mdb-sql should either treat the column names as case insensitive (I don't know what SQL says here) or report an error like "column 'column1' does not exist". In no case may it return empty records. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1463036&group_id=2294 |
|
From: SourceForge.net <no...@so...> - 2006-03-30 16:37:03
|
Bugs item #1461495, was opened at 2006-03-30 08:36 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1461495&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: cmd line utils Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: File does not appear to be an Access databas Initial Comment: Attach my MDB files that i'd tried with practically all tools of MDBtools, but don't work. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1461495&group_id=2294 |
|
From: SourceForge.net <no...@so...> - 2006-03-21 22:39:43
|
Bugs item #1455721, was opened at 2006-03-21 14:39 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1455721&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: cmd line utils Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: mdb-export exports null for some fields Initial Comment: Some of the columns of a JET4 database are exported as null even though there are data in them. The output of mdb-schema on the table shows that those columns are of unknown type, i.e. BillingAccountNo Unknown 0x00 (32). This column should have been Text (32). Similiarily, a column that should have been Currency (8) is being display in mdb-schema as Unknown 0x00 (8). Please help. Thank you. Jessie Chin jc...@bi... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1455721&group_id=2294 |
|
From: Philip S. <phi...@gm...> - 2006-03-17 21:47:55
|
Hi, I'm a brand new user of the mdbtools. Thanks, first off! This is great. I installed on a Debian system. Everything went as expected. Aside from the program not showing up in the menu system (minor annoyance), it launched from the CLI, it accessed my file, and exported one table to text without a glitch. My issue is the need to edit the table prior to export. I figure I can do this using the SQL Window, but when I try to open it, I get nothing. Here are some error messages: on startup: (gmdb2: 19598): libglade-WARNING **: could not find signal handler 'gmdb_sql_new_cb'. And these, although I can't tell you when they occurred: (gmdb2:19598): GLib-GObject-WARNING **: invalid cast from 'GtkButton' to 'GtkWindow' (gmdb2:19598): Gtk-CRITICAL **: gtk_message_dialog_new: assertion 'parent =3D=3D NULL | | GTK_IS_WINDOW (parent)' failed (gmdb2:19598): Gtk-CRITICAL **: gtk_dialog_run: assertion 'GTK_IS_DIALOG (dialog)' failed Thanks for any help you can offer. Phil |
|
From: Casimir C. <CC...@tr...> - 2006-03-15 19:06:31
|
Nevermind ...... I figured out that I was missing the unixODBC-devel package for my distro. >>> "Casimir Cichon" <CC...@tr...> 03/15/06 11:16 AM >>> I know I just joined the list, but when compiling with --with-unixodbc I get all kinds of compiler errors in odbc.c the first errors I get look like this: odbc.c:82: warning: (near initialization for 'type_info[0]') odbc.c:82: warning: excess elements in scalar initializer odbc.c:82: warning: (near initialization for 'type_info[0]') odbc.c:82: error: 'SQL_TRUE' undeclared here (not in a function) at the end I get errors like this (which I'm assuming are based on the previous errors): odbc.c: In function 'SQLDataSources': odbc.c:1570: error: 'SQL_SUCCESS' undeclared (first use in this function) odbc.c: In function '_odbc_get_string_size': odbc.c:1618: error: 'SQL_NTS' undeclared (first use in this function) odbc.c: In function '_odbc_get_server_type': odbc.c:1630: error: 'SQL_BIT' undeclared (first use in this function) odbc.c:1631: error: 'SQL_TINYINT' undeclared (first use in this function) odbc.c: At top level: odbc.c:1643: error: syntax error before '_odbc_get_client_type' odbc.c: In function '_odbc_get_client_type': odbc.c:1647: error: 'SQL_BIT' undeclared (first use in this function) odbc.c:1650: error: 'SQL_TINYINT' undeclared (first use in this function) make[2]: *** [odbc.lo] Error 1 make[2]: Leaving directory `/home/ccichon/mdbtools/src/odbc' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/ccichon/mdbtools/src' make: *** [all-recursive] Error 1 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Casimir C. <CC...@tr...> - 2006-03-15 17:18:11
|
I know I just joined the list, but when compiling with --with-unixodbc I get all kinds of compiler errors in odbc.c the first errors I get look like this: odbc.c:82: warning: (near initialization for 'type_info[0]') odbc.c:82: warning: excess elements in scalar initializer odbc.c:82: warning: (near initialization for 'type_info[0]') odbc.c:82: error: 'SQL_TRUE' undeclared here (not in a function) at the end I get errors like this (which I'm assuming are based on the previous errors): odbc.c: In function 'SQLDataSources': odbc.c:1570: error: 'SQL_SUCCESS' undeclared (first use in this function) odbc.c: In function '_odbc_get_string_size': odbc.c:1618: error: 'SQL_NTS' undeclared (first use in this function) odbc.c: In function '_odbc_get_server_type': odbc.c:1630: error: 'SQL_BIT' undeclared (first use in this function) odbc.c:1631: error: 'SQL_TINYINT' undeclared (first use in this function) odbc.c: At top level: odbc.c:1643: error: syntax error before '_odbc_get_client_type' odbc.c: In function '_odbc_get_client_type': odbc.c:1647: error: 'SQL_BIT' undeclared (first use in this function) odbc.c:1650: error: 'SQL_TINYINT' undeclared (first use in this function) make[2]: *** [odbc.lo] Error 1 make[2]: Leaving directory `/home/ccichon/mdbtools/src/odbc' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/ccichon/mdbtools/src' make: *** [all-recursive] Error 1 |
|
From: Shanon M. <sha...@gm...> - 2006-03-07 17:08:58
|
Never mind - I think I'm just reading the data incorrectly. I have an idea of how to do it now. On 3/7/06, Shanon Mulley <sha...@gm...> wrote: > Hello, > > I'm using mdbtools to pull information out of a binary field (adobe > photo album 2.0). In this binary field, each 4 bytes represents an > integer, so when I use the mdb tools to dump the data out of this > field, I can convert the hexademical to decmial, to give me the number > I want. > > What it is giving me is something like this: > > 1900000033000000320000002600000027000000 > > Every 8 characters represents on value (an integer). My problem is, > that mdbtools seems to right fill each value with zeros. So, I can > never be quite sure if the zeros are padding, or if they are part of > the value. For example, from above, is the value "19", with 6 zeros > padding it, or is it "190", with 5 zeros padding it? > > Is there some way of making the padding happening the other way around > (left filling with zeros), so I'll know exactly where the padding > starts and the value ends? > > Or am I missing something here? > > Any help would be appreciated. > |
|
From: Shanon M. <sha...@gm...> - 2006-03-07 09:12:37
|
Hello, I'm using mdbtools to pull information out of a binary field (adobe photo album 2.0). In this binary field, each 4 bytes represents an integer, so when I use the mdb tools to dump the data out of this field, I can convert the hexademical to decmial, to give me the number I want. What it is giving me is something like this: 1900000033000000320000002600000027000000 Every 8 characters represents on value (an integer). My problem is, that mdbtools seems to right fill each value with zeros. So, I can never be quite sure if the zeros are padding, or if they are part of the value. For example, from above, is the value "19", with 6 zeros padding it, or is it "190", with 5 zeros padding it? Is there some way of making the padding happening the other way around (left filling with zeros), so I'll know exactly where the padding starts and the value ends? Or am I missing something here? Any help would be appreciated. |
|
From: Michael B. <mi...@lu...> - 2006-02-25 12:03:49
|
> /usr/bin/../lib/libXft.so.2: undefined reference to > `FT_GlyphSlot_Embolden' collect2: ld returned 1 exit status Update freetype. |
|
From: SourceForge.net <no...@so...> - 2006-02-23 14:59:20
|
Bugs item #1437473, was opened at 2006-02-23 14:59 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1437473&group_id=2294 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Andrea GAMBARARA (andreagambarara) Assigned to: Nobody/Anonymous (nobody) Summary: Info about mdb/mde file binary format Initial Comment: Hi, if you visit www.wotsit.org, you can find documents which explain in detail Microsoft Word files binary format. Is anywhere available anything similar, i. e. a single document which contains full information about Access mdb/mde file binary format? Thank you. and...@ti... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1437473&group_id=2294 |
26 messages has been excluded from this view by a project administrator.
