OpenBD is shipped with the appropriate drives (for MS SQL) just set up the connection in the Admin and select MS SQL all should be good to go.
Adam On Wed, Apr 22, 2009 at 10:41 AM, DetailsDotAt <[email protected]> wrote: > > As of right now, everything is being ran on SQL Server 2000 > > We will upgrading to SQL 2008 soon, but as of right now, the platform > is SQL 2000 > > I've installed the following driver > > > http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en > -SQL<http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en%0A-SQL>Server > 2000 Driver for JDBC Service Pack 3- > "The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC > driver that provides highly scalable and reliable connectivity for the > enterprise Java environment. This driver provides JDBC access to SQL > Server 2000 through any Java-enabled applet, application, or > application server." > > It appears this is the most current driver for the server. > > I'm in no way tied to ODBC, just that it was what I was using before, > but appears that JDBC makes alot more sense since it is specifically > for java->db connectivity and anything else requires additional > overhead and still isn't as good. So it makes sense to use JDBC. > > Yes, there will be multiple front end webservers all connecting to the > same db server(s). I say (s) because if needed, we can scale out. But > at the moment, there will be one server on the immediately private > network (same private subnet) named db01. > > So, I have the jdbc driver installed on sql, what else do I have to > do? (i'm googling). > > Does the following config look correct? > > Assume the database hostname is 'db01', the datasource name should be > 'members' and the actual database itself is named 'members' > > <datasource name="members"> > <password>t3mpr00t</password> > <connectionretries>0</connectionretries> > <sqlupdate>true</sqlupdate> > <sqldelete>true</sqldelete> > <username>SA</username> > <drivername>com.microsoft.sqlserver.jdbc.SQLServerDriver</ > drivername> > <sqlstoredprocedures>true</sqlstoredprocedures> > <perrequestconnections>false</perrequestconnections> > <sqlinsert>true</sqlinsert> > <sqlselect>true</sqlselect> > <connectiontimeout>120</connectiontimeout> > <databasename>members</databasename> > <initstring></initstring> > <logintimeout>120</logintimeout> > <hoststring>jdbc:sqlserver://db01:1433;databaseName=members</ > hoststring> > <maxconnections>24</maxconnections> > <name>members</name> > </datasource> > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
