DataDirect Andy
On Fri, 25 Feb 2005 08:11:25 -0500, Calvin Ward <[EMAIL PROTECTED]> wrote: > 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:196500 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
