Hi Greg, thanks for the response. The SQL server is an existing
(separate) server that we have used for years. It has no problems
talking to our other existing servers.
----------------------------------------
Return-Path: <listmas...@houseoffusion.com>
Received: from mail.houseoffusion.com [64.118.74.225] by mail.clickculture.com
with SMTP;
Mon, 18 Jan 2010 10:06:32 -0500
Precedence: bulk
Content-Type: text/plain
References: <019b456fcdf044f3b115fea1d5658...@mail.clickculture.com>
Date: Mon, 18 Jan 2010 10:06:21 -0500
Reply-To: cf-talk@houseoffusion.com
Subject: Re: 64bit CF Server and System DSNs
From: Greg Luce <luce...@gmail.com>
To: cf-talk <cf-talk@houseoffusion.com>
Message-ID: <7dbb50e31001180706v7721ba99q8f2d82357bbbb...@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit
X-invURIBL-Scan: Scanned by invURIBL 3.1.0 on 1/18/2010 10:06:50 AM
X-invURIBL-Weight: 0
X-invURIBL-Range: CLEAN
X-Rcpt-To: <bo...@acoderslife.com>
X-SmarterMail-Spam: SPF_None
Bobby,
I'm no sys admin, but I found on windows 7 64 bit that TCP/IP was disabled
by default in MSSQL. Not sure if that helps, but it tripped me up for awhile
and I've heard of others getting stuck on that.
--
Greg Luce
Luce Consulting Services, Inc.
www.luceconsulting.net
(863) 273-0289
On Mon, Jan 18, 2010 at 9:38 AM, 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:329753
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
