Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - ODBC error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ODBC error

 Post Reply Post Reply
Author
ajwposh View Drop Down
Newbie
Newbie


Joined: 20 May 2010
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote ajwposh Quote  Post ReplyReply Direct Link To This Post Topic: ODBC error
    Posted: 20 May 2010 at 9:47pm
I have just bought hosting and trying to connect my website to my sql server database.
 
I have set up the DSN as i believe i should and have a database user etc and when i load my page I get the following error:
 
"The specified DSN contains an architecture mismatch between the Driver and Application"
 
I am not sure on how to fix it and wondered whether this was a common problem when first setting up a database on webwiz and if so, how to fix it?
 
Thanks
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: 9556
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 21 May 2010 at 9:17am
You should fill out a support ticket from your Client Area account regarding this issue so our support staff can investigate the problem for you and see whats wrong.

However, instead of a DSN connection you should look at using a DSN-less connection to your database. This is where you specify the connection string within your script or application. This is a much faster way of connecting to a database as it requires less registry hits and less work for the server to do in opening the database connection.

If you look in your welcome email there are examples of DSN-less connection strings under the database section.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.01
Copyright ©2001-2018 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Community Forums Web Wiz Blogs Web Wiz News
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-2019 Web Wiz Ltd. All rights reserved.