mdbtools-dev

[mdb-dev] Error at Line : syntax error near exec

[Szilagyi S. <szi...@in...>]

Dear All!

I use unixODBC with mdbtools
unixODBC works good, mdbtools works good BUT together...
So what can I do?

---unixODBC& MDBTOOLS---
isql -v Cats myuser mypassword
[...]
SQL> help
Error at Line : syntax error near exec
[08001][unixODBC]Couldn't parse SQL

[ISQL]ERROR: Could not SQLTables

---mdb-tables---
$ mdb-tables /home/user/Acc.mdb
Account Types Accounts Reports Transactions

----with MySQL---
isql -v MySQL1 myuser mypassword
works great* with MySQL
[...]
*works great mean SQL>help gives the table names back


#################################
INI:
/etc/odbc.ini
--->8----
[Cats]
Description = Microsoft Access Database of Dogs
Driver = MDBToolsODBC
Trace = No
TraceFile =
Database = /home/user/Acc.mdb
Servername = 192.168.2.234
UserName = myuser
Password = mypassword
Port = 5432

[MySQL1]
Description = MySQL test database
Driver = MySQL
Trace = No
TraceFile =
Servername = 192.168.2.234
UserName = myuser
Password = mypassword
PORT = 3306
Database = test
--->8---

/etc/odbcinst.ini
--->8---
[MySQL]
Description     = Myodbc driver for MySQL
Driver          = /usr/local/lib/libmyodbc3.so
Setup           = /usr/local/lib/libmyodbc3S.so

[Default]
Driver          = /usr/local/lib/libmdbodbc.so.0
FileUsage               = 1
UsageCount              = 2

[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/local/lib/libmdbodbc.so.0
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =
Driver          = /usr/lib/libmyodbc3.so
UsageCount              = 1
--->8---

CONFIGURED:
=====================================================
/mdbtools-0.6pre1$ ./configure --with-unixodbc=/usr/local
make; su -c "make install"
[...]
Libraries have been installed in:
   /usr/local/lib
====================================================
/unixODBC-2.2.11$ ./configure --sysconfdir=/etc --enable-gui=no 
--enable-shared --with-odbc --with-msql-lib
make; su -c "make install"
[...]
Libraries have been installed in:
   /usr/local/lib
====================================================

TABLE SOURCE
kexi-project.org/download/tests/msa_templates.tar.gz  ~5MB
there is 'Accounts ledger.mdb' in it

[mdb-dev] mdb-sql and Whitespace in Column Names

[Nathan O. <nat...@gm...>]

Hi!

I've installed mdb-tools from a Slackware package I found on
LinuxPackages.net. The name of the package is mdbtools-20051217,
implying that it's a CVS build from a few months ago.

I have an mdb file. It has a number of columns whose names include
whitespace. mdb-sql doesn't seem to be able to work with these
columns. My problem is exactly like the one outlined here:

http://sourceforge.net/tracker/?group_id=3D2294&atid=3D102294&func=3Ddetail=
&aid=3D924696

The only response to that post, written two years ago, indicates that
0.6-pre1 should be able to handle this. There are no further posts.

So my questions are:

1) Is this a known issue or am I doing something wrong?

2) The main web site references release 0.5. Have there been any
intermittent releases since 0.6-pre1, mentioned over two years ago?

Thanks for any response of any kind!

[mdb-dev] DSN-less connection not supported?

[Mateusz L. <ma...@lo...>]

Hi,

Today, I did small tests with unixODBC / MDB Tools and I see that this
tandem does not support DSN-less connections.
Am I right?

I tried to connect using ODBC and libmdbodbc drivers using following
connection string:

"Driver={Microsoft Access Driver (*.mdb)};Dbq=//path/to/file.mdb;"

My odbcinst.ini file includes properly defined driver:

mloskot:/etc$ cat odbcinst.ini
[Microsoft Access Driver (*.mdb)]
Description = MDB Tools ODBC drivers
Driver     = /usr/local/lib/libmdbodbc.so.0
Setup      =
FileUsage  = 2
CPTimeout  =
CPReuse    =

