none
ODBC Driver Error RRS feed

  • Question

  • i try to install Goldmine ver 9x today on new Win 7 Pro 32 bit PC

    When I select SQL as my connection type i get the errror 

    "the setup routines for SQL server ODBC driver could not be accessed. Please reinstall the driver"

     
    I have tried to re register the dll  by running " regsvr32 odbcconf.dll "
    I have also checked the registry and the values for SQL connection are corrent.

    Any idea?

    Saturday, September 18, 2010 12:18 PM

Answers

All replies

  • Hi,

     

    Thanks for posting in Microsoft TechNet forums.

     

    Could you please describe the network environment? Is it a stand-alone PC or workstation\domain?

     

    On the operation system side, please exit all programs running on your system and disconnect computer from network. This frees memory and alleviates potential conflicts between the installer and other software on your computer. This includes third-party utilities that integrate with GoldMine and other GoldMine add-on products. You should also exit the Microsoft Office Shortcut bar and stop all services that integrate with GoldMine or use BDE.

     

    This issue may involve SQL server, it is suggested to contact Goldmine support for more accurate information. Please select the appropriate section on the navigation barfor quick solutions to technical issues.

     

    Please Note: Since the website is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

     

    Best Regards

    Magon Liu

    TechNet Subscriber Support in forum. If you have any feedback on our support, please contact tngfb@microsoft.com

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    Tuesday, September 21, 2010 3:46 AM
    Moderator
  • Hi,

     

    Thanks for posting in Microsoft TechNet forums.

    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios. If the issue still persists, please feel free to  reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

    BTW,  we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems. Thanks for your understanding and efforts.

     

    Best Regards

    Magon Liu

    TechNet Subscriber Support in forum. If you have any feedback on our support, please contact tngfb@microsoft.com

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    Tuesday, September 28, 2010 2:35 AM
    Moderator
  • to resolve the case.

     

    -    Send user copy of sqlsrv32.dll file

    -    The registry entries a slightly different as those stated in the document.  (http://support.microsoft.com/default.aspx?scid=kb;en-us;260558)

    However I was able to match them up with those on a working windows 7 PC.  This seemed to do the trick

     

    cid:image001.png@01CB58B2.D1A5FB50

     

     

     Fixed

    Tuesday, September 28, 2010 10:04 AM
  • Hi,

     

    Thank you very much for sharing the resolution. I believe this will help other forum members resolve similar issues in the future. Your time and effort is greatly appreciated.

     

    Thank you again for choosing Microsoft!

     

    Best Regards,


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    Wednesday, September 29, 2010 8:41 AM
    Moderator
  • The link and picture no longer work.  But for me, the below registry values were missing for some reason.  I copied them off of another system, and not it works.

    The other solution that worked for other people (but not me) was:

    Re-register odbcconf.dll (running "regsvr32 odbcconf.dll" at c:\windows\system32)

    But if you paste the below into a file named sqlserver.reg, and then double click on it, it will import the settings into your registry.

    Windows Registry Editor Version 5.00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
    "APILevel"="2"
    "ConnectFunctions"="YYY"
    "CPTimeout"="60"
    "Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
      00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,53,00,51,00,4c,00,53,00,52,00,\
      56,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
    "DriverODBCVer"="03.50"
    "FileUsage"="0"
    "Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
      00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,73,00,71,00,6c,00,73,00,72,00,\
      76,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
    "SQLLevel"="1"
    "UsageCount"=dword:00000001

    Wednesday, June 5, 2019 1:33 PM