>> 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:196176
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