AFAIK FileUsage=2 means that the drivers should treat the file as a
whole database but not as a single table.
I tried to use FileUsage = 1 too, no difference.

I'm getting following error message:

[unixODBC]Could not find DSN in connect string

I digged into MDB Tools sources and I revealed that this message comes
from MDN Tools. Next, I found that the SQLDriverConnect function
searches connection string for 'DSN' token.
It seems quite strange, because, as I read in ODBC docs in the MSDN,
DSN-less connection string is also valid.

I could not find any useful information in unixODBC or MDB Tools docs
and mailing lists archives.

Could anyone confirm if my assumptions are correct and how to handle
DSN-less connection?

Cheers
-- 
Mateusz Łoskot
http://mateusz.loskot.net

[mdb-dev] Invalid soname

[Mateusz L. <ma...@lo...>]

Hi,

I'm writing first time on this list, so I'm saying "Hello!" to all members.

Today, I decided to build MDB Tools on my Ubuntu 5.10 box and after I
run 'make install' command I got invalid soname of libraries and
symbolic links.

Here is step by stack trace what I did. I installex unixODBC 2.2.11 from
Ubuntu packages with /usr as a prefix.

$ ./configure --with-unixodbc=/usr
$ make
$ make instal

$ ls -l /usr/local/lib/libmdb*
lrwxrwxrwx  1 root root     12 2006-05-23 22:27 /usr/local/lib/libmdb ->
libmdb.0.0.0
lrwxrwxrwx  1 root root     12 2006-05-23 22:27 /usr/local/lib/libmdb.0
-> libmdb.0.0.0
-rwxr-xr-x  1 root root 199442 2006-05-23 22:27 /usr/local/lib/libmdb.0.0.0
-rw-r--r--  1 root root 299908 2006-05-23 22:27 /usr/local/lib/libmdb.a
-rwxr-xr-x  1 root root    796 2006-05-23 22:27 /usr/local/lib/libmdb.la
lrwxrwxrwx  1 root root     16 2006-05-23 22:27
/usr/local/lib/libmdbodbc -> libmdbodbc.0.0.0
lrwxrwxrwx  1 root root     16 2006-05-23 22:27
/usr/local/lib/libmdbodbc.0 -> libmdbodbc.0.0.0
-rwxr-xr-x  1 root root 315009 2006-05-23 22:27
/usr/local/lib/libmdbodbc.0.0.0
-rw-r--r--  1 root root 457604 2006-05-23 22:27 /usr/local/lib/libmdbodbc.a
-rwxr-xr-x  1 root root    895 2006-05-23 22:27 /usr/local/lib/libmdbodbc.la
lrwxrwxrwx  1 root root     15 2006-05-23 22:27 /usr/local/lib/libmdbsql
-> libmdbsql.0.0.0
lrwxrwxrwx  1 root root     15 2006-05-23 22:27
/usr/local/lib/libmdbsql.0 -> libmdbsql.0.0.0
-rwxr-xr-x  1 root root  80408 2006-05-23 22:27
/usr/local/lib/libmdbsql.0.0.0
-rw-r--r--  1 root root  91024 2006-05-23 22:27 /usr/local/lib/libmdbsql.a
-rwxr-xr-x  1 root root    813 2006-05-23 22:27 /usr/local/lib/libmdbsql.la


As you can see, MDB Tools libraries have invalid soname.
Accordint to odbcinst.ini definition of MDB driver, I had to create symlink:

$ ln -s /usr/local/lib/libmdbodbc.0.0.0 /usr/local/lib/libmdbodbc.so.0

Is this known issue or I did something wrong?

Cheers
-- 
Mateusz Łoskot
http://mateusz.loskot.net

Re: [mdb-dev] Re: Newbie with lots of questions

[Sam M. <pa...@gm...>]

MySQL supports foreign key constraints with their innodb system I
believe. MyISAM doesn't support foreign key constraints
(relationships) iirc.

Sam

