Yasser,
Your configuration should look something like this for the JTDS driver:
catalina.server.home=c:/tomcat5
catalina.server.shared=${catalina.server.home}/shared/lib
org.apache.jetspeed.production.jdbc.drivers.path=
${catalina.server.shared}/jtds-0.8.1.jar
org.apache.jetspeed.production.database.default.name=mssql
org.apache.jetspeed.production.database.url=jdbc:jtds:sqlserver://hostname:1433/j2
org.apache.jetspeed.production.database.driver=net.sourceforge.jtds.jdbc.Driver
org.apache.jetspeed.production.database.user=some
org.apache.jetspeed.production.database.password=some
HTH,
Randy
On Tue, 2006-01-10 at 13:26 +0000, Aaron Evans wrote:
> yasser arafat <yasserarafat_in <at> yahoo.com> writes:
>
> >
> > hi,
> > I have been trying to create a custom portal for the past three weeks. I
> have one running with the default db
> > hsql. The requirement to use mssql was enforced. So i did the following
> > 1) Configured the build.properties
> > *************************mssql************************
> > org.apache.jetspeed.production.database.default.name=mssql
> > org.apache.jetspeed.production.database.url=jdbc:odbc:pbcportal
> > org.apache.jetspeed.production.database.user=some
> > org.apache.jetspeed.production.database.password=some
> >
> > org.apache.jetspeed.production.database.driver=sun.jdbc.odbc.JdbcOdbcDriver
> > org.apache.jetspeed.production.jdbc.drivers.path=
>
> Do you mean MS SQL Server?
>
> So firstly, you have to provide the path to your JDBC drivers in your config.
>
> Secondly, if it is MS SQL Server you wish to connect to, may I ask why you
> are using generic ODBC drivers instead of the MS SQL Server JDBC drivers?
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
