Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - ODBC driver issue?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ODBC driver issue?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
HarryTheSerpent View Drop Down
Newbie
Newbie


Joined: 29 July 2009
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote HarryTheSerpent Quote  Post ReplyReply Direct Link To This Post Topic: ODBC driver issue?
    Posted: 29 July 2009 at 10:31pm
Hi,
 
I'm testing Web Wiz 'locally' on a PC before going live on the server. Using SQL2005 Express and getting error:
 
"Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
 
I'm sure this would have been asked before but I can only see references to similar MySQL errors
 
Thanks
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2009 at 7:59am
The error means that the driver to connect to the database can not be found.

What OS are you using and is it an x64 version?

If it is an x64 OS make sure that the application pool is running in 32bit mode.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
HarryTheSerpent View Drop Down
Newbie
Newbie


Joined: 29 July 2009
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote HarryTheSerpent Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2009 at 12:13pm
Thanks for the reply.
 
I have it working now. I edited database_settings.asp and put in the connection detailsmanually. Not sure if this was the recommended mothod but it works!
 
I'm having to connect using SQL authentication and the password indatabase_settings.asp is plain text. Can this be encrypted?
 
Looking good at the minute though!Smile
 
H
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 July 2009 at 1:06pm
It can not be encrypted.

I would recommend that you use TCP/IP to connect to the database and create a user on the SQL Server that it limited to just the forums database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

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

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 at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

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