Is CFMX7 using the MS driver or DataDirect?
-----Original Message-----
From: Alin Sinpalean [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 2:30 PM
To: CF-Talk
Subject: Re: Upgrading and datasources
>> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
>> issues with the datasources not working properly?
>>
>> CFMX7 doesn't seem to translate port numbers for SQL Server
>> properly (especially if they are set to dynamically determine
>> in the ODBC console) and none of the passwords seem to work!
>
>In my experience, you typically have to reconfigure SQL Server datasources
>when upgrading CF 5 to CFMX. There are several differences between CFMX and
>previous versions when it comes to SQL Server. If you use the SQL Server
>JDBC driver, you can't use anything other than TCP/IP to connect, and you
>can't use Windows authentication within SQL Server - you need to use native
>SQL logins ("untrusted connections"). If you need to use other network
>protocols or Windows authentication, you will need to use an ODBC
datasource
>instead, and choose "ODBC Socket" within the CF Administrator.
Dave, Calvin,
Indeed the MS driver only supports TCP/IP as a communication protocol and
SQL Server authentication. You could, however use jTDS: it works both over
TCP/IP and named pipes and supports three types of authentication (SQL
Server, Windows authentication providing a user name and password and
Windows authentication using a native Single Sign On library).
jTDS is also more stable and a faster than the MS driver.
Disclaimer: I am a jTDS developer.
Alin,
The jTDS Project.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196499
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
