On 12/29/2014 03:13 AM, Luuk [via Document Foundation Mail Archive] wrote:
>
> 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).
>>
>
> 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 ;)
>
Thank you for the helpful links. I agree the macros in LibreOffice are
too complicated.
Craig
--
View this message in context:
http://nabble.documentfoundation.org/mySQL-login-from-a-form-using-direct-connect-tp4134305p4134386.html
Sent from the Users mailing list archive at Nabble.com.
--
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
