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

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 October 2012 13:16, Alexander Thurgood <alex.thurgood@gmail.com>wrote:

> 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 connectors, some of which cause
> crashes, or data access problems, depending on which version of LO you
> are using and which version of the MySQL ODBC Connector. Remember, LO is
> 32bit, even on Windows 64bit OS, so it requires a 32bit ODBC connector.
>
> This is also a major problem on OSX, where :
> - current versions of the OS are 64bit only as are the included mysql
> servers ;
> - LO is only 32bit ;
> - OSX can't manage a 32bit and 64bit mysql connector at the same time
> (or at least if it can, I've found no way to get it to behave properly),
> so users are stuffed when it comes to MyODBC on Mac OSX unless they are
> using a 32bit OS, i.e. Leopard or older..., or Snow Leopard in 32bit
> kernel mode...
>
> On Linux, the ODBC connector and LO are available in 32 and 64 bit
> incarnations, so it is possible to get something up and running.
>
> All versions of LO have had problems accessing remote database instances
> via ODBC, especially if your db server is on the internet.
>
>
>
> > To check that I set up another MySQL server elsewhere and had exactly
> > the same problem with the JDBC connector.
> >
> > I suppose I could set up a local MySQL server but I don't want it
> > local! And I suspect I might hit the same problem anyway.....
>
> No, I suspect that your problem is precisely because your mysql server
> is not local, or at least, not on the local lan (if I have understood
> your implied setup correctly).
>
> I don't have any problem accessing a LAN hosted mysql server instance
> over the mysql JDBC connector. Trying that over the internet is a whole
> other ballgame though. You need to have remote user access to your mysql
> server instance other than through port 80, which is not always (rarely,
> other than by SSH) provided for by hosting services. On top of that, DNS
> resolution issues can cause timeouts.
>
> It might be helpful if you gave us the exact setup you are trying to put
> into place, with version numbers for the different components.
>
>
> Alex
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted