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

mysql odbc read only

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


Joined: 19 Aug 2006
Posts: 5

PostPosted: Thu Apr 19, 2007 10:09 am    Post subject: mysql odbc read only Reply with quote

Yes,

I am running Ubuntu 6.06

I have tried the following with two different methods and same issue

I am working on an intranet application where there is an web interface and a report engine using openoffice.org

I tried this using xampp and the lamp install uder ubuntu neither way allows a read write odbc connection when connecting to base

Eveything installs fine, I can create databases with myphpadmin and write to them.


The problem is the odbc connection to mysql is read only even if the user is root.

I am assuming there is a setting that only is allowing writes through the web and not any other connection

Does any one know what I need to set to allow read / write through odbc?

Thanks,

Fr. Robert
Back to top
View user's profile Send private message
Ewald
OOo Advocate
OOo Advocate


Joined: 16 Dec 2005
Posts: 392

PostPosted: Thu Apr 19, 2007 11:34 am    Post subject: Reply with quote

Maybe you find a solution to your problem in this post:
http://www.oooforum.org/forum/viewtopic.phtml?t=10374
Back to top
View user's profile Send private message
frrobert
General User
General User


Joined: 19 Aug 2006
Posts: 5

PostPosted: Thu Apr 19, 2007 4:29 pm    Post subject: Reply with quote

Thanks for the reply, but none of the solutions worked.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada

PostPosted: Thu Apr 19, 2007 4:41 pm    Post subject: Re: mysql odbc read only Reply with quote

frrobert wrote:
Yes,



Yes what? Were you responding to an earler post?

Quote:


I am running Ubuntu 6.06

I have tried the following with two different methods and same issue

I am working on an intranet application where there is an web interface and a report engine using openoffice.org

I tried this using xampp and the lamp install uder ubuntu neither way allows a read write odbc connection when connecting to base

Eveything installs fine, I can create databases with myphpadmin and write to them.


The problem is the odbc connection to mysql is read only even if the user is root.

I am assuming there is a setting that only is allowing writes through the web and not any other connection

Does any one know what I need to set to allow read / write through odbc?

Thanks,

Fr. Robert

_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
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