Results 1 to 2 of 2

Thread: Dynamic database connection with VB6

  1. Oct 26th, 2006, 10:26 AM #1
    giuan65
    giuan65 is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    6

    Dynamic database connection with VB6

    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.
    Reply With Quote Reply With Quote
  2. Oct 28th, 2006, 04:45 PM #2
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Dynamic database connection with VB6

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

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width