Does CFMX 7 support SQL SERVER 2005?
6 Message(s) by 3 Author(s) originally posted in server admin
| From: ROQUE5072 |
Date: Thursday, August 30, 2007
|
| From: JohnEric |
Date: Thursday, August 30, 2007
|
Short answer yes.
We are using the
Microsoft JDBC v1.1 driver but, the updated DataDirect driver should
work as well.
Since the only error you say you are getting is with
execution of a stored
procedure on a linked server, does that mean that you can
execute a simple
select statement against the linked server?
Something like SELECT * FROM [linkedServer].[db].[schema].[table] ?
It may just be that you are running into the double
hop problem with Kerebos
authentication if the connection to the linked server is through the
current
login context.
| From: ROQUE5072 |
Date: Friday, August 31, 2007
|
Thanks for helping. I appreciate the reply.
Yes, we also have problems with simple select statement against the linked
server.
We are definitely having a Kerberos authentication related problem. It only
happens when using the SQL Server driver supplied with MX 7 and
ColdFusion 8. If we
configure a datasource using the
ODBC Socket driver, the problem goes away.
However, we'd like to keep using the SQL Server driver (JDBC).
Is Adobe providing an updated driver to
support SQL Server 2005 / Kerberos
Authentication? Is this
download available anywhere?
Thanks again for your help.
| From: Wilgeno |
Date: Thursday, September 06, 2007
|
Make sure your SQL server has
TCP/IP enable in the SQL Server Manager. This has been talked about on other sites like carehart.org.
Cheers,
| From: JohnEric |
Date: Thursday, October 04, 2007
|
| From: ROQUE5072 |
Date: Friday, October 05, 2007
|
First, many thanks to everyone who replied.
I
posting this
message in case anyone else runs into integrated security,
trusted connection or windows authentication / Kerberos double-hop problems
between SQL Server 2005 and Cold Fusion using the CFMX 7 supplied DataDirect
JDBC drivers.
We found a
solution that worked. Basically, we downloaded the Microsoft SQL Server
2005 JDBC drivers as described in this technote:
http://kb.adobe.com/selfservice/viewContent.do?externalId=ded4216b
However, make sure to download the latest
version of the driver, which is 1.1
(
http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-978
7-A866235EFC7C&displaylang=en)
The technote left out some very important information that made it work for
us. Basically, the JDBC
URL must contain the 'integratedSecurity=true'
parameter and that the sqljdbc.jar and sqljdbc_auth.dll must be copied to a
folder that is part of your windows
system path (ie. c:\windows\system32).
Here's the
complete JDBC URL syntax:
jdbc:sqlserver://[server]:1433;databaseName=[database];integratedSecurity=true;S
electMethod=direct;sendStringParametersAsUnicode=false; MaxPooledStatements=0;
Thanks again and good luck to all..
Next Message: Will ColdFusion 8 work w/ Apache 1.3.36 or 1.3.37 (Unix/Linux)?
Blogs related to Does CFMX 7 support SQL SERVER 2005?
Magazine publishing independent motor news and reviews.
sql server dataabase samples mushroom basil pasta wedding guest 4x. pro.msi cofidence visa sand wedge caviller approach definition maelstrom creekside stables mrs. brenda gerstner lula and 200707040000:200707050000.
...
TIFF Image Viewer CP, EXIF FAX ActiveX 6.0 BMP,...
Net-ready ActiveX component for which gives your end-users the ability to create
SQL queries via an intuitive visual interface. Supports Oracle, Microsoft
SQL Server, MySQL, PostgreSQL and many other
SQL dialects.
...
Domain Name Yahoo & Register Domain Name
ListSpawner™ can be used with any web hosting account/service that provides
SQL database
support, and PHP 4.3 (or above) with PHP mail. If you don't have a suitable web hosting provider. Click for Details
...
Apple and Google fall, Yahoo climbs in consumer ratings ...
Citrix. Cognos.
Coldfusion. CRM. Crystal Reports. Software Development. ERP. HTML. IBM. IT Infrastructure. ITIL. J2EE. Java. LAN/WAN. Linux. Lotus Notes. MS Project .NET. Oracle. SDLC.
SQL. IT
Support. IT Training
...
oDesk Job Openings Summary (rss) - 63 new articles
NET and
SQL Server 2005 Budget: $1800.00 Starting On: August 26, 2007 Ending On: Posted On: August 20, 2007 ID: 285272 Country: United States Hours Billed: 0. click to apply � Email to a friend - http://www.feedblitz.com/f/f.fbz?
...
useful bookmarks / websites
If I return out of a try/finally in C#,
does the code in the finally-clause run? 15 Seconds : Creating a Data Access Layer in .NET - Part 1; wayne plourde :: software architect :: articles; Implementing Triggers in
SQL Server 2000
...