Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - 80004005 error on new test server (local)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

80004005 error on new test server (local)

 Post Reply Post Reply
Author
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Topic: 80004005 error on new test server (local)
    Posted: 21 October 2013 at 3:32pm
Hi guys
 
I've been using XP for a while and decided to upgrade to Windows 7.  I use the PC to test my website which includes a WebWiz forum and ASP-driven site.  The development server has IIS 7.5 installed but I can't seem to get it working as I get a database error for the forum and also my site.  I know the connection string is correct (works fine on the live server) so not sure why the scripts aren't connecting to the remote MySQL database.
 
I've downloaded the mySQL ODBC drivers and installed them on the machine, so not sure why this error is appearing.
 
The error message on both the forum and server logs are the same:
 
Database Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 
Server Error:-
80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified
 
Any ideas on what else could be causing this (eg. firewall, permissions?)
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9730
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2013 at 9:41am
In order for Classic ASP to work correctly it needs to be able to access 32bit drivers and components.

In order to do this edit the application pool for the website in IIS and set 'Enable 32-Bit Applications' to True.
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2013 at 1:08pm
Thanks for the reply Bruce but I'm only running a 32bit version of Windows 7 Pro, so don't see this option.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9730
Post Options Post Options   Thanks (1) Thanks(1)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2013 at 1:10pm
You have installed the mySQL ODBC Driver?
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2013 at 1:15pm
Silly me ... I've just realised the problem - so sorry for the wild goose chase. 
 
I installed the ODBC v5.2 driver but my script was referring to v3.51.  All good now.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2022 Web Wiz Ltd. All rights reserved.