| View previous topic :: View next topic |
| Author |
Message |
jose3
Power User
Joined: 13 Apr 2004
Posts: 53
Location: Buenos Aires - Argentina
|
 Posted: Wed Jan 19, 2005 10:00 am Post subject: Close Oracle connection |
 |
|
Hi guys:
I am having some trouble here cause I got to connecto to an Oracle with ODBC but since I am having trouble with some bookmark stuff that causes an error (wich I am gonna soon ask for help at the macros forum) the connection in the server with the read only user keeps connected.
I have realized this after saturated the database with open (read only) connection user so as you can see its a problem..
Is there a way to close this connection before I get any error??
Thanks very much in advance guys. |
|
| Back to top |
|
 |
jose3
Power User
Joined: 13 Apr 2004
Posts: 53
Location: Buenos Aires - Argentina
|
| Posted: Fri Jan 21, 2005 12:37 pm Post subject: |
|
|
Here is the code I am using to connect thorught ODBC.
| Code: |
ContextoBaseDatos = createUnoService("com.sun.star.sdb.DatabaseContext")
FuenteDatos = ContextoBaseDatos.getByName("SAES")
If Not FuenteDatos.IsPasswordRequired Then
Conexion = FuenteDatos.GetConnection("lector","lector")
Else
DIM User AS STRING
Dim Password AS STRING
ManejadorInteraccion = createUnoService("com.sun.star.sdb.InteractionHandler")
Conexion = FuenteDatos.ConnectWithCompletion(ManejadorInteraccion)
End If
|
I need somehow to close thsi connection..
Thanks. |
|
| Back to top |
|
|
|
