> its (both getting the ms jdbc driver or trusted connections > to work) worth a lot. how did he do it?
Quoth Jeff Garza: "Copied the three Microsoft .jar files to CFUSIONMX\Lib\ directory. Added "c:\CFUSIONMX\lib\msbase.jar,c:\CFUSIONMX\lib\mssqlserver.jar,c:\CFUSIONMX\l ib\msutil.jar" to the ColdFusion Java Class Path via the administrator. Set up the DSN using the following information as an "other datasource" connection. JDBC URL: jdbc:microsoft:sqlserver://localhost:1433; Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver Driver Name: Microsoft SQL2000 JDBC Driver Username: sa Password: ********* Connect String: selectmethod=direct I included the selectmethod in the connect string as the SQL Server JDBC Driver shows that it's not an optional parameter and it's not provided in the Other Datasource form. I don't know if the connection will work without it or not." I'm not sure why everyone seems so hot about using trusted connections, though, since that just means that the CF service's user account has to have the appropriate rights. Or am I missing something here? As for the MS driver itself, I don't think it'll give you anything that the Merant driver doesn't already, although the MS driver is type IV and should perform well enough. Have you had any trouble with the Merant one? The funniest detail about this is that MS is distributing a PDF with the driver as documentation - I don't think I've ever seen a PDF on the MS site. To top that, the PDF they're including only has the cover page, not the actual documentation. D'oh! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
