Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error appears when choosing ODBC Datasources (2003 SP1)

    On a certain user's PC (I'll call her Linda), when she wants to link a table from an ODBC data source she gets this error.

    ODBC Call failed. [Microsoft][ODBC Driver Manager] Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled (#0).

    The ODBC Manager window never opens and lets her choose a data source.

    I've searched Technet and the couple of KB articles I found did not apply. There is a lot more to the story, but I thought I'd start with the error message and it might trigger some thoughts/ideas.

    Sarah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error appears when choosing ODBC Datasources (2003 SP1)

    You might try (re)installing MDAC on Linda's PC. You can download the most recent version from Download details: MDAC 2.8.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error appears when choosing ODBC Datasources (2003 SP1)

    Hans has pointed you in the right direction - this <!mskb=169470>Microsoft Knowledge Base Article 169470<!/mskb> may help you sort out the issues if upgrading the MDAC doesn't help.
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error appears when choosing ODBC Datasources (2003 SP1)

    This may not be an option because our company standard is 2.7 something, but I'll download the new version on a test box and have LInda try this.

    Sarah

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error appears when choosing ODBC Datasources (2003 SP1)


Posting Permissions

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