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: Michael W. <mw...@ic...> - 2005-11-16 07:29:05
|
On Tue, Nov 15, 2005 at 12:48:42PM +0100, Roman wrote: > Hy! > > I have problems here with compiling mpdtools (0.5 and unixODBC 2.2.11) > with gcc 4.0.1: > > odbc.c: In function 'SQLError': > odbc.c:778: error: static declaration of 'bind_columns' follows non-static > declaration > odbc.c:200: error: previous implicit declaration of 'bind_columns' was here > odbc.c:1448: error: label at end of compound statement > make[2]: *** [odbc.lo] Error 1 > make[1]: *** [all-recursive] Error 1 > make: *** [all-recursive] Error 1 > > The last error is easily fixed with adding an "break;" after the last > 'case'.. but I was not able to fix the other problem. > > Is this error specific for this gcc-version? > Had anyone else this problems? I think so, but first try a later version of mdbtools before doing anything else. Preferably the latest CVS. 0.5 is quite old. -- Michael Wood <mw...@ic...> |
|
From: Roman <la...@gm...> - 2005-11-15 11:48:07
|
Hy! I have problems here with compiling mpdtools (0.5 and unixODBC 2.2.11) with gcc 4.0.1: odbc.c: In function 'SQLError': odbc.c:778: error: static declaration of 'bind_columns' follows non-static declaration odbc.c:200: error: previous implicit declaration of 'bind_columns' was here odbc.c:1448: error: label at end of compound statement make[2]: *** [odbc.lo] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive] Error 1 The last error is easily fixed with adding an "break;" after the last 'case'.. but I was not able to fix the other problem. Is this error specific for this gcc-version? Had anyone else this problems? thanks in advance for your help Roman |
|
From: Jeff S. <why...@ya...> - 2005-11-14 03:25:06
|
--- Igor Korot <ik...@ea...> wrote: > I successfully build the unixODBC 2.2.12, added the libmdbodbc.sofile as the driver and > the setup library. > But when I tried to add the DSN, I got the error message box, saying that "Could not > construct a property list for ()". > Also I have a 0.5 version of mdbtools right now. As far as I understand this is the > last stable version available ( I am not talking development version). > Also, be advised that I build it without the graphical support, just plain ODBC. 0.5 is too out of date to be of much use, even if it is the last stable release. It did not have the odbcinst interface built in (which is what is required of the setup library in unixODBC). At the least, use 0.6pre1. Preferably, use what is current in cvs. Even though it is not 'stable', it is actually in a lot better shape than 0.5. -- Jeff Smith __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com |
|
From: Igor K. <ik...@ea...> - 2005-11-11 23:27:31
|
OK, I successfully build the unixODBC 2.2.12, added the libmdbodbc.sofile as the driver and the setup library. But when I tried to add the DSN, I got the error message box, saying that "Could not construct a property list for ()". Also I have a 0.5 version of mdbtools right now. As far as I understand this is the last stable version available ( I am not talking development version). Also, be advised that I build it without the graphical support, just plain ODBC. Thank you on the follow-up on this. -----Original Message----- From: Igor Korot <ik...@ea...> Sent: Nov 6, 2005 9:04 AM To: Jeff Smith <why...@ya...> Cc: mdb...@li... Subject: Re: [mdb-dev] (no subject) Thank you for the reply, Jeff. Now, Is the version you recommend stable (i.e. buildable)? Also, for some reason, I couldn't run the setup portion of the library. Right n ow I upgraded the unixODBC to 2.2.11-r1, but it has a bug. And I don't remember what eror or problem I had. When the bug is fixed, I will let you know... Thank you. -----Original Message----- From: Jeff Smith <why...@ya...> Sent: Nov 6, 2005 1:11 AM To: Igor Korot <ik...@ea...> Cc: mdb...@li... Subject: Re: [mdb-dev] (no subject) --- Igor Korot <ik...@ea...> wrote: > I didn't know that. Is it with the some kind of ODBC bridge? Problem is they are not > with the GPL, so no help here... That's what it sounds like Sam is talking about. > I am trying to use mdbtools 0.5 and unixODBC 2.2.11-r1. The unixODBC compiled without I would highly recommend somthing newer than mdbtools 0.5. At least 0.6pre1, and preferably CVS. > the mdbtools support, I guess. I didn't see anything in the configure script for > unixODBC that puts the additional flag for the mdbtools... No, unixODBC does not come with any kind of mdbtools support. > Also, is there any setup library for the mdbtools, that I can use to set up the DSN > from ODBCConfig? The library libmdbodbc.so contains both the Driver and the Setup portions. -- Jeff Smith __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Igor K. <ik...@ea...> - 2005-11-06 17:09:22
|
Thank you for the reply, Jeff. Now, Is the version you recommend stable (i.e. buildable)? Also, for some reason, I couldn't run the setup portion of the library. Right n ow I upgraded the unixODBC to 2.2.11-r1, but it has a bug. And I don't remember what eror or problem I had. When the bug is fixed, I will let you know... Thank you. -----Original Message----- From: Jeff Smith <why...@ya...> Sent: Nov 6, 2005 1:11 AM To: Igor Korot <ik...@ea...> Cc: mdb...@li... Subject: Re: [mdb-dev] (no subject) --- Igor Korot <ik...@ea...> wrote: > I didn't know that. Is it with the some kind of ODBC bridge? Problem is they are not > with the GPL, so no help here... That's what it sounds like Sam is talking about. > I am trying to use mdbtools 0.5 and unixODBC 2.2.11-r1. The unixODBC compiled without I would highly recommend somthing newer than mdbtools 0.5. At least 0.6pre1, and preferably CVS. > the mdbtools support, I guess. I didn't see anything in the configure script for > unixODBC that puts the additional flag for the mdbtools... No, unixODBC does not come with any kind of mdbtools support. > Also, is there any setup library for the mdbtools, that I can use to set up the DSN > from ODBCConfig? The library libmdbodbc.so contains both the Driver and the Setup portions. -- Jeff Smith __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Jeff S. <why...@ya...> - 2005-11-06 09:11:46
|
--- Igor Korot <ik...@ea...> wrote: > I didn't know that. Is it with the some kind of ODBC bridge? Problem is they are not > with the GPL, so no help here... That's what it sounds like Sam is talking about. > I am trying to use mdbtools 0.5 and unixODBC 2.2.11-r1. The unixODBC compiled without I would highly recommend somthing newer than mdbtools 0.5. At least 0.6pre1, and preferably CVS. > the mdbtools support, I guess. I didn't see anything in the configure script for > unixODBC that puts the additional flag for the mdbtools... No, unixODBC does not come with any kind of mdbtools support. > Also, is there any setup library for the mdbtools, that I can use to set up the DSN > from ODBCConfig? The library libmdbodbc.so contains both the Driver and the Setup portions. -- Jeff Smith __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
|
From: Igor K. <ik...@ea...> - 2005-11-06 06:38:12
|
I didn't know that. Is it with the some kind of ODBC bridge? Problem is they are not with the GPL, so no help here... I am trying to use mdbtools 0.5 and unixODBC 2.2.11-r1. The unixODBC compiled without the mdbtools support, I guess. I didn't see anything in the configure script for unixODBC that puts the additional flag for the mdbtools... Also, is there any setup library for the mdbtools, that I can use to set up the DSN from ODBCConfig? Thank you. -----Original Message----- From: Sam Moffatt <pa...@gm...> Sent: Nov 4, 2005 7:47 PM To: Igor Korot <ik...@ea...> Cc: mdb...@li... Subject: Re: [mdb-dev] (no subject) Apparently you can configure ODBC to share resources remotely. I can't say I've ever done it or know where to start. But if you can do this, then I would suggest that this would mean that Windows accesses the database and you can use plain ODBC which should be better supported. What version of MDB tools are you using and have you compiled unixODBC with mdb tools support? On 11/5/05, Igor Korot <ik...@ea...> wrote: > Thank you for the reply, Sam. > What do you mean by "configure windows to share it via obc"? > What I did is following: > 1. Create a shared directory on the Windows box. > 2. Put an MDB file there. > 3. Mount this share from Linux as CIFS with "rw" access. > 4. Create the odbc.ini section for such file. I didn't put the "port=" line in there. > > Now the problem, I can connect using unixODBC isql, but the "SELECT" command fails. > > Did I miss anything? > > Thank you. > > -----Original Message----- > From: Sam Moffatt <pa...@gm...> > Sent: Nov 4, 2005 6:02 PM > To: Igor Korot <ik...@ea...> > Cc: mdb...@li... > Subject: Re: [mdb-dev] (no subject) > > If it is on another computer, what operating system is that other > computer running? If it's running windows, just configure windows to > share it via odbc and connect to that computer using pure odbc and you > should be fine. > > Sam > > On 11/5/05, Igor Korot <ik...@ea...> wrote: > > Hi, ALL, > > Can I use an mbtools software to connect to the ACCESS file on another compuer using the ODBC? What woul be the odbc.ini file in this case? > > > > Thank you. > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Martin E. <mar...@kd...> - 2005-11-05 13:38:35
|
On Friday 04 November 2005 20:58, Pim Bollen wrote: > first step mentioned in the INSTALL file fails: the file configure is > missing. Browsing the cvs tree on site I see this file has been put on the > attic with a lot of other files. I am afraid someone did a bit too much > cleaning ;-( How can I make this working ? Fear not. It's not supposed to be kept in CVS, because it's an automatically generated file. The file gets generated by the autotools programs when a release tarball is made, so I guess the INSTALL file only makes sense for installing releases. To install from CVS, make sure you have autoconf, automake, autoheader, libtoolize and aclocal in your path and then run ./autogen.sh from the top-level directory to create everything you need. The configure script should run automatically (but, of course, you can run it again if you need to use any configure options). Cheers Martin |
|
From: Sam M. <pa...@gm...> - 2005-11-05 03:54:17
|
Apparently you can configure ODBC to share resources remotely. I can't say I've ever done it or know where to start. But if you can do this, then I would suggest that this would mean that Windows accesses the database and you can use plain ODBC which should be better supported. What version of MDB tools are you using and have you compiled unixODBC with mdb tools support? On 11/5/05, Igor Korot <ik...@ea...> wrote: > Thank you for the reply, Sam. > What do you mean by "configure windows to share it via obc"? > What I did is following: > 1. Create a shared directory on the Windows box. > 2. Put an MDB file there. > 3. Mount this share from Linux as CIFS with "rw" access. > 4. Create the odbc.ini section for such file. I didn't put the "port=3D" = line in there. > > Now the problem, I can connect using unixODBC isql, but the "SELECT" comm= and fails. > > Did I miss anything? > > Thank you. > > -----Original Message----- > From: Sam Moffatt <pa...@gm...> > Sent: Nov 4, 2005 6:02 PM > To: Igor Korot <ik...@ea...> > Cc: mdb...@li... > Subject: Re: [mdb-dev] (no subject) > > If it is on another computer, what operating system is that other > computer running? If it's running windows, just configure windows to > share it via odbc and connect to that computer using pure odbc and you > should be fine. > > Sam > > On 11/5/05, Igor Korot <ik...@ea...> wrote: > > Hi, ALL, > > Can I use an mbtools software to connect to the ACCESS file on another = compuer using the ODBC? What woul be the odbc.ini file in this case? > > > > Thank you. > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. Dow= nload > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Downl= oad > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > |
|
From: Igor K. <ik...@ea...> - 2005-11-05 03:18:33
|
Thank you for the reply, Sam. What do you mean by "configure windows to share it via obc"? What I did is following: 1. Create a shared directory on the Windows box. 2. Put an MDB file there. 3. Mount this share from Linux as CIFS with "rw" access. 4. Create the odbc.ini section for such file. I didn't put the "port=" line in there. Now the problem, I can connect using unixODBC isql, but the "SELECT" command fails. Did I miss anything? Thank you. -----Original Message----- From: Sam Moffatt <pa...@gm...> Sent: Nov 4, 2005 6:02 PM To: Igor Korot <ik...@ea...> Cc: mdb...@li... Subject: Re: [mdb-dev] (no subject) If it is on another computer, what operating system is that other computer running? If it's running windows, just configure windows to share it via odbc and connect to that computer using pure odbc and you should be fine. Sam On 11/5/05, Igor Korot <ik...@ea...> wrote: > Hi, ALL, > Can I use an mbtools software to connect to the ACCESS file on another compuer using the ODBC? What woul be the odbc.ini file in this case? > > Thank you. > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Sam M. <pa...@gm...> - 2005-11-05 02:03:00
|
If it is on another computer, what operating system is that other computer running? If it's running windows, just configure windows to share it via odbc and connect to that computer using pure odbc and you should be fine. Sam On 11/5/05, Igor Korot <ik...@ea...> wrote: > Hi, ALL, > Can I use an mbtools software to connect to the ACCESS file on another co= mpuer using the ODBC? What woul be the odbc.ini file in this case? > > Thank you. > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Downl= oad > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
|
From: Igor K. <ik...@ea...> - 2005-11-04 22:45:30
|
Sorry mesage without the subject -----Original Message----- From: Igor Korot <ik...@ea...> Sent: Nov 4, 2005 4:13 PM To: mdb...@li... Subject: [mdb-dev] (no subject) Hi, ALL, Can I use an mbtools software to connect to the ACCESS file on another compuer using the ODBC? What woul be the odbc.ini file in this case? Thank you. ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Igor K. <ik...@ea...> - 2005-11-04 21:13:48
|
Hi, ALL, Can I use an mbtools software to connect to the ACCESS file on another compuer using the ODBC? What woul be the odbc.ini file in this case? Thank you. |
|
From: Pim B. <pim...@tu...> - 2005-11-04 20:59:22
|
Hi, When I get a fresh cvs tree with cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login cvs -z3 -d:pserver:ano...@cv...:/cvsroot/mdbtools co mdbtools as stated on the web site http://mdbtools.sourceforge.net/ the first step mentioned in the INSTALL file fails: the file configure is missing. Browsing the cvs tree on site I see this file has been put on the attic with a lot of other files. I am afraid someone did a bit too much cleaning ;-( How can I make this working ? Thanks, Pim |
|
From: Yasir A. <li...@en...> - 2005-11-04 20:16:01
|
Hi Jeff, >>Have any of the MDB Tools developers had a chance to look at my patch >>(below)? I sent this email in a few weeks ago. >> >> > >Thank you for the patch, I now have it committed. I fixed several other things in >neighboring functions at the same time. > > > That's excellent - thanks. >>>Just in case this isn't clear, the change is in data.c, function >>>mdb_xfer_bound_bool(), with the new code inserted at line 174. >>> >>> > >By the way, as with most open-source projects, we prefer patches in 'unified' >format. In case you don't know, you do this by adding the -u option to the >diff command. For instance 'cvs diff -u data.c'. It is easier to read >(in my opinion at least) and it gives some lines of context in case line numbers >in different people's versions of a file don't match up exactly. > > I didn't know this - I'm glad you told me (this is the first patch I've ever sent to an open source project!) Thanks again for all the work you and the other developers put into this product - I really appreciate it. Yasir |
|
From: Nicola S. <co...@wo...> - 2005-11-04 14:44:37
|
In the post you publish the php code disappears.
-- Nicola
Inizio del messaggio inoltrato:
> <?php
> putenv("ODBCINI=/usr/local/psa/home/vhosts/myaccount.com/.odbc.ini");
> $myDB = odbc_connect("TempMDB","","");
> ?>
|
|
From: Jeff S. <why...@ya...> - 2005-11-04 12:24:58
|
--- Yasir Assam <li...@en...> wrote: > Have any of the MDB Tools developers had a chance to look at my patch > (below)? I sent this email in a few weeks ago. Thank you for the patch, I now have it committed. I fixed several other things in neighboring functions at the same time. > > Just in case this isn't clear, the change is in data.c, function > > mdb_xfer_bound_bool(), with the new code inserted at line 174. By the way, as with most open-source projects, we prefer patches in 'unified' format. In case you don't know, you do this by adding the -u option to the diff command. For instance 'cvs diff -u data.c'. It is easier to read (in my opinion at least) and it gives some lines of context in case line numbers in different people's versions of a file don't match up exactly. -- Jeff Smith __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com |
|
From: <js...@ii...> - 2005-11-04 12:12:09
|
Have anybody hacked in binary representation of MS Access table/query defs? Brian? Is anybody interested in making progress here? I've recently looked at MSysObjects table, in particular 'LvProp' binary field. It is base64-encoded bytes containing some structures: - in tabledef case: fields properties: captions, discriptions and probably any other propoerty (I've identified mostly utf16 strings because it's easy) - in querydef case: it's more complex than for tabledefs Sample 'Shippers' table from sample 'Northwind' database has been tested. More information: 1. Detailed schema information for this table: http://kexi-project.org/tmp/msa/northwind_shippers_schema.pdf 2. uubase64-decoded contents of this 'MSysObjects.LvProp' field for this table: http://kexi-project.org/tmp/msa/shippers 3. the same data re-engineered using my hand-crafted python script: http://kexi-project.org/tmp/msa/shippers.log -- regards / pozdrawiam, Jaroslaw Staniek / OpenOffice Polska Kexi Developer: http://www.kexi-project.org | http://koffice.org/kexi Kexi support: http://www.kexi-project.org/support.html KDE3, KDE4 libraries for developing MS Windows applications: http://wiki.kde.org/tiki-index.php?page=KDElibs+for+win32 |
|
From: Nicola S. <co...@wo...> - 2005-11-04 11:57:14
|
Hi all, I have made a web application with PHP that retrieves data from a Microsoft Access MDB file stored on a Linux hosting provider. The problem is that I get this error message when I try to connect to the MDB database: Warning: odbc_connect(): SQL error: , SQL state in SQLConnect in ... at line ... As you can see there is not a SQL state code. Sometimes the code appears as a sequence of unreadable special characters. What do I do wrong? The configuration is the following one. The hosting provider have installed these softwares: - PHP / Apache - UnixODBC 2.2.11 - MDBTools 0.6pre1 I found this tutorial very useful http://bryanmills.net:8086/archives/000099.html Following the suggestions I have created the .odbc.ini file on my user root folder with the command odbcinst -i -s -f odbc.ini where odbc.ini file template is [TempMDB] Description = Microsoft Access Database Driver = /usr/local/lib/libmdbodbc.so.0 Database = /usr/local/psa/home/vhosts/myaccount.com/path/file.mdb Servername = localhost port = 9875 The hosting has assigned the port 9875 to my account. As you can see I have put the path driver because I could not create the odbcinst.ini (I do not have write permission in the /etc directory). This is the simple PHP code I wrote to connect to the MDB database <?php putenv("ODBCINI=/usr/local/psa/home/vhosts/myaccount.com/.odbc.ini"); $myDB = odbc_connect("TempMDB","",""); ?> If I execute that code I got the error message I wrote at the beginning of this post. Is there someone that can help me? Thank you. -- Nicola |
|
From: Yasir A. <li...@en...> - 2005-11-03 01:43:00
|
Hello,
Have any of the MDB Tools developers had a chance to look at my patch
(below)? I sent this email in a few weeks ago.
$ cvs diff data.c
Index: data.c
===================================================================
RCS file: /cvsroot/mdbtools/mdbtools/src/libmdb/data.c,v
retrieving revision 1.102
diff -r1.102 data.c
173a174,176
> if (col->len_ptr) {
> *col->len_ptr = 1;
> }
Thanks,
Yasir
> Many thanks to the team for developing this code - I've found it very
> useful.
>
> I'm using the latest CVS version on Linux
>
> I think I found a bug in data.c which causes mdb-export -I to
> sometimes print NULL for boolean columns (even when the value is not
> null).
>
> Here's the CVS diff:
>
> $ cvs diff data.c
> Index: data.c
> ===================================================================
> RCS file: /cvsroot/mdbtools/mdbtools/src/libmdb/data.c,v
> retrieving revision 1.102
> diff -r1.102 data.c
> 173a174,176
> > if (col->len_ptr) {
> > *col->len_ptr = 1;
> > }
>
> I hardly know the code at all, so my fix could be completely wrong,
> but it looks as though we're not updating *col->len_ptr for for
> boolean fields and this causes the -I switch of mdb-export (which
> relies on col->len_ptr) to think its value is 0. In fact I'm not sure
> of the value is ever set to 0 to begin with so whether it prints NULL
> or not depends on what's in the block of memory when bound_lens is
> allocated (see mdb-export.c).
>
> Just in case this isn't clear, the change is in data.c, function
> mdb_xfer_bound_bool(), with the new code inserted at line 174.
>
> Thanks,
> Yasir
|
|
From: Hans-Emil S. <Han...@tr...> - 2005-11-01 14:23:19
|
I have talked with Stephen J. Gowdy of the list. (He requested the = possibility to read binary fields on the list about two months ago = http://sourceforge.net/mailarchive/message.php?msg_id=3D12733896 .) Below is the result of his testing of the read binary patch. Who would be responsible for reviewing and accepting patches for the = CVS-sources? Hans-Emil -----Ursprungligt meddelande----- Fr=E5n: Stephen J. Gowdy [mailto:go...@sl...]=20 Skickat: den 31 oktober 2005 19:08 Till: Hans-Emil Skogh =C4mne: Re: VB: [mdb-dev] Patches for reading binary columns and = supressing newlines Hi Hans-Emil, Yeah, works fine; [antonia] ~/unix/PE3ToKimdaba > echo select fFolderInfoArray from = ImageTable where fImageOriginalFileName =3D \'img_0521.jpg\' | mdb-sql = -HF -p photos.mdb DC0600005D0000001D0000001B00000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000 I'm not subscribed to the list so I can't reply to your message, unless you can bounce it to me? regards, Stephen. On Mon, 31 Oct 2005, Hans-Emil Skogh wrote: > Sorry. Seems like SF does not archive attachments. Here are both the = patches. > > > > Hope it works better this time around. :-) > > > > Hans-Emil > > > > ________________________________ > > Fr=E5n: mdb...@li... = [mailto:mdb...@li...] F=F6r Hans-Emil Skogh > Skickat: den 26 oktober 2005 17:05 > Till: mdb...@li... > =C4mne: [mdb-dev] Patches for reading binary columns and supressing = newlines > > > > Hi! > > > > I have created two patches for MDBTools. Both are reliant on that = Pedro A. Aranda's patch = (http://sourceforge.net/mailarchive/forum.php?thread_id=3D8498445&forum_i= d=3D5183) is applied to make the mdb-sql tool work again. (Apply it with = the -R switch.) > > sql-read-binary.patch > Enables mdb-sql to read and output Access binary fields. This is vital = to access for example Adobe Photoshop Elements 3-databases. The binary = data is outputted as hex values. In pretty print the length is = truncated. > > sql-strip-newlines.patch > Adds a parameter -s to mdb-sql that replaces all newline characters = with spaces when not in pretty-print mode. This is very valuable when = using the output from mdb-sql in a script. > > The sql-read-binary patch has parts from Philip Gladstone's binary = patch = (http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D876414&grou= p_id=3D2294&atid=3D302294) > > It would be nice if both patches (and Pedros!) could be added to the = CVS source tree. > > Hans-Emil > -- /------------------------------------+-------------------------\ |Stephen J. Gowdy | SLAC, MailStop 34, | |http://www.slac.stanford.edu/~gowdy/ | 2575 Sand Hill Road, | |http://calendar.yahoo.com/gowdy | Menlo Park CA 94025, USA | |EMail: go...@sl... | Tel: +1 650 926 3144 | \------------------------------------+-------------------------/ |
|
From: Igor K. <ik...@ea...> - 2005-10-31 04:27:54
|
Hi, ALL, The ACCESS database file usually have a tables and forms, reports, macros etc. It's possible to split the tables and everything else into 2 different files. Do I have to do tha in order to connect using the "mdbtools"? Problem I am having is that I connected using the unixODBC "isql", but when I tried to isue a "SELECT" request, I received an error: "[ISQL]ERROR: Could not SQLExecute". Should I split the tables and everything else? Thank you for the reply. |
|
From: Jerome Y. <yu...@av...> - 2005-10-29 04:10:53
|
I am using mdbtools-0.6pre1 to read from a JET3 MDB and am seeing these
results and amnot sure what to do about them. I have used the Access
table-repair option in case there was some corruption, but still I get
this "row num 0..." stuff.
+----------------------------------------------------------------------
[1002] ~ $ echo "SELECT * FROM ProjectProperties" | mdb-sql \\
-p /home/jerome/avra/bwconvert/BW1035.mdb
ID Project Title Comments Contact Name Company Name
Company Address Company Facility Company Unit Image
Reading LVAL page 00015f
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 1506 row stop 2047
1 Unit 1-035
Marathon Ashland LLC Catlettsburg, KY Refinery 1
Unit 1-035 - Cumene /
1 Row retrieved
+----------------------------------------------------------------------
[1010] ~ $ prdata /home/jerome/avra/bwconvert/BW1035.mdb ProjectProperties
Reading LVAL page 00015f
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 12 row stop 2047
row num 0 row start 1506 row stop 2047
column 1 is 1
column 2 is Unit 1-035
column 3 is
column 4 is
column 5 is Marathon Ashland LLC
column 6 is Catlettsburg, KY
column 7 is Refinery 1
column 8 is Unit 1-035 - Cumene
column 9 is /
*** glibc detected *** corrupted double-linked list: 0x08623450 ***
Aborted
--
Jerome Yuzyk, Avra Software Lab Inc.
|
|
From: Brian B. <bri...@gm...> - 2005-10-17 13:22:06
|
Interesting. The key words are "The new version is fully backwards compatible with the old, so it will read & write files from earlier versions without any problems". Does this mean the core database format remains the same, or is this the old "save as access 97 format" trick? I'm hoping for the former. There were solid reasons for changing from JET3 to JET4 (unicode) but they've stuck with JET4 through two versions and I don't see any obvious reason to scrap it now. The complex data thing seems more relevent to userland (Access) then to the core engine. Maybe we can look forward to a few new system tables and that'= s it, hopefully. Brian 2005/10/17, Martin Ellis <m.a...@nc...>: > > > Thought this might be of interest to readers here: > > http://blogs.msdn.com/access/ > > Cheers > Martin > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
|
From: Martin E. <m.a...@nc...> - 2005-10-17 10:51:11
|
Thought this might be of interest to readers here: http://blogs.msdn.com/access/ Cheers Martin |
26 messages has been excluded from this view by a project administrator.
