RE: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Andy Mcshane
How do you have your SQL Security Authentication setup? Is it set to 'WIndows only' or 'SQL Server and WIndows'? From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Fri 22/07/2005 12:04 To: CF-Talk Subject: CFMX 7 - DSN - MSSQL Having a problem getting a

RE: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Tim Laureska
Found the answer on Stephen Crat's Talkingtree.com blog... can't have Windows only authentication for MSSQL JDBC driver in CFMX - have to set it up in mssql enterprise mgr to have windows and MSSQL security -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Paul Hastings
Tim Laureska wrote: Found the answer on Stephen Crat's Talkingtree.com blog... can't have Windows only authentication for MSSQL JDBC driver in CFMX - have to set it up in mssql enterprise mgr to have windows and MSSQL security yes you can with the newest datadirect drivers (in one of the later

RE: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Dave Watts
yes you can with the newest datadirect drivers (in one of the later cf hotfixes, i think 1st one for cf7). While the driver itself does support this, have you done this from CF? I suspect you'd need to write something specific within the JDBC URL to use this, and the CF Administrator doesn't

RE: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Tim Laureska
[mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 8:54 AM To: CF-Talk Subject: RE: CFMX 7 - DSN - MSSQL yes you can with the newest datadirect drivers (in one of the later cf hotfixes, i think 1st one for cf7). While the driver itself does support this, have you done this from CF? I

RE: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Dave Watts
It does make mention of inserting something specific within the JDBC URL Yeah, you're right, it's all right there in the technote, and it looks pretty simple. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized

Re: CFMX 7 - DSN - MSSQL

2005-07-22 Thread Paul Hastings
Dave Watts wrote: While the driver itself does support this, have you done this from CF? I suspect you'd need to write something specific within the JDBC URL to use this, and the CF Administrator doesn't give you a place to do that. Or maybe you could just choose Other? well yes. it's a bit