On Wed, Nov 25, 2009 at 10:56 AM, Rob <[email protected]> wrote: > I configure the ODBC > pointing to the DB server using the windows admin tools
Why are you using ODBC? JDBC is going to give you vastly better performance. The only reason to use ODBC is if you have no other options, but you can definitely connect to SQL Server using JDBC. For SQL Server 2008 we haven't included the drivers with OpenBD yet (they'll be in the next version, or they may be in the nightly already), but you can grab a JAR file of the drivers, drop it into your WEB-INF/lib directory, and then use the "Other" datasource type to connect. Let me know if you need help with that. -- Matthew Woodward [email protected] http://mpwoodward.posterous.com identi.ca/Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
