Thx. I've been talking to a macromedia rep and they basically are telling me the same thing with the caveat even though it was supported in CF 5. I was hoping I wouldn't have to do a workaround, but it looks like I will.
thanks! Shannon >>> [EMAIL PROTECTED] 03/18/03 10:52AM >>> No. At least I haven't found a way to do this. I think that if you are using any of the JDBC drivers with SQL Server you have to use SQL Authentication. Jeff Garza ----- Original Message ----- From: "Shannon Tucker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 8:41 AM Subject: [CFCDev] JDBC Drivers (Any Vendor), in this case MS-SQL Server from Microsoft. This might be a bit off topic, but does anyone know if you can pass a domain username and password to this driver? I've been using the default Merant driver in MX and it will support passing a sql username and password, but not a windows username and password as supported in CF5. Any thoughts? Thx Shannon >>> [EMAIL PROTECTED] 03/17/03 11:34AM >>> Chris, Download the JDBC Drivers (Any Vendor), in this case MS-SQL Server from Microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d- 8f7b-3d47969e66ae&DisplayLang=en This only works with SQL-Server 2000, 7 you are out of luck. 1.Install the driver, copy the three *.jar files in the /lib directory to /CFusionMX/wwwroot/WEB-INF/lib. 2.In cf-admin, go to JVM/classes setting, enter the classpath to the directory (wwwroot/WEB-INF/lib), you will need to re-start cfmx after this. 3.Create an "Other" datasource in Cf-Admin, give it the "Url connection String" and Driver Name. Different drivers vary for the connection string params. check docs. This is probably the best configuration for optimal performance. Joe Eugene ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
