I use the SQL Server Driver ... although I've had problems with them in the past... They seem to have had more problems with JDBC drivers than with almost anything else since moving to J2EE from CF5. The ODBC Socket, while it works, isn't very desirable because even on the Sun website they say that the ODBC Socket drivers are a "workaround" and shouldn't be used except as a last resort. Iirc the ODBC Socket also doesn't allow you to use some of the metadata features of JDBC (which are included in the onTap framework).
Though lately I've been able to get the JDBC drivers that came with Red Sky to work fine. What kind of issues are you having with the JDBC drivers for SQL Server anyhow? > In CF Administrator > Data Sources > Does anybody use the "Microsoft SQL Server" driver? > I can't connect w/ this driver. I have to set up an ODBC > connection the SQL Server db and then use the "ODBC > Socket" driver. All the tech notes say to use this > workaround. Any ideas? This doesn't seem very efficient > to me. > Here's what I'm running all on the same box: > cfmx 6.1 > windows 2000 adv server > MS SQL Server 2000 > SQL Server 2000 Driver for JDBC Service Pack 2 > Thanks, > Joe Kelly s. isaac dealey 214.823.9345 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.turnkey.to/ontap ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
