Results 1 to 2 of 2

Thread: MYODBC Quirk

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Unanswered: MYODBC Quirk

    Ok,

    I'm not sure if this is quite the place, but I wanted to see if anyone has experienced similar problems with myODBC using ADODB connections with VB.

    When I give the connection string as simply a DSN name everything works fine, but when I use the IP address, user,pass, etc as options instead so I can change the IP address if needed and redistribute the software easily certain things hang in Excel VBA and I have to end the task.

    Has anyone else experienced this?

    R

  2. #2
    Join Date
    Jul 2004
    Posts
    2

    Answer

    Ok,

    So, I figured out what might be the answer in case this ever gets archived and might save hundreds of people hours of hassle with DSN's

    After you close the Connection Object, set it to Nothing:

    Set Cnxn = Nothing

    Works like a charm, sorry for the bother. Archive this.

    R

Posting Permissions

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