Forcing base to use the configured server, not trying localhost

Hi,

I got some calc file and I want to move it into a remote(!) mysql database. So I`ve setup&registered my database using native MySql connection (SDBC plugin 1.2.0). Testing the connection works fine.

As soon I try to get the calc data into the database, he tries to put it on a local sql server. error: “unknown database databasename@localcomputer”.

how can i force libreoffice to use the configured and registered server and not my local machine?

What method are you using to put the Calc data into DB - CSV, copy/paste into existing Table, etc.?

I tried copy&paste and drag+drop so far.

I just tried a copy/paste. Selected a number of rows in calc sheet, went to DB, selected table, pasted, wizard came up (append data pre-selected), selected Next, Columns/data OK, selected Create and table was updated with the data.

Also drag & drop worked creating a table - just had to change some field types. It even created a primary key.

And you can see and access the DB tables on the server? I am using mysql-connector-java-5.1.36 (sorry, just re-checked). Lo v5.2.3.3 on Mint 18

Hi,

ya, I see existing tables on the database server. But as soon I try to transfer data, he tries to insert it at my local computer.

  • You may want to reset you LO user profile (possible corruption) - see this page

  • Make sure you have no instances of MySQL running on your local machine. If you do, shut it down.

  • Be sure Edit->Database->Properties contains the IP address of the MySQL server or its’ hostname on the network; also verify correct database name is being used.

  • Make sure you have proper privileges for the database; can you insert a record or create a table from your local machine using something like “MySQL Workbench”?

Other than an incorrect setting, not sure how else it may be trying to access the local host.

Also, not sure about the connector you are using. Only finding this referenced under Apache OpenOffice. You may want to try a different connector.

Ran a couple of quick tests. Used the SBDC 1.2.0 extension without problems. Also tried the older Oracle 1.0.1 connector without problems. Got to be something else at your end.

Well I tried everything you suggested. Should I just uninstall and reinstall everything?
It`s not really urgend, since the ods file got only 1600 of 5000 lines so far, but I keep on trying -_-

What version of LO & what OS are you running? Hate to ask, but what is your step by step in trying data transfer - similar to what I stated in earlier comment. To existing or new table?

Version: 5.2.3.2
Build-ID: c019706a50de7fcb07d0d528b09b46a887562beb
CPU-Threads: 8; BS-Version: Windows 6.1; UI-Render: GL;
Gebietsschema: de-DE (de_DE); Calc: group

So win 7 pro 64bit.

Does not matter if existing or new table.

Well, the only difference with the information at hand is you’re using Windows. In that regard, make sure it’s not a firewall or anti-virus program blocking you. Otherwise, for now I’m out of ideas. Will post if something else occurs to me. If you do happen to re-load LO, make sure you clear out any remnants left in the registry after deleting and before re-loading.

I’ve used Oracle MySQL J Connector before, and it worked just fine, and I recall using Oracle MySQL ODBC Connector too. I’m looking at MariaDB J Connector 1.5.5, it says it’s based on Oracle MySQL J Connector 5.1.18 and Oracle MySQL ODBC 5.1.9, available from MariaDB Connector/J - MariaDB. Then there’s MariaDB ODBC 2.0.13 with binaries for Window$ and Linux at MariaDB Connector/ODBC 2.0.13 Stable - MariaDB.