On 5/19/06, Seb <sp...@gm...> wrote:
> Ross Johnson <Ros...@ho...> wrote:
>
> [...]
>
> > I've found OOo Base together with PostgreSQL via the PostgreSQL.org
> > JDBC3 driver works very well. Whichever database you choose, most/all o=
f
> > the GUI Query Designer works as does the Forms designer, or you can
> > write pass-through queries to access database-specific features if you
> > want. I've just completed a large job using these components building a=
n
> > application that includes over 800 form controls spread over a dozen or
> > more forms. I used mdb-tools to migrate the Access data to PostgreSQL.
>
> Thanks for the corrections, OOo Base seems to have come a long way since =
I
> last delved into this.  Sounds as if it's worth a try for sure!
>
> I don't know how PostgreSQL works, as I've already chosen MySQL some time
> ago, but were you able to migrate your Access relationships?  If you were=
,
> could you please point out the procedure, if it's not a hassle?
>
> I was able to migrate all my Access tables to MySQL with mdb-tools, but
> had to reconstruct relationships on a per-query basis afterwards.  I'm
> still learning MySQL, so I'm not even sure it supports a system of
> relationships in the sense that Access does.
>
>
> --
> Seb
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

Re: [mdb-dev] Newbie with lots of questions

[david w. <dav...@gm...>]

On 17/05/06, "Dr. Juan Pedro S=E1nchez C." <jpc...@ya...>=
 wrote:
[...]
>
>  My question is if MDB Tools will help me migrate my Access DB to Linux.
> Which are the first steps to take, you consider I should take or, do you
> know of a database program with a GUI Interface that works in Linux?

I love it when there's a chance to talk about two mailing lists I'm on
at the same time.  I'm also on the dabo list (mostly lurking). dabo
aims to use python as an open source alternative to foxpro. You can
use a number of different backends (mysql, postgresql, sqlite, etc)
and it is developing very fast. There are already some very nice gui
development tools, some execellent screencasts to show you how to do
things and the two main developers are extra-ordinarily helpful. This
might be a bit too much for you all in one go (learning a new
database, and then learning python) but might be useful for others to
know about and useful for you in the long run.

Now, I wonder what it would take for mdbtools to integrate with dabo
so that access DBs could be used with a dabo gui?

http://dabodev.com/

Dave
--=20
David Whiting

[mdb-dev] Re: Newbie with lots of questions

[Seb <sp...@gm...>]

Ross Johnson <Ros...@ho...> wrote:

[...]

> I've found OOo Base together with PostgreSQL via the PostgreSQL.org
> JDBC3 driver works very well. Whichever database you choose, most/all of
> the GUI Query Designer works as does the Forms designer, or you can
> write pass-through queries to access database-specific features if you
> want. I've just completed a large job using these components building an
> application that includes over 800 form controls spread over a dozen or
> more forms. I used mdb-tools to migrate the Access data to PostgreSQL.

Thanks for the corrections, OOo Base seems to have come a long way since I
last delved into this.  Sounds as if it's worth a try for sure!

I don't know how PostgreSQL works, as I've already chosen MySQL some time
ago, but were you able to migrate your Access relationships?  If you were,
could you please point out the procedure, if it's not a hassle?

I was able to migrate all my Access tables to MySQL with mdb-tools, but
had to reconstruct relationships on a per-query basis afterwards.  I'm
still learning MySQL, so I'm not even sure it supports a system of
relationships in the sense that Access does.


-- 
Seb

Re: [mdb-dev] Re: Newbie with lots of questions

[Ross J. <Ros...@ho...>]

Seb wrote:

