Re: [libreoffice-users] mySQL login from a form using direct connect

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: users+unsubscribe@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