Dave, I haven't had much luck trying use the SQL Server Drivers from CF. I think it has something to do with using trusted connections. I'm not sure how to set up SQL Server to accept logins via a username and password. I have changed the default account SQL Server is running under, and created a "login" which I then try to use when connecting via CF,but the connection always fails. I'm sure its something obvious I'm missing, but I'm no SQL Guru :)
bd At 06:38 PM 18/08/02 -0400, you wrote: > > I'd love to try the Type 4 Drivers, but unfortunately I'm > > still running MSSQL 7. > >According to the documentation, the Type 4 drivers supplied with CF MX would >work with SQL Server 7 and 2000. You can't connect to SQL Server 6.5 and >earlier with those drivers, though. > >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
