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 jomali3...@gmail.com wrote:
What are you talking about? Of course there is a command line
interface
to
MySQL in Windows
/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 jomali3...@gmail.com wrote:
What are you talking about? Of course there is a command
[mailto:john.cl...@nailsea.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 jomali3...@gmail.com wrote:
What are you talking about
On 10/18/2012 03:49 PM, John Clegg wrote:
Hi John,
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!
Shot in the dark - the ODB file
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
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 ODBC
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
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
http://xeround.com (actually hosted on Amazon EC2 servers, using
port 18993. JDBC driver class
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 alex.thurg...@gmail.comwrote:
Hi John,
Le 19/10/12 14:25, John Clegg a écrit :
OK, thanks for
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
http://xeround.com (actually hosted on Amazon EC2 servers, using
port 18993. JDBC driver class com.mysql.jdbc.Driver
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
Really? Mine doesn't
On 19 October 2012 15:55, jomali jomali3...@gmail.com 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
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 jomali3...@gmail.com wrote:
What are you talking about? Of course there is a command line interface
OK, a supplementary if I may!
I am accessing the remote MySQL database using com.mysql.jdbc.Driver.
When I access the data by opening the table or using the form it is
read-only. Any ideas again?
John
On 17 October 2012 20:25, John Clegg john.cl...@nailsea.net wrote:
I have a base file
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 opening the table or using the form it is
read-only. Any ideas again?
Several possible reasons :
- no primary key field defined in your
That's pretty comprehensive, thanks! I will work through those.
Regards
john
On 18 October 2012 08:22, Alex Thurgood alex.thurg...@gmail.com 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
Le 18/10/12 11:46, John Clegg a écrit :
Hi John,
I can access the data via phpMyAdmin and make changes. I have added a
primary key this way, but I'm not sure that Base is seeing that - there is
no sign of it if I edit the table structure in Base.
How is your primary key defined ? - single
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 alex.thurg...@gmail.comwrote:
Le 18/10/12 11:46, John Clegg a écrit :
Hi John,
I can access the data via phpMyAdmin
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
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.
Can you post the table structure ?
Alex
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
No, same user!
On 18 October 2012 14:18, Alexander Thurgood alex.thurg...@gmail.comwrote:
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 :
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 alex.thurg...@gmail.comwrote:
Le 18/10/12 15:10, John Clegg a écrit :
It's a single field, integer and unique. And
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 john.cl...@nailsea.net wrote:
The
23 matches
Mail list logo