Web Wiz Hosting Support Forums

Print Page | Close Window

ODBC error

Printed From: Web Wiz Forums
Category: Web Wiz Hosting Services Forums
Forum Name: Web Wiz Hosting Support Forums
Forum Description: Support forum for Web Wiz Hosting services and solutions.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28604
Printed Date: 28 March 2026 at 3:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ODBC error

Posted By: ajwposh
Subject: ODBC error
Date 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

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting