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: M Y. <me...@gm...> - 2007-03-28 20:24:55
|
Samantha, I am not a developer of mdb tools, I just use it. I am not sure how to use all of the tools in the package. Give these commands (via command line) a whirl - where {mydatabase.mdb} := the filename of the database - and {myfile.txt} := the file you want to save - and {mytablename} := is a table you know exists in the database mdb-schema {mydatabase.mdb} | more This will give you the complete schema as mdb-tools can read it or if you would like to save it into a file mdb-schema {mydatabase.mdb} > {myfile.txt} If you need to list the tables you can do mdb-tables {mydatabase.mdb} If you need to learn more about a specific tables description you can try echo "DESCRIBE TABLE {mytablename}" |mdb-sql {mydatabase.mdb} |more There is also a graphical tool, but its better to get familiar with the commandline equivalents as I believe it operates as a wrapper (and crashes every time mdb-tools itself does not gracefully response to a command. On 3/28/07, Samantha L <sam...@ya...> wrote: > > Hi mdbtools-dev, > > Currently I'm using your mdbtools to read mdb file in Linux, and I found > that not all mdb files can be worked well, if I delete one table from a > database, and all tables created after this deleted table cannot be read ( I > used mdb-sql, and the query is "list tables" ), and so does the records. > When I used "Compact and Repair Database..." to operate on the mdb file, > then mdb-sql works well, but the working mdb file is very large, and after > doing compacting and repairing, the file size only changed little, and > mdb-sql still doesn't work, and the working requirement is I cannot do > anything in Windows, all in Linux. I really appreciate that if you can fix > this bug. > > Could you please tell me the detailed information about the mdb file > format, for example, in mdb file, where stores the table name and records, > are there all in the data page and how can I distinguish them, > also I got some keys such as "Tables", "Databases", "Relationships", > "MSysDb", "MSysObjects", "MSysACEs", "MSysQueries", "MSysRelationships", > "DataAccessPages", "Forms", "Modules", "Reports", "Scripts", "SysRel", > "AccessLayout", "SummaryInfo", "UserDefined", "MSysAccessObjects", > "MSysAccessXML", what are these keys exactly meaning, and how can I find > them? If you can give me the detailed documents about the mdb file format > and how you decode the mdb file format, I think I can fix the bugs by myself > much quicklier than knowing less information ( I need to complete this > project in a very short time ). > > If you receive my email, could you please give me a reply, thanks a lot in > advance! > > > > Best Regards, > > Samantha > > > ------------------------------ > Now that's room service! Choose from over 150,000 hotels > in 45,000 destinations on Yahoo! Travel<http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--%0A>to find your fit. > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > -- Mehmet Yilmaz Chief Software Engineer Government Services Integrated Process Team |
From: Samantha L <sam...@ya...> - 2007-03-28 19:51:27
|
Hi mdbtools-dev, Currently I'm using your mdbtools to read mdb file in Linux, and I found that not all mdb files can be worked well, if I delete one table from a database, and all tables created after this deleted table cannot be read ( I used mdb-sql, and the query is "list tables" ), and so does the records. When I used "Compact and Repair Database..." to operate on the mdb file, then mdb-sql works well, but the working mdb file is very large, and after doing compacting and repairing, the file size only changed little, and mdb-sql still doesn't work, and the working requirement is I cannot do anything in Windows, all in Linux. I really appreciate that if you can fix this bug. Could you please tell me the detailed information about the mdb file format, for example, in mdb file, where stores the table name and records, are there all in the data page and how can I distinguish them, also I got some keys such as "Tables", "Databases", "Relationships", "MSysDb", "MSysObjects", "MSysACEs", "MSysQueries", "MSysRelationships", "DataAccessPages", "Forms", "Modules", "Reports", "Scripts", "SysRel", "AccessLayout", "SummaryInfo", "UserDefined", "MSysAccessObjects", "MSysAccessXML", what are these keys exactly meaning, and how can I find them? If you can give me the detailed documents about the mdb file format and how you decode the mdb file format, I think I can fix the bugs by myself much quicklier than knowing less information ( I need to complete this project in a very short time ). If you receive my email, could you please give me a reply, thanks a lot in advance! Best Regards, Samantha ____________________________________________________________________________________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 |
From: SourceForge.net <no...@so...> - 2007-03-26 21:25:13
|
Bugs item #1688770, was opened at 2007-03-26 21:25 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=1688770&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 Private: No Submitted By: John Nagle (nagle) Assigned to: Nobody/Anonymous (nobody) Summary: mdb-export -I escapes not correct Initial Comment: "mdb-export -I" creates SQL INSERT statements with the field values quoted, which is correct. It appears to escape quotes, which is correct. But it doesn't escape backslashes as well, which is incorrect. This does bad things to Windows pathnames in .mdb files, and can generate SQL like INSERT ... "c:\foo\" which is not valid SQL. The escape options for mdb-export allow setting some options for escaping, but they aren't powerful enough to express the format needed for SQL. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1688770&group_id=2294 |
From: Igor K. <ik...@ea...> - 2007-03-25 06:49:53
|
<HEAD> <STYLE>body{font-family: Geneva,Arial,Helvetica,sans-serif;font-size:9pt;ba= ckground-color: #ffffff;color: black;}</STYLE> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR></HEAD> <BODY> <P>Brian,</P> <P>This is a JET3 (access97) db. And it can be easily opened by the MS ACCE= SS....</P> <P> </P> <P>This is too bad. Do you have an estimate for at least 0.6pre2?</P> <P> </P> <P>Thank you.</P> <DIV id=3DcompText><BR><BR><BR> <BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 0px; BORDER-LEFT: #000= 0ff 2px solid">-----Original Message----- <BR>From: Brian Bruns <BRIAN.BRUN= S...@GM...><BR>Sent: Mar 24, 2007 3:01 PM <BR>To: mdb...@li...urc= eforge.net <BR>Subject: Re: [mdb-dev] Problem with gmbd2 <BR><BR>Ok, so the= re is nothing specific to gmdb causing problems, it seems to be related to = the database. Couple of things, is it a JET3 (access 97) or JET4 (acc= ess 2000 and above)? Can you read other databases?<BR><BR>I don't hav= e an exact plan for when 0.6 will be released, that depends on how much tim= e I find to work on it.<BR><BR>Brian<BR><BR> <DIV><SPAN class=3Dgmail_quote>2007/3/22, Igor Korot <<A href=3D"mailto:= ik...@ea..." target=3D_blank>ik...@ea...</A>>:</SPAN>= =20 <BLOCKQUOTE class=3Dgmail_quote style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt= 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"> <DIV> <P>Hi, Brian,</P> <P>I just tried the <SPAN class=3Dst id=3Dst name=3D"st">mdb</SPAN>-tables.= No success. I tried the:</P> <P> </P> <P><SPAN class=3Dst id=3Dst name=3D"st">mdb</SPAN>-tools NWIN.<SPAN class= =3Dst id=3Dst name=3D"st">MDB</SPAN></P> <P>and it gave me an empty string.</P> <P> </P> <P>Also, you were talking about the next "prre-release'. When we could expe= ct the official one?</P> <DIV><SPAN class=3De id=3Dq_11178a6ac82b6e0a_1> <P> </P> <P>Thank you.</P> <DIV><BR><BR><BR> <BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 0px; BORDER-LEFT: rgb(= 0,0,255) 2px solid">-----Original Message----- <BR>From: Brian Bruns <BR>Se= nt: Mar 16, 2007 2:57 PM <BR>To: <A onclick=3D"return top.js.OpenExtLink(wi= ndow,event,this)" href=3D"mailto:mdb...@li..." target= =3D_blank>mdb...@li...</A> <BR>Subject: Re: [mdb-dev]= Problem with gmbd2 <BR><BR>Couple of things. Can you use mdb-tables = (command line tools) to display the tables? The ODBC driver is not re= quired and is not used by gmdb2, so no DSN is needed. <BR><BR>You might con= sider using a recent version from CVS as pre1 is getting a little long in t= he tooth. I'm hoping to knock out a few more bugs and release a pre2 = soon. <BR><BR>Brian<BR><BR> <DIV><SPAN class=3Dgmail_quote>2007/3/16, Igor Korot <<A onclick=3D"retu= rn top.js.OpenExtLink(window,event,this)" href=3D"mailto:ikorot@earthlink.n= et" target=3D_blank>ik...@ea...</A>>:</SPAN>=20 <BLOCKQUOTE class=3Dgmail_quote style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt= 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi,<BR>I just installe= d mdbtools 06pre1.<BR>Then I try to run gmdb2 and open the db.<BR><BR>It op= ens fine, however, there is no tables on the page.<BR><BR>I read that this = version was shipped with the bug in gmdb2.<BR>Is this a bug? If not, what d= o I do to display the tables... <BR><BR>I configured it with the ODBC. Does= this mean I have to provide <BR>a DSN?<BR><BR>Thank you.<BR><BR>----------= ---------------------------------------------------------------<BR>Take Sur= veys. Earn Cash. Influence the Future of IT <BR>Join SourceForge.net's Tech= say panel and you'll get the chance to share your <BR>opinions on IT & = business topics through brief surveys-and earn cash<BR><A onclick=3D"return= top.js.OpenExtLink(window,event,this)" href=3D"http://www.techsay.com/defa= ult.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV" target=3D_bla= nk>http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&a= mp;CID=3DDEVDEV</A><BR>_______________________________________________<BR>m= dbtools-dev mailing list<BR><A onclick=3D"return top.js.OpenExtLink(window,= event,this)" href=3D"mailto:mdb...@li..." target=3D_b= lank>mdb...@li...</A><BR><A onclick=3D"return top.js.= OpenExtLink(window,event,this)" href=3D"https://lists.sourceforge.net/lists= /listinfo/mdbtools-dev" target=3D_blank>https://lists.sourceforge.net/lists= /listinfo/mdbtools-dev </A><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV></= SPAN></DIV></DIV></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV></BODY> |
From: Brian B. <bri...@gm...> - 2007-03-24 23:01:31
|
Ok, so there is nothing specific to gmdb causing problems, it seems to be related to the database. Couple of things, is it a JET3 (access 97) or JET4 (access 2000 and above)? Can you read other databases? I don't have an exact plan for when 0.6 will be released, that depends on how much time I find to work on it. Brian 2007/3/22, Igor Korot <ik...@ea...>: > > Hi, Brian, > > I just tried the mdb-tables. No success. I tried the: > > > > mdb-tools NWIN.MDB > > and it gave me an empty string. > > > > Also, you were talking about the next "prre-release'. When we could expect > the official one? > > > > Thank you. > > > > -----Original Message----- > From: Brian Bruns > Sent: Mar 16, 2007 2:57 PM > To: mdb...@li... > Subject: Re: [mdb-dev] Problem with gmbd2 > > Couple of things. Can you use mdb-tables (command line tools) to display > the tables? The ODBC driver is not required and is not used by gmdb2, so no > DSN is needed. > > You might consider using a recent version from CVS as pre1 is getting a > little long in the tooth. I'm hoping to knock out a few more bugs and > release a pre2 soon. > > Brian > > 2007/3/16, Igor Korot <ik...@ea...>: > > > > Hi, > > I just installed mdbtools 06pre1. > > Then I try to run gmdb2 and open the db. > > > > It opens fine, however, there is no tables on the page. > > > > I read that this version was shipped with the bug in gmdb2. > > Is this a bug? If not, what do I do to display the tables... > > > > I configured it with the ODBC. Does this mean I have to provide > > a DSN? > > > > Thank you. > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > > your > > opinions on IT & business topics through brief surveys-and earn cash > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > |
From: Igor K. <ik...@ea...> - 2007-03-22 07:57:47
|
<HEAD> <STYLE>body{font-family: Geneva,Arial,Helvetica,sans-serif;font-size:9pt;ba= ckground-color: #ffffff;color: black;}</STYLE> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR></HEAD> <BODY> <P>Hi, Brian,</P> <P>I just tried the mdb-tables. No success. I tried the:</P> <P> </P> <P>mdb-tools NWIN.MDB</P> <P>and it gave me an empty string.</P> <P> </P> <P>Also, you were talking about the next "prre-release'. When we could expe= ct the official one?</P> <P> </P> <P>Thank you.</P> <DIV id=3DcompText><BR><BR><BR> <BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 0px; BORDER-LEFT: #000= 0ff 2px solid">-----Original Message----- <BR>From: Brian Bruns <BRIAN.BRUN= S...@GM...><BR>Sent: Mar 16, 2007 2:57 PM <BR>To: mdb...@li...urc= eforge.net <BR>Subject: Re: [mdb-dev] Problem with gmbd2 <BR><BR>Couple of = things. Can you use mdb-tables (command line tools) to display the ta= bles? The ODBC driver is not required and is not used by gmdb2, so no= DSN is needed.<BR><BR>You might consider using a recent version from CVS a= s pre1 is getting a little long in the tooth. I'm hoping to knock out= a few more bugs and release a pre2 soon. <BR><BR>Brian<BR><BR> <DIV><SPAN class=3Dgmail_quote>2007/3/16, Igor Korot <<A href=3D"mailto:= ik...@ea..." target=3D_blank>ik...@ea...</A>>:</SPAN> <BLOCKQUOTE class=3Dgmail_quote style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt= 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi,<BR>I just installe= d mdbtools 06pre1.<BR>Then I try to run gmdb2 and open the db.<BR><BR>It op= ens fine, however, there is no tables on the page.<BR><BR>I read that this = version was shipped with the bug in gmdb2.<BR>Is this a bug? If not, what d= o I do to display the tables... <BR><BR>I configured it with the ODBC. Does= this mean I have to provide<BR>a DSN?<BR><BR>Thank you.<BR><BR>-----------= --------------------------------------------------------------<BR>Take Surv= eys. Earn Cash. Influence the Future of IT <BR>Join SourceForge.net's Techs= ay panel and you'll get the chance to share your<BR>opinions on IT & bu= siness topics through brief surveys-and earn cash<BR><A href=3D"http://www.= techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDE= V" target=3D_blank>http://www.techsay.com/default.php?page=3Djoin.php&p= =3Dsourceforge&CID=3DDEVDEV</A><BR>____________________________________= ___________<BR>mdbtools-dev mailing list<BR><A href=3D"mailto:mdbtools-dev@= lists.sourceforge.net" target=3D_blank>mdb...@li...</= A><BR><A href=3D"https://lists.sourceforge.net/lists/listinfo/mdbtools-dev"= target=3D_blank>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev<= /A><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV></BODY> |
From: Igor K. <ik...@ea...> - 2007-03-19 09:33:45
|
<HEAD> <STYLE>body{font-family: Geneva,Arial,Helvetica,sans-serif;font-size:9pt;ba= ckground-color: #ffffff;color: black;}</STYLE> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR></HEAD> <BODY> <DIV>Hi,</DIV> <DIV>Is there a plan to release a new 0.6 version without a "pre"?</DIV> <DIV> </DIV> <DIV>Thank you.<BR><BR><BR></DIV> <BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 0px; BORDER-LEFT: #000= 0ff 2px solid">-----Original Message----- <BR>From: Brian Bruns <BRIAN.BRUN= S...@GM...><BR>Sent: Mar 16, 2007 2:57 PM <BR>To: mdb...@li...urc= eforge.net <BR>Subject: Re: [mdb-dev] Problem with gmbd2 <BR><BR>Couple of = things. Can you use mdb-tables (command line tools) to display the ta= bles? The ODBC driver is not required and is not used by gmdb2, so no= DSN is needed.<BR><BR>You might consider using a recent version from CVS a= s pre1 is getting a little long in the tooth. I'm hoping to knock out= a few more bugs and release a pre2 soon. <BR><BR>Brian<BR><BR> <DIV><SPAN class=3Dgmail_quote>2007/3/16, Igor Korot <<A href=3D"mailto:= ik...@ea..." target=3D_blank>ik...@ea...</A>>:</SPAN> <BLOCKQUOTE class=3Dgmail_quote style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt= 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi,<BR>I just installe= d mdbtools 06pre1.<BR>Then I try to run gmdb2 and open the db.<BR><BR>It op= ens fine, however, there is no tables on the page.<BR><BR>I read that this = version was shipped with the bug in gmdb2.<BR>Is this a bug? If not, what d= o I do to display the tables... <BR><BR>I configured it with the ODBC. Does= this mean I have to provide<BR>a DSN?<BR><BR>Thank you.<BR><BR>-----------= --------------------------------------------------------------<BR>Take Surv= eys. Earn Cash. Influence the Future of IT <BR>Join SourceForge.net's Techs= ay panel and you'll get the chance to share your<BR>opinions on IT & bu= siness topics through brief surveys-and earn cash<BR><A href=3D"http://www.= techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDE= V" target=3D_blank>http://www.techsay.com/default.php?page=3Djoin.php&p= =3Dsourceforge&CID=3DDEVDEV</A><BR>____________________________________= ___________<BR>mdbtools-dev mailing list<BR><A href=3D"mailto:mdbtools-dev@= lists.sourceforge.net" target=3D_blank>mdb...@li...</= A><BR><A href=3D"https://lists.sourceforge.net/lists/listinfo/mdbtools-dev"= target=3D_blank>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev<= /A><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY> |
From: Brian B. <bri...@gm...> - 2007-03-16 22:57:31
|
Couple of things. Can you use mdb-tables (command line tools) to display the tables? The ODBC driver is not required and is not used by gmdb2, so no DSN is needed. You might consider using a recent version from CVS as pre1 is getting a little long in the tooth. I'm hoping to knock out a few more bugs and release a pre2 soon. Brian 2007/3/16, Igor Korot <ik...@ea...>: > > Hi, > I just installed mdbtools 06pre1. > Then I try to run gmdb2 and open the db. > > It opens fine, however, there is no tables on the page. > > I read that this version was shipped with the bug in gmdb2. > Is this a bug? If not, what do I do to display the tables... > > I configured it with the ODBC. Does this mean I have to provide > a DSN? > > Thank you. > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
From: Igor K. <ik...@ea...> - 2007-03-16 21:35:15
|
Hi, I just installed mdbtools 06pre1. Then I try to run gmdb2 and open the db. It opens fine, however, there is no tables on the page. I read that this version was shipped with the bug in gmdb2. Is this a bug? If not, what do I do to display the tables... I configured it with the ODBC. Does this mean I have to provide a DSN? Thank you. |
From: Brian B. <bri...@gm...> - 2007-03-08 23:19:40
|
Ugh.. think *you're* all set....english is my first language thank you very much. Brian 2007/3/8, Brian Bruns <bri...@gm...>: > > Ok, think your all set Jeff. Let me know otherwise. > > > Brian (who has found a few minutes here and there to resume work) > > 2007/3/7, Jeff Smith < why...@ya...>: > > > > As I have noted in the bug, this has long been fixed in CVS. > > > > I would have closed the bug too, but I have yet to receive authority to > > do that. Brian? > > > > -- Jeff Smith > > > > ----- Original Message ---- > > From: Martin Ellis <ma...@el... > > > To: mdb...@li... > > Sent: Wednesday, March 7, 2007 12:32:43 PM > > Subject: Re: [mdb-dev] [ mdbtools-Bugs-1675603 ] Error in declaration of > > mdb_backends ( 0.6pre1) > > > > On Wednesday 07 March 2007 10:40, SourceForge.net wrote: > > > Initial Comment: > > > When compiling the source package downloaded from the project page: > > > > > > backend.c:31: error: static declaration of 'mdb_backends' follows > > > non-static declaration ../../include/mdbtools.h:150: error: previous > > > declaration of 'mdb_backends' was here > > > > > > mdb_backends has different declarations. > > > In file include/mdbtools.h: > > > extern GHashTable *mdb_backends; > > > In file src/libmdb/backend.c: > > > static GHashTable *mdb_backends; > > > > I think this was fixed in CVS a long time ago... or has it reappeared? > > > > Martin > > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > > your > > opinions on IT & business topics through brief surveys-and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > > > > > > > > > > > > ____________________________________________________________________________________ > > It's here! Your new message! > > Get new email alerts with the free Yahoo! Toolbar. > > http://tools.search.yahoo.com/toolbar/features/mail/ > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > > your > > opinions on IT & business topics through brief surveys-and earn cash > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > |
From: Brian B. <bri...@gm...> - 2007-03-08 23:18:45
|
Ok, think your all set Jeff. Let me know otherwise. Brian (who has found a few minutes here and there to resume work) 2007/3/7, Jeff Smith <why...@ya...>: > > As I have noted in the bug, this has long been fixed in CVS. > > I would have closed the bug too, but I have yet to receive authority to do > that. Brian? > > -- Jeff Smith > > ----- Original Message ---- > From: Martin Ellis <ma...@el...> > To: mdb...@li... > Sent: Wednesday, March 7, 2007 12:32:43 PM > Subject: Re: [mdb-dev] [ mdbtools-Bugs-1675603 ] Error in declaration of > mdb_backends (0.6pre1) > > On Wednesday 07 March 2007 10:40, SourceForge.net wrote: > > Initial Comment: > > When compiling the source package downloaded from the project page: > > > > backend.c:31: error: static declaration of 'mdb_backends' follows > > non-static declaration ../../include/mdbtools.h:150: error: previous > > declaration of 'mdb_backends' was here > > > > mdb_backends has different declarations. > > In file include/mdbtools.h: > > extern GHashTable *mdb_backends; > > In file src/libmdb/backend.c: > > static GHashTable *mdb_backends; > > I think this was fixed in CVS a long time ago... or has it reappeared? > > Martin > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > > > > ____________________________________________________________________________________ > It's here! Your new message! > Get new email alerts with the free Yahoo! Toolbar. > http://tools.search.yahoo.com/toolbar/features/mail/ > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
From: Brian B. <bri...@gm...> - 2007-03-08 23:15:13
|
The unixODBC is not required for gmdb2. The obvious cause for gmdb2 not building is that the gnome detection routine failed. Look at your config.log file for the lines following "checking for GNOME". If you want post the few lines before and below that so we can see what's going on. Brian 2007/3/8, Guido Milanese <gui...@un...>: > > I am sorry to ask a question which I'm sure is obvious, but I was not able > to > find an answer browsing the docs. > > I am using a Mandriva 2007 Linux distribution. > I downloaded the source code from CSV as suggested and it was all right. I > compiled it using ./autogen.sh with no options, and it was again all > perfect. In the directory /src/util I found several executable files > (mdb-array and many others), tested them, and they work very well > (congratulations! great work). > But I'm afraid I have not succeeded in compiling gmdb: i find no > executable. > The Installation Guide says: For information on how to use gmdb2, see the > manual under the Help menu, which I was unable (my fault, obviously). > > Should I compile again with the option "--with-unixodbc=/usr/local"? I > decided > to omit it because I do not need PHP/Perl interface. > > Best regards and thanks a lot! > Guido, from Italy > > ------------ > http://www.arsantiqua.org > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
From: Guido M. <gui...@un...> - 2007-03-08 20:30:03
|
I am sorry to ask a question which I'm sure is obvious, but I was not able to find an answer browsing the docs. I am using a Mandriva 2007 Linux distribution. I downloaded the source code from CSV as suggested and it was all right. I compiled it using ./autogen.sh with no options, and it was again all perfect. In the directory /src/util I found several executable files (mdb-array and many others), tested them, and they work very well (congratulations! great work). But I'm afraid I have not succeeded in compiling gmdb: i find no executable. The Installation Guide says: For information on how to use gmdb2, see the manual under the Help menu, which I was unable (my fault, obviously). Should I compile again with the option "--with-unixodbc=/usr/local"? I decided to omit it because I do not need PHP/Perl interface. Best regards and thanks a lot! Guido, from Italy ------------ http://www.arsantiqua.org |
From: Martin E. <ma...@el...> - 2007-03-07 21:30:56
|
On Wednesday 07 March 2007 20:14, Jeff Smith wrote: > As I have noted in the bug, this has long been fixed in CVS. Yeah, ignore my dumb reply here. :o) I forgot that bug emails aren't forwarded back to the actual bug system... D'oh. |
From: Jeff S. <why...@ya...> - 2007-03-07 20:14:13
|
As I have noted in the bug, this has long been fixed in CVS.=0A=0AI would h= ave closed the bug too, but I have yet to receive authority to do that. Br= ian?=0A=0A -- Jeff Smith=0A=0A----- Original Message ----=0AFrom: Martin El= lis <ma...@el...>=0ATo: mdb...@li...=0ASent: We= dnesday, March 7, 2007 12:32:43 PM=0ASubject: Re: [mdb-dev] [ mdbtools-Bugs= -1675603 ] Error in declaration of mdb_backends (0.6pre1)=0A=0AOn Wednesday= 07 March 2007 10:40, SourceForge.net wrote:=0A> Initial Comment:=0A> When = compiling the source package downloaded from the project page:=0A>=0A> back= end.c:31: error: static declaration of 'mdb_backends' follows=0A> non-stati= c declaration ../../include/mdbtools.h:150: error: previous=0A> declaration= of 'mdb_backends' was here=0A>=0A> mdb_backends has different declarations= .=0A> In file include/mdbtools.h:=0A> extern GHashTable *mdb_backends;= =0A> In file src/libmdb/backend.c:=0A> static GHashTable *mdb_backends;=0A= =0AI think this was fixed in CVS a long time ago... or has it reappeared?= =0A=0AMartin=0A=0A=0A------------------------------------------------------= -------------------=0ATake Surveys. Earn Cash. Influence the Future of IT= =0AJoin SourceForge.net's Techsay panel and you'll get the chance to share = your=0Aopinions on IT & business topics through brief surveys-and earn cash= =0Ahttp://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV=0A_______________________________________________=0Amdbtools-dev = mailing list=0Am...@li...=0Ahttps://lists.sourcefor= ge.net/lists/listinfo/mdbtools-dev=0A=0A=0A=0A=0A=0A =0A___________________= _________________________________________________________________=0AIt's he= re! Your new message! =0AGet new email alerts with the free Yahoo! Toolbar= .=0Ahttp://tools.search.yahoo.com/toolbar/features/mail/ |
From: Martin E. <ma...@el...> - 2007-03-07 18:35:39
|
On Wednesday 07 March 2007 10:40, SourceForge.net wrote: > Initial Comment: > When compiling the source package downloaded from the project page: > > backend.c:31: error: static declaration of 'mdb_backends' follows > non-static declaration ../../include/mdbtools.h:150: error: previous > declaration of 'mdb_backends' was here > > mdb_backends has different declarations. > In file include/mdbtools.h: > extern GHashTable *mdb_backends; > In file src/libmdb/backend.c: > static GHashTable *mdb_backends; I think this was fixed in CVS a long time ago... or has it reappeared? Martin |
From: SourceForge.net <no...@so...> - 2007-03-07 10:40:19
|
Bugs item #1675603, was opened at 2007-03-07 02:40 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=1675603&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: libmdb Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Error in declaration of mdb_backends (0.6pre1) Initial Comment: When compiling the source package downloaded from the project page: backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration ../../include/mdbtools.h:150: error: previous declaration of 'mdb_backends' was here mdb_backends has different declarations. In file include/mdbtools.h: extern GHashTable *mdb_backends; In file src/libmdb/backend.c: static GHashTable *mdb_backends; The source compiles, and program works, when both are declared static. My system is a MacOSX 10.4.8, with all the needed libs installed. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1675603&group_id=2294 |
From: Seb <sp...@gm...> - 2007-02-19 19:40:48
|
On Mon, 19 Feb 2007 13:31:31 -0600, Seb <sp...@gm...> wrote: [...] > I have an schroot environment setup, where I was able to run mdb-tables > on a JET4 Access database without problems, whereas the same produced > the segmentation fault on the main AMD64 system. Any Debian developers > in the list who can comment on what is going on? Thanks. There is a bug report on this (http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=377542). -- Seb |
From: Seb <sp...@gm...> - 2007-02-19 19:32:50
|
On Sun, 17 Sep 2006 16:45:06 +0200, "Niels Tolstrup" <nt...@ex...> wrote: > Dear Sirs, I would like to use mdb-sql to query an MS Access database, > but I get an Segmentation fault. > I am using a 64 bit AMD Opteron with debian sarge and > mdbtools_0.5.99.0.6pre1.0.20050409-1_amd64 I am also experiencing the same problem on the current Debian testing and kernel: ,-----[ uname -a ] | Linux patagonia 2.6.18-3-amd64 #1 SMP Mon Dec 4 17:04:37 CET 2006 x86_64 GNU/Linux `----- and Debian mdbtools package: 0.5.99.0.6pre1.0.20051109-3. I have an schroot environment setup, where I was able to run mdb-tables on a JET4 Access database without problems, whereas the same produced the segmentation fault on the main AMD64 system. Any Debian developers in the list who can comment on what is going on? Thanks. -- Seb |
From: DANNE <deb...@gm...> - 2007-02-13 16:11:48
|
Hi, I'm very new to linux. I downloaded and installed mdbtools-0.6pre1. The install went well but I cannot use any of the command line utilities. I downloaded it to /home/myDirectory. Everytime I type in a command I get the error message "command not found". I have an Access 2000 database in my home directory called db1.mdb. I tried mdb-tables db1.mdb and got the same error "command not found". What have I done wrong? I also cannot find the man pages for mdb. Thank-you -- View this message in context: http://www.nabble.com/mdbtools-command-line-utilities-tf3221485.html#a8947079 Sent from the MDB Tools - Dev mailing list archive at Nabble.com. |
From: Chris R. <web...@gu...> - 2006-12-15 21:57:43
|
Hi, I was wondering if anyone knows of a web based or command line (*nix) tool for converting Access 97 format (JET3) to Access 2000/2003 (JET4) ? mdb-export has some unresolved issues with Access 97 (such as empty columns and incorrect column order) which don't happen with Access 2003 databases.. Great software but at least with Access 97 for me it's buggy to the point of being unusable ! I have no choice about using Access 97.. I need to extract data from upwards of several hundred databases in a day (via a php based daemon) so I can't just download and convert the files myself.. I don't know if it's important, but I have seen bug reports with simmilar problems to mine occuring on FreeBSD 6.1-RELEASE.. if it only happens under FBSD that would explain why nobody has been able to deal with it... Any suggestions would be welcome.. Regards, Chris |
From: Chris R. <web...@gu...> - 2006-12-12 20:37:23
|
Hi, I installed mdbtools along with unixODBC to connect to ms access databases via odbc. The problem is that regardless how many data sources I add in odbc.ini, it always uses the first database in the list.. odbcinst.ini: ---------------------- [MDBToolsODBC] Description = MDB Tools ODBC drivers Driver = /usr/local/lib/libmdbodbc.0 ---------------------- odbc.ini: ---------------------- [FTP] Description = FTP list Driver = MDBToolsODBC Database = /home/skeleton-man/public_html/water/ftp.mdb Servername = localhost UserName = Password = [Water] Description = Water Module Driver = MDBToolsODBC Trace = Yes TraceFile = /var/log/sql.log Database = /home/skeleton-man/public_html/water/water.mdb Servername = localhost UserName = Password = ----------------- In the above example you can clearly see I'm referencing two different databases, but regardless what I change, the second datasource (Water) always connects to ftp.mdb instead of water.mdb. If I were to swap the order of the data sources and put Water at the top, then both data sources would point to water.mdb and ftp.mdb would be ignored. I am running the latest versions of both mdbtools (0.6pre1) and unixODBC and at first thought this might've been a php bug, but the "isql" tool produces exactly the same results. I tried the unixODBC mailing list and they seemed to think it was a driver issue.. Any ideas ? Chris |
From: Igor K. <ik...@ea...> - 2006-12-12 00:37:12
|
Karl, Take a look at the project named FreeTDS. This is what you need... Thank you. -----Original Message----- >From: Carl Karsten <ca...@pe...> >Sent: Nov 18, 2006 4:11 PM >To: mdb...@li... >Subject: [mdb-dev] mdb-schema for MsSql/sybase > > >Has anyone made any attempts to add support for MsSql? > >what I am really interested in is converting the RI into something that MySql >WorkBench or dbd4 from http://fabforce.com can read. so far the only thing that >has worked for me is dbd4 to MsSql. > >few comments: oracle and MsSql have the same syntax for "add constraint", so >this will work for both: > > switch (backend) { > case 1: /* oracle */ > text = g_strconcat("alter table ", bound[1], > " add constraint ", bound[3], "_", bound[1], > " foreign key (", bound[0], ")" > " references ", bound[3], "(", bound[2], ")", NULL); > break; > } > >but... backend is 1 for oracle, 0 for everthing else due to this code: > > 249 int backend = 0; /* Backends: 1=oracle */ > > 254 if (strncmp(mdb->backend_name,"oracle",6) == 0) { > 255 backend = 1; > >so I hacked in a case for sybase: > 256 } else if (strncmp(mdb->backend_name,"sybase",6) == 0) { > 257 backend = 2; > >Now for the tricky part: the RI needs Primary Key's defined, and that curretnly >isn't happening. > >Anyone have some code to detect/generate Primary Key defs? > > >Carl K > > >------------------------------------------------------------------------- >Take Surveys. Earn Cash. Influence the Future of IT >Join SourceForge.net's Techsay panel and you'll get the chance to share your >opinions on IT & business topics through brief surveys - and earn cash >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >_______________________________________________ >mdbtools-dev mailing list >mdb...@li... >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
From: SourceForge.net <no...@so...> - 2006-11-24 03:16:24
|
Bugs item #1602076, was opened at 2006-11-24 16:16 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=1602076&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 Private: No Submitted By: Mike (snowflynz) Assigned to: Nobody/Anonymous (nobody) Summary: mdb-sql & mdb-export returning rows of NULL data Initial Comment: After successfully installing mdbtools 0.6pre1, I tested things by running some queries on a table that has 14 rows of data in it. However, mdb-sql returns the 14 rows, but with nothing (NULL) in them. See: 1 => select * from Cash_Rates 2 => go +-------+--------------------+----------+----------+----------+--------+--------------------+ |G_Code |E_Date |DailyRate |MvgAvg7 |AvgMat |Modified|ModDate | +-------+--------------------+----------+----------+----------+--------+--------------------+ | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | | | | | | |0 | | +-------+--------------------+----------+----------+----------+--------+--------------------+ 14 Rows retrieved The same happens with mdb-export: root@jaguar# mdb-export ***.mdb Cash_Rates G_Code,E_Date,DailyRate,MvgAvg7,AvgMat,Modified,ModDate ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" ,"",,,,0,"" All data is being returned as NULL, even though the correct number of rows are being reported. Result of mdb-ver: root@jaguar# mdb-ver ***.mdb JET4 Here's the schema of that table: DROP TABLE Cash_Rates; CREATE TABLE Cash_Rates ( G_Code Long Integer, E_Date DateTime (Short), DailyRate Double, MvgAvg7 Double, AvgMat Double, Modified Boolean, ModDate DateTime (Short) ); System: root@jaguar# uname -srm FreeBSD 6.1-RELEASE-p7 i386 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1602076&group_id=2294 |
From: Carl K. <ca...@pe...> - 2006-11-18 21:14:03
|
Has anyone made any attempts to add support for MsSql? what I am really interested in is converting the RI into something that MySql WorkBench or dbd4 from http://fabforce.com can read. so far the only thing that has worked for me is dbd4 to MsSql. few comments: oracle and MsSql have the same syntax for "add constraint", so this will work for both: switch (backend) { case 1: /* oracle */ text = g_strconcat("alter table ", bound[1], " add constraint ", bound[3], "_", bound[1], " foreign key (", bound[0], ")" " references ", bound[3], "(", bound[2], ")", NULL); break; } but... backend is 1 for oracle, 0 for everthing else due to this code: 249 int backend = 0; /* Backends: 1=oracle */ 254 if (strncmp(mdb->backend_name,"oracle",6) == 0) { 255 backend = 1; so I hacked in a case for sybase: 256 } else if (strncmp(mdb->backend_name,"sybase",6) == 0) { 257 backend = 2; Now for the tricky part: the RI needs Primary Key's defined, and that curretnly isn't happening. Anyone have some code to detect/generate Primary Key defs? Carl K |