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.
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:
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".