>Hi Juan Pedro,
>
>"Dr. Juan Pedro Sánchez C." <jpc...@ya...> wrote:
>
>[...]
>
>  
>
>>My question is if MDB Tools will help me migrate my Access DB to
>>Linux. Which are the first steps to take, you consider I should take or,
>>do you know of a database program with a GUI Interface that works in
>>Linux?
>>    
>>
>
>Others might correct me here, but there is not a unified system like
>Access, providing both the database engine (to store and define the
>database), and an intuitive GUI interface in Linux.
>
Yes, some correction is in order. Several people have mentioned 
OpenOffice.org, which does exactly this on Linux or Windows or Solaris 
or Mac OSX. You need OOo 2.x though, whose Base component uses the HSQL 
database engine mentioned in another repsonse as it's integrated 
database. OOo Base provides GUI forms and query designers etc. and can 
also connect to third party database systems like MySQL or PostgreSQL 
and several others via various drivers such as OOo's native SDBC, or 
ODBC or JDBC.

>  So the user has to
>think about which engine to use (MySQL and Postgresql are the most
>popular) and which GUI.  Not all GUIs will fully exploit the capabilities
>of either engine, so that's another thing to worry about.
>  
>
I've found OOo Base together with PostgreSQL via the PostgreSQL.org 
JDBC3 driver works very well. Whichever database you choose, most/all of 
the GUI Query Designer works as does the Forms designer, or you can 
write pass-through queries to access database-specific features if you 
want. I've just completed a large job using these components building an 
application that includes over 800 form controls spread over a dozen or 
more forms. I used mdb-tools to migrate the Access data to PostgreSQL.

>In any case, prepare for a looong and tedious learning curve with MySQL or
>Postgresql; no more drawing of lines and clicking around for basic stuff
>as defining relationships.  In short, the user is expected to learn a
>database computer language, before he/she can start actually using data.
>  
>
Not true, but there are some things you won't be able to do, like design 
cross-table queries, which I think look pretty incomprehensible and 
tedious in Access 97 anyway. But these can be done within PostgreSQL or 
MySQL using functions. There will obviously be a learning curve since 
OOo Base is not an Access clone, although you will find the query 
designer quite familiar.

>That being said, one can always get Codeweavers' Crossover Office, which
>lets you run a large number of Windoze applications.  That allows you to
>continue using your Access database, until you get to grips with all of
>the above.
>  
>
Give OOo a try.

Ross

Re: [mdb-dev] Patch - mdbtools-0.6pre1 compilation problem

[Martin E. <m.a...@nc...>]

On Thursday 18 May 2006 16:54, Moloko Vellocet wrote:
> Hi, I found a compilation problem with mdbtools-0.6pre1, I'm
> running: Fedora Core 4
> gcc-4.0.0
> glibc 2.3.5
>
> The problem is with the static variable "GHashTable *mdb_backends'
> found in the files:
> - include/mdbtools.h
> - src/libmdb/backend.c
> I've ported this static variable to the header mdbtools.h and
> declared it as extern in backend.c.

Declaring this in a header doesn't seem like the right thing to do, 
to me at least.  What's the error you get?

