DetailsDotAt wrote:
What is the BEST method for creating datasources? I was hoping I could just edit the .xml file.
You can definitely edit the XML file. What you had looked correct to me, though I'd have to look up the JDBC URL syntax for that driver. If you're sure that's right it should work.
I thought it needed to be installed on the SQL server, not the webserver. However, I installed it on both www1 and db01.
Nope, the JDBC driver only needs to be installed on the web server side.
When installing it, it did not prompt me for a installation path, so I'm not sure how to install it directly to the Jetty/OpenBD folder. Also, where actually would I install it if I had the option?
The "install" process for a JDBC driver is simply to make it available to OpenBD or Jetty's classpath, which means you just need to drop a JAR file in either OpenBD or Jetty's lib directory and restart OpenBD (or Jetty if you put it in the higher-level lib directory).
I suspect if MS has an actual installation program with their driver all they're doing is unzipping some things and creating a JAR file. The key is getting the JAR file in a place where OpenBD can see it. Typically this would be in WEB-INF/lib, or on the ready2run version it would go under lib/openbd
Looking at "Add Datasource" from within the admin page, I see a drop down for database type. Should I use 'Microsoft SQL Server (jTDS)' or 'Other JDBC Driver'?
If you want to use the MS driver, you'd pick "Other" and supply all the details. But the jTDS driver works with SQL Server 2000 as well (and IMO is a better driver than Microsoft's).
-- Matt Woodward [email protected] http://www.mattwoodward.com/blogPlease do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
smime.p7s
Description: S/MIME Cryptographic Signature
