OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

BASE front - MyODBC - MySQL back

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Paulchen
Newbie
Newbie


Joined: 01 Aug 2007
Posts: 2

PostPosted: Wed Aug 08, 2007 4:47 am    Post subject: BASE front - MyODBC - MySQL back Reply with quote

Tried to set up a database in Windows with BASE as front and MySQL as back end via MyODBC driver. The data stored in MySQL can be edited in BASE but not changed or deleted.
It is not possible in BASE to change access rights in Tools/User Administration. The tables in MySQL all have Primary keys and the InnoDB engine is used.

Surprisingly it is possible to create a new table through BASE in MySQL, but after reopening it, the same problem occurs.


What is wrong with it? Is it a bug or can I do something to make it working? Rolling Eyes

It works fine with MSAccess. When linking the tables, Access asks additionally for the tables and fields in the tables.

Is it better to go with PostgreSQL since they offer a special (beta-)driver for BASE?

Tx in advance
Back to top
View user's profile Send private message
Paulchen
Newbie
Newbie


Joined: 01 Aug 2007
Posts: 2

PostPosted: Wed Aug 15, 2007 1:18 am    Post subject: Reply with quote

Will try this: Wink

http://blogs.ittoolbox.com/database/soup/archives/filemaker-replacement-found-18042?ref=http%3A%2F%2Fwww%2Eplanetpostgresql%2Eorg%2F
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Wed Aug 15, 2007 5:56 am    Post subject: Reply with quote

Paulchen,

Thanks for that link - I just got done reading over the mail list entries and the installation documentation. It looks interesting, I think I will have to give this a try also.
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group