RE: SQL Server connection best practice?

2008-01-02 Thread Dave Watts
We're running CFMX7 and SQL Server 2000 in Windows2003 Server. I know there are a variety of ways that one can get CF to talk to a SQL Server box: ODBC, JDBC, Named Pipes, and so on. I don't even pretend to know what all of that really means. The question is what's the best practice

Re: SQL Server connection best practice?

2008-01-02 Thread Ben Mueller
Okay, that's kind of what I thought. I think the SequeLink thing is what I was thinking of wrt to the ODBC driver. Thanks, Dave. ColdFusion only supports JDBC, so you'll be using JDBC. You can either use a pure Java JDBC driver, or you can connect to ODBC datasources using SequeLink as a JDBC

RE: SQL Server connection best practice?

2008-01-02 Thread Mark Kruger
Ben, Search House of fusion for a recent thread on query optimization as well... There was an interesting issue with a stored proc taking too long and it turned out to be permissions on the database (made me go hm.) -mark -Original Message- From: Ben Mueller [mailto:[EMAIL