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
--
View this message in context:
http://nabble.documentfoundation.org/mySQL-login-from-a-form-using-direct-connect-tp4134305.html
Sent from the Users mailing list archive at Nabble.com.
--
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