Web+Center Support
22 Oct

Knowledge Base Detail

Case Summary: When attempting to configure Web+Center with 64 bit 2003 server and 64 bit SQL 2005, one will get the error:
ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider.
ID: 2243
Date Created: 11/14/2007
Last Modified: 11/15/2007
Problem Type: Problem Report
Item: Web+Center 5.0
Resolution:
There is new database connection syntax required when using this configuration. We have found a way to connect to the database directly without an DSN using the string:

Application("myDSN") = "Provider=SQLOLEDB;User ID=wc50;Password=wc50pass;Initial Catalog=webcenter50;Data Source=192.168.0.21;Network Library=DBMSSOCN;"

You must change the Data source to be your own IP address or hostname. This line source be inserted in each Global.asa file around line 44 in each of the application directories (techcenter, customercenter, pocketcenter and businesscenter). This file will overwrite the application variable for "myDSN".

Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com