Forcing base to use the configured server, not trying localhost [closed]
Hi,
I got some calc file and I want to move it into a remote(!) mysql database. So I`ve setup®istered 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, selectedCreate
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.