Hi OpenOffice Community!
Please help, I have an *.odb file, with an ODBC connection to SQL Server.
I can create my own queries, and they run as they supposed to be, but if I want to use built-in functions, every single command gives me an error!
I have opened the error message, and it always contains something like the following:
->The SQL command leading to this error is
->SELECT * FROM "dbo.table_name"
I get this error, because the quotation marks' syntax are not correct.
It should be correctly without quotation marks, like: SELECT * FROM dbo.table_name.
Or, with the following quotation mark syntax, like: SELECT * FROM "dbo"."table_name".
Please help me to solve this issue.
Has anyone run into this?
Probably a built-in macro modification would solve it.
Best regards,
Peter
*.odb with ODBC connection - The data content could not be loaded
*.odb with ODBC connection - The data content could not be loaded
OpenOffice 3.1 on Windows 10
Re: *.odb with ODBC connection - The data content could not be loaded
Open the query for editing and choose the menu Edit -> Run SQL Command Directly then run the query. Does it work?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: *.odb with ODBC connection - The data content could not be loaded
I don't see any function call inI can create my own queries, and they run as they supposed to be, but if I want to use built-in functions, every single command gives me an error!
Simply create a simple query in design view or using the wizard in order to learn the correct Base syntax.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: *.odb with ODBC connection - The data content could not be loaded
Yes, it works fine. Anyway I have changed ODBC connection types, and the select command works. Altough I still can not input any text into text field. When I create a Form with the wizard, It displays the data from a Query, but it does not display the data from a table. I get the following error, when I want to choose a db table:
"The field names from 'dbo.table1' could not be retreived".
Could you please help to figure out this issue?
OpenOffice 3.1 on Windows 10