ODBC driver issue?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27642
Printed Date: 02 April 2026 at 2:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ODBC driver issue?
Posted By: HarryTheSerpent
Subject: ODBC driver issue?
Date 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
|
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- 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 |
Posted By: HarryTheSerpent
Date 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!
 H
|
Posted By: WebWiz-Bruce
Date 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. ------------- 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 |