On 29-12-2014 00:20, craig48 wrote:
I am running LibreOffice 4.3.4.1 on Fedora 21. I'm trying to run a LibreOffice basic macro from a form using the mysql direct connect. I am able to open tables in the database without any problem.When I open the form, the database password is requested and I enter it, and the form's grid is loaded with the data. I'm having trouble connecting from the form using a basic macro. The connection requires a password. Running the following code produces an error at the getConnection statement: sURL = "sdbc:mysql:mysqlc:sys76.localdomain:3306/folding" oManager = CreateUnoService("com.sun.star.sdbc.DriverManager") oCon = oManager.getConnection(sURL) The resulting error is: BASIC runtime error. An exception occurred Type: com.sun.star.sdbc.SQLException Message: Access denied for user 'craig'@'mac.localdomain' (using password: NO). What do I need to change to successfully connect with the macro? Craig
From this page, shich is a codesample in java, it seems that you have to specify properties:
http://api.libreoffice.org/examples/DevelopersGuide/Database/CodeSamples.java This pages shows some examples of how to do specify properties: https://www.libreoffice.org/bugzilla/attachment.cgi?id=65645 Or, in other words, the *ConnectionProperties* are missing http://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/module-ix.html (disclamer: i do not make macro's in LO, too complicated ;) -- To unsubscribe e-mail to: [email protected] 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
