Hey,
I do have al lot of problems trying to connect to a MySQL Database via
Sun native driver.
Funny: When I install the driver last week, everything works well, I got
the connection-object and could work with it.
This week - I only get errors.
Even, when I try to connect via UI- just errors.
Today at first I got errors, then could connect via UI by changeing the
IP - so, not use 127.0.0.1 but the static IP-Adress of the PC:
Neverthless - using my code (see below) I always get the following error:
Type:com.sun.star.sdbc.SQLException
Message: Can`t connect to MySQL server on '127.0.0.1' (10013)
Even when I changed the IP on complete different IP-Numbers (existing
and non existing) - the Error-Message is still the same )(with IP
127.0.0.1 - localhost)
My MySQL-Server is working fine, I can connect via MySQL Administrator
and even it works today using the JDBC Driver instead of the nativ driver.
The following code works fine last week - not any more today. Any
suggestions?
function TIMM_getConnection()
dim oCon as variant 'Connection-Objekt
dim oDM as variant 'TreiberManager
dim dbprop(1) as new com.sun.star.beans.PropertyValue
dbprop(0).name = "user"
dbprop(0).value = "SWB"
dbprop(1).name = "password"
dbprop(1).value = "swb"
oDM = createUnoService("com.sun.star.sdbc.DriverManager")
oCon =
oDM.getConnectionWithInfo("sdbc:mysql:mysqlc://127.0.0.1:3306/timm",
dbprop())
oCon.setCatalog("timm")
TIMM_getConnection = oCon
End function
Best regards
Thomas
--
## Marketing deutschsprachiges Projekt
## http://de.openoffice.org - www.openoffice.org
## Vorstand OpenOffice.org Deutschland e.V.
## Mitglieder willkommen: www.OOoDeV.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org
