Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-23 Thread Paul D. Mirowsky
Alexander Thurgood; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Base - need to re-point a form Really? Mine doesn't On 19 October 2012 15:55, jomali wrote: What are you talking about? Of course there is a command line interface to MySQL in Windows. I use it all the time.

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-20 Thread Dan Lewis
] Sent: Fri 10/19/2012 10:04 AM To: jomali Cc: Alexander Thurgood; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Base - need to re-point a form Really? Mine doesn't On 19 October 2012 15:55, jomali wrote: What are you talking about? Of course there is a command

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-20 Thread John Clegg
net] > Sent: Fri 10/19/2012 10:04 AM > To: jomali > Cc: Alexander Thurgood; users@global.libreoffice.org > Subject: Re: [libreoffice-users] Re: Base - need to re-point a form > > > > Really? Mine doesn't > > On 19 October 2012 15:55, jomali wrote: > > > Wh

RE: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread V Stuart Foote
AM To: jomali Cc: Alexander Thurgood; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Base - need to re-point a form Really? Mine doesn't On 19 October 2012 15:55, jomali wrote: > What are you talking about? Of course there is a command line interface to > MySQL in

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread John Clegg
Really? Mine doesn't On 19 October 2012 15:55, jomali wrote: > What are you talking about? Of course there is a command line interface to > MySQL in Windows. I use it all the time. Just go to Run and type mysql in > the Open: box. You'll get a Command prompt with mysql command line ready to > go

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread jomali
What are you talking about? Of course there is a command line interface to MySQL in Windows. I use it all the time. Just go to Run and type mysql in the Open: box. You'll get a Command prompt with mysql command line ready to go. John On Fri, Oct 19, 2012 at 9:23 AM, John Clegg wrote: > Hm I

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread Alexander Thurgood
Hi John, Le 19/10/12 15:23, John Clegg a écrit : > Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working > here first!). Connecting to a database on xeround.com > (actually hosted on Amazon EC2 servers, using > port 18993. JDBC driver class com.mysql.jdbc.Dri

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread John Clegg
Hm It isn't quite that simple in Windows (no command line mysql client) but I tried HeidiSQL and I can connect and amend data with no problems On 19 October 2012 13:44, Alexander Thurgood wrote: > Hi John, > > > Le 19/10/12 14:25, John Clegg a écrit : > > OK, thanks for that. > > Using LO 3

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread Alexander Thurgood
Hi John, Le 19/10/12 14:25, John Clegg a écrit : > OK, thanks for that. > > Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working > here first!). Connecting to a database on xeround.com > (actually hosted on Amazon EC2 servers, using > port 18993. JDBC driver c

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread John Clegg
OK, thanks for that. Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here first!). Connecting to a database on xeround.com (actually hosted on Amazon EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar John On 19 O

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread Alexander Thurgood
Hi John, Le 19/10/12 11:09, John Clegg a écrit : > The problem with the ODBC version is that Base can't download the > table structure from the server for some reason. The JDBC version can > but can't r/w. Which all suggests to me some dodgy MySQL connectors > There are some known issues with O

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-19 Thread John Clegg
No, the ODB is on a local NTFS volume The problem with the ODBC version is that Base can't download the table structure from the server for some reason. The JDBC version can but can't r/w. Which all suggests to me some dodgy MySQL connectors To check that I set up another MySQL server elsewhere a

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread John Clegg
Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather than JDBC. The table now becomes editable, but when I make a change I can't save because I get a message that nothing has changed! Am I jinxed?? On 18 October 2012 14:28, John Clegg wrote: > The structure is very simple

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread John Clegg
The structure is very simple - one integer field, indexed unique and 33 fields text(varchar) of varying lengths all unindexed. On 18 October 2012 14:22, Alexander Thurgood wrote: > Le 18/10/12 15:10, John Clegg a écrit : > > > > It's a single field, integer and unique. And having been out and in

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread John Clegg
No, same user! On 18 October 2012 14:18, Alexander Thurgood wrote: > > Le 18/10/12 15:10, John Clegg a écrit : > > It's a single field, integer and unique. And having been out and in > > again base can see the index now, but I still can't edit. > > Dumb question perhaps, but : user privileges ? A

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread Alexander Thurgood
Le 18/10/12 15:10, John Clegg a écrit : > It's a single field, integer and unique. And having been out and in > again base can see the index now, but I still can't edit. Dumb question perhaps, but : user privileges ? Any difference between Base user and phpmyadmin user ? Alex -- For unsubscri

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread John Clegg
It's a single field, integer and unique. And having been out and in again base can see the index now, but I still can't edit. On 18 October 2012 13:47, Alexander Thurgood wrote: > Le 18/10/12 11:46, John Clegg a écrit : > > Hi John, > > > > > I can access the data via phpMyAdmin and make changes.

Re: [libreoffice-users] Re: Base - need to re-point a form

2012-10-18 Thread John Clegg
That's pretty comprehensive, thanks! I will work through those. Regards john On 18 October 2012 08:22, Alex Thurgood wrote: > On 10/18/2012 08:02 AM, John Clegg wrote: > > Hi John, > > > > I am accessing the remote MySQL database using com.mysql.jdbc.Driver. > > When I access the data by openi