Dynamic database connection with VB6

[giuan65]

Hi,
My VB6 application uses a CrystalReport Object which is dinamically connected to the Oracle database.

I connect the Crystal Report Object whith the next instruction:

MDIPaghe.CROracle.LogOnServer("pdsora7.dll", DSN, "", userOracle, pwdOracle)

Later I want to disconnect the crystal report object from the fiserver and I want to connect it to another server. My code:

MDIPaghe.CROracle.Reset
MDIPaghe.CROracle.LogOffServer
MDIPaghe.CROracle.LogOnServer("pdsora7.dll", newDSN, "", newUserOracle, newPwdOracle)

doesn't work: the Crystal Report object remains connect to the first server.


Could you suggest how can i do ?

Thank you .

Best regards.

[Mark Gambo]

I think this is more of a VB6 question rather that a CR. Anyway are you closing the ADO Recordset and Connection Objects?