That is an outstanding tip...
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Wednesday, January 20, 2010 8:14 PM
To: cf-talk
Subject: Re: 64bit CF Server and System DSNs - Solved
There actually IS a 64bit version of the MSDASQL provider. After installing
that and adding 'Provider=MSDASQL;' to all connection strings, everything
started working fine.
Bobby Hartsfiled wrote:
> 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:329877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
