| View previous topic :: View next topic |
| Author |
Message |
frrobert General User

Joined: 19 Aug 2006 Posts: 5
|
Posted: Thu Apr 19, 2007 10:09 am Post subject: mysql odbc read only |
|
|
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 |
|
 |
Ewald OOo Advocate


Joined: 16 Dec 2005 Posts: 392
|
|
| Back to top |
|
 |
frrobert General User

Joined: 19 Aug 2006 Posts: 5
|
Posted: Thu Apr 19, 2007 4:29 pm Post subject: |
|
|
| Thanks for the reply, but none of the solutions worked. |
|
| Back to top |
|
 |
jrkrideau Super User

Joined: 08 Aug 2005 Posts: 6733 Location: Kingston ON Canada
|
Posted: Thu Apr 19, 2007 4:41 pm Post subject: Re: mysql odbc read only |
|
|
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 |
|
 |
|