[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I’m getting an error message that says :

A problem was encountered while trying to log into or create the production database. Details: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

In my ODBC manager, I have a list of User DSN’s and System DSN’s. I tried installing a postgres odbc driver to see if that would help, but it didn’t.

There is a connect.dat file in the program file with a line saying “OLE DB Provider = MSDASQL”. Changing this entry alters the error message I get to “Provider cannot be found, it may not be properly installed”.

I don’t know what provider name to insert to get this to work properly. I have done extensive research on this error to no avail. Any suggestions would be greatly appreciated.

Related Posts:

  1. How to completely remove Python from a Windows machine?
  2. Conda version pip install -r requirements.txt –target ./lib
  3. How can I create an MSI setup?
  4. extconf failed, exit code 1 error when installing [Ruby on Rails] 5 on OS X Yosemite 10.10.5
  5. Initialization Script for “Standard” Aspects of a WordPress Website?
  6. Populate content on install
  7. Automatically enable custom theme, plugins and default content on installation?
  8. Are there any downsides to installing WordPress on Windows versus Linux?
  9. Create a custom WP install with plugins, theme etc already installed?
  10. Install and configure WordPress while old site is still active
  11. How to Check the Directory Where WordPress is Installed?
  12. After moving wordpress some files still point to old directory
  13. URL to download latest version of WP for other languages than English
  14. Custom WordPress Installation
  15. Shortest possible shell script to install WordPress on Nginx server?
  16. Repeatable configuration package
  17. One WordPress install serving multiple virtual hosts
  18. Is it possible to install WordPress within WordPress installation?
  19. WordPress package configuration in Ubuntu Server?
  20. Can WordPress be installed at the root level, if a homepage called index.php already exists?
  21. Install wordpress in backend with Existing html website alive
  22. Moving to a new domain in the same server
  23. When WordPress Does Not Provide an .htaccess File for New Multisite Sites because of CPanel Fantastico Auto-Installer?
  24. InfiniteWP installation fails – CONFIGURABLE MAX EXECUTION TIME DISABLED
  25. Multiple sites/domains on one database
  26. Unable to install wordpress theme without ftp user & password
  27. Sharing one WordPress installation between several “sites”?
  28. Backup blog posts only
  29. Reinstall WordPress from zero
  30. Importing wordpress. xml file on new installation
  31. Novice WordPress Installation issues
  32. Can my site use two different WordPress installs for different pages?
  33. Can I clone WP to another directory on the same server?
  34. How to download WordPress 4.2.0
  35. Should I delete automatically-created files before installing WordPress?
  36. How to work locally on a copy of my wordpress?
  37. When I try to install VersionPress, it tells me, “The package could not be installed. No valid plugins were found.”
  38. Reset generated wp-config.php with wp-cli
  39. Missing wp-load.php on new install
  40. Automate specific steps on WordPress install
  41. Use new domain name on previously installed files of wordpress
  42. No option to update WP in client’s backend
  43. Installing wordpress on Parallels plesk 9.5.3
  44. Multi site clarification
  45. How can I completely disable a WordPress installation?
  46. WordPress database error on (fresh) reinstall
  47. wp-cli fails on installing to subdomain
  48. How to edit an existing wordpress.org site
  49. Installing WordPress in a subdirectory
  50. Installed WordPress Location
  51. how to return the wordpress path to the new site
  52. Version 3.04 or 3.5?
  53. WordPress installation from live site to localhost
  54. Moving WordPress Site from MAMP to cPanel – How?
  55. Basic installation questions
  56. Moving WordPress from Root to a subfolder
  57. How to effectively handle the problem of installing WordPress locally for each new project?
  58. WSOD right after install
  59. WordPress System Requirement for Older Versions?
  60. How to install WP alongside my existing site at a sub-directory (bradydjohnson.com/blog)?
  61. Forbidden localhost error and error establishing database
  62. What are the pros & cons of a new wordpress installation vs fixing one that already exists?
  63. I moved my WordPress site to the main directory and now I can’t access my admin
  64. EC2 WordPress install asks for connection info when auto-updating
  65. WordPress Skeleton installation
  66. Things to take care before installing wordpress Manual v/s Softaculous
  67. Moving from subdirectory and subdomain -> root
  68. Creating a sub folder inside a root installation?
  69. Why is WordPress’ installer “phoning home” during the install script?
  70. Powering only a subfolder with WordPress on a LAMP stack with an nginx reverse proxy
  71. Site blocked by WebSense on fresh WP Install
  72. WordPress 3.1 Install Error
  73. Disable creation of default content during installation
  74. How to recreate a WordPress site
  75. Fresh installation of WordPress on CentOS produces critical error during installation
  76. Install wordpress without affecting clickfunnels
  77. More than 5 time my Website show this issue
  78. Installation failed: Destination folder already exists
  79. Installing WordPress to root directory with existing static site. Concerns?
  80. How to install WordPress on root domain and Php script on subdomain?
  81. First time installing WordPress. Cant Access
  82. 2 domains 1 WP instalation in Cpanel
  83. What is the “Quick and Dirty” way to transfer WordPress installation?
  84. Upload a website on WAMP and modify it
  85. How to update WP-CLI on Windows via Composer?
  86. db.php, is it a legit file [closed]
  87. CPU spikes to 100% site doesn’t load, VPS crashes after moving site
  88. Have non-wordpress page as root (and blog elsewhere)
  89. Moving site made easier
  90. New WP installation due to language issues
  91. WordPress Installation
  92. Doubts about how to migrate WordPress from local to online server using Search and Replace Tool script
  93. Moving from one WP site to a new WP site incrementally
  94. Is it ok to have one wordpress installation for server.com and www.server.com?
  95. Are two installations of WordPress on the same domain (no subdomains) ok?
  96. I can access to my wordpress page at work and via cellphone, but when I get home, I can’t access to the website
  97. Multiple independent wordpress installs – 1 dedicated server – individual dedicated domain for each install. What is the best way to achieve this?
  98. WordPress desktop app shows blank screen
  99. Correct folder & file permisson for WordPress
  100. Host Php script from codecanyon on wordpress

Leave a Comment