Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
We
are in the process of setting up a 64bit, multiserver configuration ColdFusion
server. We have setup and tested multiserver configuration in the past but that
was on 32bit. This is our first attempt at 64bit.
- Windows 64bit Server 2003 R2
- CF 8 Enterprise 64 bit
Some
parts of our application still contain legacy ASP code and we use System DSNs
to allow that legacy code to talk to our databases. With 64bit, we are
receiving the following error anytime ASP attempts to talk to a system DSN.
ADODB.Connection error '800a0ea9'
Provider is not specified and there is no
designated default provider.
/openadmin/_scripts/conn.inc, line 11
I
found a couple of different reasons and alleged solutions to this but have
still had no luck solving it. The first, and most common, explanation that I've
found is that the MSDASQL.dll (provider for ODBC drivers) has no 64 bit version
and that SQLOLEDB should be used instead. To use SQLOLEDB, the suggestion was
to add the provider argument to your connection strings:
DSN=systemDSNName;UID=username;PWD=password;
Prodvider=SQLOLEDB;
When
I try that, I receive a different error:
Microsoft OLE DB Provider for SQL Server
error '80004005'
Invalid connection string attribute
/openadmin/_scripts/conn.inc, line 11
Another
solution was to use the connection string argument "Driver={SQL Server}"
instead of the provider. But when I try that, I get a completely different
error message:
Microsoft OLE DB Provider for SQL Server
error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
/openadmin/_scripts/conn.inc, line 11
Another
solution, yet again, was to use the 32bit version of the ODBC Manager to create
your system DSNs. I tried that as well with all of the same results. I also
tried setting IIS to run as a 32 bit application by setting
"Enable32BitAppOnWin64" to true but that resulted in a different error as well:
%1
is not a valid Win32 application.
I
also tried all of the same connection string changes from above while running
at 32bit but there was no change in this error messages.
As
you can see, I'm not having much luck. Has anyone else had this issue before
that might be able to offer some suggestions?
Thanks
for any help you can offer.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329751
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
