[opencms-dev] OpenCMS and SQL Server 7.0

Balzarotti Paolo Paolo.Balzarotti at rasnet.it
Wed Mar 20 15:41:49 CET 2002


Hello,
I've tried to use Microsoft SQL Server 7.0 as DB server for Opencms. 
I've tried different jdbc driver: JTurbo, FreeTDS,  Microsoft JDBC Driver
Beta
changing the config\opencms.properties as you can see below:

# Parameters for the generic connection-pool
pool.genericsql.driver=com.thinweb.tds.Driver
pool.genericsql.url=jdbc:twtds:sqlserver://127.0.0.1:1433/opencms
or 
# Parameters for the generic connection-pool
pool.genericsqlbackup.driver = com.ashna.jturbo.driver.Driver
pool.genericsqlbackup.url = jdbc:JTurbo://127.0.0.1:1433/opencms
...
Result:
java.sql.SQLException: java.sql.SQLException: Incorrect syntax near the
keyword 'user'.
-------------------------------------------
java.sql.SQLException: java.sql.SQLException: Line 1: Incorrect syntax near
'connect'.
-------------------------------------------



More information about the opencms-dev mailing list