Hmm, in fact, wasn't gcc 4.0.0 blacklisted in many toolchains for 
being buggy?  I'm pretty sure it was in KDE.
And I particularly remember Fedora shipping buggy compilers (and 
patched with unofficial patches) on more than one occasion.  :o(

Perhaps it's a better idea to try a different compiler version?

Martin

[mdb-dev] Patch - mdbtools-0.6pre1 compilation problem

[Moloko V. <all...@gm...>]

Hi, I found a compilation problem with mdbtools-0.6pre1, I'm running:
Fedora Core 4
gcc-4.0.0
glibc 2.3.5

The problem is with the static variable "GHashTable *mdb_backends' found in
the files:
- include/mdbtools.h
- src/libmdb/backend.c
I've ported this static variable to the header mdbtools.h and declared it a=
s
extern in backend.c.


My correction:

diff -ruN mdbtools-0.6pre1/include/mdbtools.h mdbtools-0.6pre1-ajos
/include/mdbtools.h
--- mdbtools-0.6pre1/include/mdbtools.h 2004-06-16 19:42:19.000000000 -0400
+++ mdbtools-0.6pre1-ajos/include/mdbtools.h    2006-05-18 11:41:
31.000000000 -0400
@@ -147,7 +147,7 @@
 #define IS_JET3(mdb) (mdb->f->jet_version=3D=3DMDB_VER_JET3)

 /* hash to store registered backends */
-extern GHashTable      *mdb_backends;
+static GHashTable      *mdb_backends;

 /* forward declarations */
 typedef struct mdbindex MdbIndex;
diff -ruN mdbtools-0.6pre1/include/mdbver.h mdbtools-0.6pre1-ajos
/include/mdbver.h
--- mdbtools-0.6pre1/include/mdbver.h   2004-06-18 05:35:02.000000000 -0400
+++ mdbtools-0.6pre1-ajos/include/mdbver.h      1969-12-31 20:00:
00.000000000 -0400
@@ -1,26 +0,0 @@
-/* MDB Tools - A library for reading MS Access database files
- * Copyright (C) 2000 Brian Bruns
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Library General Public
- * License as published by the Free Software Foundation; either
- * version 2 of the License, or (at your option) any later version.
- *
- * This library is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
- * Library General Public License for more details.
- *
- * You should have received a copy of the GNU Library General Public
- * License along with this library; if not, write to the
- * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
- * Boston, MA 02111-1307, USA.
- */
-
-#ifndef _mdbver_h_
-#define _mdbver_h_
-
-#define MDB_FULL_VERSION "mdbtools v0.6pre1"
-#define MDB_VERSION_NO "0.6pre1"
-
-#endif
diff -ruN mdbtools-0.6pre1/src/libmdb/backend.c mdbtools-0.6pre1-ajos
/src/libmdb/backend.c
--- mdbtools-0.6pre1/src/libmdb/backend.c       2004-06-11 09:56:
41.000000000 -0400
+++ mdbtools-0.6pre1-ajos/src/libmdb/backend.c  2006-05-18 11:42:
09.000000000 -0400
@@ -28,7 +28,7 @@
 #endif

 static int is_init;
-static GHashTable *mdb_backends;
+extern GHashTable *mdb_backends;

    /*    Access data types */
 static MdbBackendType mdb_access_types[] =3D {




--=20
_______________________________
Allann J. O. Silva

"I received the fundamentals of my education in school, but that was not
enough. My real education, the superstructure, the details, the true
architecture, I got out of the public library. For an impoverished child
whose family could not afford to buy books, the library was the open door t=
o
wonder and achievement, and I can never be sufficiently grateful that I had
the wit to charge through that door and make the most of it." (from I.
Asimov, 1994)

Re: [mdb-dev] Newbie with lots of questions

[Philip S. <phi...@gm...>]

I took Martin's advice and gave kexi a whirl this afternoon on my debian
linux machine and found it to be very attractive. I didn't have long to pla=
y
with it though, as i broke my X server trying to upgrade it. Ouch. Anyway,
kexi is the best/closest thing I've seen to Access GUI-fication. In terms o=
f
graphic design, it kills Access.

On 5/17/06, Martin Ellis <m.a...@nc...> wrote:
>
> On Wednesday 17 May 2006 16:09, you wrote:
> > There are many opensource db engine that stores data in one file.
> > The most populars are:
> > - sqlite: http://www.sqlite.org (C)
> > - Hypersonic SQL: http://hsqldb.org/ (java)
> >
> > If you search the web you will find many more of them!
>
> Juan said he needs a replacement for *MS Access*.
>
> These links aren't replacements for Access, they are a replacement for
> JET, one of the technologies behind Access.   These projects are
> *used by* replacements for Access,  but they are not replacements for
> Access.
>
> Please don't confuse the two.
>
> Martin
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>



--=20
Philip Stephens
http://regal.sdsu.edu/pmwiki/Main/PhilipStephens

Re: [mdb-dev] Newbie with lots of questions

[Jonathan D. <dix...@ly...>]

> My question is if MDB Tools will help me migrate my Access DB to Linux. W=
hich=20
> are the first steps to take, you consider I should take or, do you know o=
f a=20
> database program with a GUI Interface that works in Linux?

I will echo several others in suggesting the OpenOffice.org Base as a solut=
ion. While not quite as polished yet as MS Access in some respects, it stil=
l can be a powerful tool (and integrates well with the rest of the suite).

Added bonus is that you should be able to use OOo on your MS PC to transfer=
 the Access database to the native OOo database format (or any of several o=
ther choices given in the program), since under Windows the OOo Base progra=
m is able to read/write/etc Access database files.

Good luck in your switch,

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

Re: [mdb-dev] Newbie with lots of questions

[Philip S. <phi...@gm...>]

On 5/17/06, Martin Ellis <ma...@el...> wrote:
>
> On Wednesday 17 May 2006 14:39, Philip Stephens wrote:
> > Basically you're going to have to migrate your db to mysql or
> > postgresql.
>
> I'm not sure that's the case at all.  There are plenty of database
> applications that will let you store the database in a single file as
> in Access.
>
> These include Kexi, Knoda, OpenOffice.org Base, and I'm sure the Gnome
> community have an offering too.  It'd be much more prudent to check
> that none of these satisfy the requirements first.
>
> Encouraging people to learn how to set up, secure, and arrange a
> decent backup arrangement for a database server isn't a good way to
> introduce people to databases on Linux!


Point well taken.  I am a newbie to db's and I am glad you were here to
re-direct and educate.  What if I had said nothing?  I certainly would not
have found out about kexi or knoda anytime soon. Thanks.

Martin
>
>


--=20
Philip Stephens
http://regal.sdsu.edu/pmwiki/Main/PhilipStephens

Re: [mdb-dev] Newbie with lots of questions

[Martin E. <ma...@el...>]

On Wednesday 17 May 2006 16:09, you wrote:
> There are many opensource db engine that stores data in one file.
> The most populars are:
> - sqlite: http://www.sqlite.org (C)
> - Hypersonic SQL: http://hsqldb.org/ (java)
>
> If you search the web you will find many more of them!

Juan said he needs a replacement for *MS Access*.

These links aren't replacements for Access, they are a replacement for 
JET, one of the technologies behind Access.   These projects are 
*used by* replacements for Access,  but they are not replacements for 
Access.

Please don't confuse the two.

Martin

Re: [mdb-dev] Newbie with lots of questions

[Martin E. <m.a...@nc...>]

On Wednesday 17 May 2006 16:09, you wrote:
> There are many opensource db engine that stores data in one file.
> The most populars are:
> - sqlite: http://www.sqlite.org (C)
> - Hypersonic SQL: http://hsqldb.org/ (java)
>
> If you search the web you will find many more of them!

Juan said he needs a replacement for *MS Access*.

These links aren't replacements for Access, they are a replacement for 
JET, one of the technologies behind Access.   These projects are 
*used by* replacements for Access,  but they are not replacements for 
Access.

Please don't confuse the two.

Martin

Re: [mdb-dev] Newbie with lots of questions

[Florian F. <f.f...@ty...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!
As far as i know: When you need multiuser-access to a filebased database
engine, than there is only MS-Access or Sqlite. all other filebased
database engines, like hsqldb (which is used in OpenOffice Base), allow
only singleuser-access. or that you run a server process. but than the
benefits of a filebased database are gone.

Thats what i found out after a little research. Does anyone know another
a filebased database engine, which allows multiuser-access (and don't
requires you to run a server)?

Greetings,
Florian

Nagy Zolt=C3=A1n schrieb:
> 2006. m=C3=A1jus 17. 15.57 d=C3=A1tummal Martin Ellis ezt =C3=ADrta:
>> I'm not sure that's the case at all.  There are plenty of database
>> applications that will let you store the database in a single file as
>> in Access.
>=20
> Hi!
>=20
> There are many opensource db engine that stores data in one file. The=20
> most populars are:
> - sqlite: http://www.sqlite.org (C)
> - Hypersonic SQL: http://hsqldb.org/ (java)
>=20
> If you search the web you will find many more of them!
>=20

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: GnuPT 2.7.2
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEa0NPkU9TjJRmr5gRAticAKDEmpEJEvo1RSZBHuMU63Rnfyh1qACeMyqD
pOA/8fRkc6xvjQEdA1npmLo=3D
=3DesEU
-----END PGP SIGNATURE-----

[mdb-dev] Re: Newbie with lots of questions

[Seb <sp...@gm...>]

Hi Juan Pedro,

"Dr. Juan Pedro Sánchez C." <jpc...@ya...> wrote:

[...]

> My question is if MDB Tools will help me migrate my Access DB to
> Linux. Which are the first steps to take, you consider I should take or,
> do you know of a database program with a GUI Interface that works in
> Linux?

Others might correct me here, but there is not a unified system like
Access, providing both the database engine (to store and define the
database), and an intuitive GUI interface in Linux.  So the user has to
think about which engine to use (MySQL and Postgresql are the most
popular) and which GUI.  Not all GUIs will fully exploit the capabilities
of either engine, so that's another thing to worry about.

In any case, prepare for a looong and tedious learning curve with MySQL or
Postgresql; no more drawing of lines and clicking around for basic stuff
as defining relationships.  In short, the user is expected to learn a
database computer language, before he/she can start actually using data.

That being said, one can always get Codeweavers' Crossover Office, which
lets you run a large number of Windoze applications.  That allows you to
continue using your Access database, until you get to grips with all of
the above.


-- 
Seb

Re: [mdb-dev] Newbie with lots of questions

[Nagy <nag...@po...>]

2006. m=C3=A1jus 17. 15.57 d=C3=A1tummal Martin Ellis ezt =C3=ADrta:
> I'm not sure that's the case at all. =C2=A0There are plenty of database
> applications that will let you store the database in a single file as
> in Access.

Hi!

There are many opensource db engine that stores data in one file. The=20
most populars are:
=2D sqlite: http://www.sqlite.org (C)
=2D Hypersonic SQL: http://hsqldb.org/ (java)

If you search the web you will find many more of them!

=2D-=20
Zolt=C3=A1n Nagy

Re: [mdb-dev] Newbie with lots of questions

[Martin E. <ma...@el...>]

On Wednesday 17 May 2006 14:39, Philip Stephens wrote:
> Basically you're going to have to migrate your db to mysql or
> postgresql. 

I'm not sure that's the case at all.  There are plenty of database 
applications that will let you store the database in a single file as 
in Access.

These include Kexi, Knoda, OpenOffice.org Base, and I'm sure the Gnome 
community have an offering too.  It'd be much more prudent to check 
that none of these satisfy the requirements first.

Encouraging people to learn how to set up, secure, and arrange a 
decent backup arrangement for a database server isn't a good way to 
introduce people to databases on Linux!

Martin

Re: [mdb-dev] Newbie with lots of questions

[Philip S. <phi...@gm...>]

I googled "mysql front-end for Linux"
First hit was Navicat, so you could try that.
But there are many more.

Basically you're going to have to migrate your db to mysql or postgresql.
This is not too hard, and should be a forgiving process.  You may dump your
db into text format, then upload it into the new db (mysql?).  If you have
geographic data such as addresses, and you want to be able to map or query
based on geography, I'd recommend Postgresql with the PostGIS extension.
I've tried the open office 2.0 stuff and it does not work as well as mysql
(although, isn't it supposedly built on it?)

If you have a Mac, then I heartily recommend YourSQL as a front-end.

Good luck.



On 5/17/06, Joachim Kruyswijk <jo...@kr...> wrote:
>
> On Wednesday 17 May 2006 02:58, Dr. Juan Pedro S=E1nchez C. wrote:
>
> > [...] or, do you know of a database program with a GUI Interface
> > that works in Linux?
>
> OpenOffice has a database with a GUI interface called Base (see
> http://www.openoffice.org/product/base.html). The description seems to
> come
> close to your requirements.
>
> Another possibility is: using an Apache web server with PHP / mySQL, and
> use
> phpMyAdmin to get started.
>
> Regards,
>
> Joachim Kruyswijk
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=120709&bid&3057&dat=121642
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>



--=20
Philip Stephens
http://regal.sdsu.edu/pmwiki/Main/PhilipStephens

Re: [mdb-dev] Newbie with lots of questions

[Martin E. <m.a...@nc...>]

On Wednesday 17 May 2006 10:02, Joachim Kruyswijk wrote:
> On Wednesday 17 May 2006 02:58, Dr. Juan Pedro S=C3=A1nchez C. wrote:
> > [...] or, do you know of a database program with a GUI Interface
> > that works in Linux?
>
> OpenOffice has a database with a GUI interface called Base (see
> http://www.openoffice.org/product/base.html). The description seems
> to come close to your requirements.

Another possibility is Kexi.

The MS Access import plugin for Kexi has a slightly patched version of=20
MDBTools which seems to do better on importing some MDB files as=20
compared to OpenOffice Base (e.g. the famous 'Northwind' example=20
database).

Martin

Re: [mdb-dev] Newbie with lots of questions

[Joachim K. <jo...@kr...>]

On Wednesday 17 May 2006 02:58, Dr. Juan Pedro S=C3=A1nchez C. wrote:

> [...] or, do you know of a database program with a GUI Interface=20
> that works in Linux?=20

OpenOffice has a database with a GUI interface called Base (see=20
http://www.openoffice.org/product/base.html). The description seems to come=
=20
close to your requirements.=20

Another possibility is: using an Apache web server with PHP / mySQL, and us=
e=20
phpMyAdmin to get started.

Regards,

Joachim Kruyswijk

[mdb-dev] Newbie with lots of questions

[<jpc...@ya...>]

Thank you for accepting me in this list.
I joined here, because:

    * I've been trying to change my Access Database to Linux
    * Access is the only program I need to use that I can't migrate to Linux
    * Access is the only obstacle I've to migrate completely to Linux
      and forget FOREVER of MS and Windows

I create this Access DB several years ago to have a control of my 
pediatric patients. It works fairly well, and I've adapted to my daily 
practice needs.
On the other hand, some time later I discovered Linux and Open Source 
programs, which I use in Windows.

My question is if MDB Tools will help me migrate my Access DB to Linux. 
Which are the first steps to take, you consider I should take or, do you 
know of a database program with a GUI Interface that works in Linux?

Thank you for your patience and for your help.

Juan Pedro Sanchez

[mdb-dev] [patch] fix for handling decimal (numeric) values

[<js...@ii...>]

Hello

A patch to include in mdbtools.

- fixed importing decimal (numeric) values
   (by fixing setting fractional point's position and adding negative sign when
    needed)

Notes:
1. The "negative" bit is the one most significant from the first byte:

  ( *(mdb->pg_buf+start) & 0x80) )

2. I used int negtive variable to speed up the calculations.

3. There was also a bug in using memmove()

4. The patch is already tested and included within Kexi MDB Import driver, 
which utilizes mdbtools.

-- 
regards / pozdrawiam,
  Jaroslaw Staniek / OpenOffice Polska

Sponsored by OpenOffice Polska to work on
* Kexi & KOffice: http://www.kexi-project.org | http://koffice.org/kexi
* KDE3 & KDE4 Libraries For Developing MS Windows Applications:
                   http://www.kdelibs.com/wiki
See also:
* Kexi For MS Windows: http://kexi.pl/wiki/index.php/Kexi_for_MS_Windows
* Kexi Support:        http://www.kexi-project.org/support.html

Re: [mdb-dev] Exporting data for import into Postgres

[Jeff S. <why...@ya...>]

Paul,

If you are using mdbtools out of CVS from Sep '05 or later, there are already sufficient
options to accomplish what you want (except perhaps the \ escaping problem).  Note that
the '-q <char>' option is currently misdocumented as '-Q <char>'.  I intend to fix this
once sourceforge's CVS starts working again.

  mdb-export -I -S -q"'" -R";\n" sample.mdb Table1

 -- Jeff Smith


--- Paul Schulz <psc...@gm...> wrote:

> 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


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com