jtds driver works fine with MSSQL db for me , its open source can be found here http://jtds.sourceforge.net/
On Wed, Dec 30, 2009 at 7:13 AM, Aman Khanna <[email protected]> wrote: > I have not tried with sqljdbc4.jar but sqljdbc.jar worked fine for me. > > I have specified userid and passoword as separate properties. > <property name="connection.username">xxxx</property> > > <property name="connection.password">xxxx</property> > > > I had to change the connection URL to the format below for it to work. > <property > name="connection.url">jdbc:sqlserver://127.0.0.1:1433;databaseName=openmeetings;autoReconnect=true;useUnicode=true;createDatabaseIfNotExist=true;characterEncoding=utf-8</property> > > Hope this helps. > > On Tue, Dec 29, 2009 at 12:03 PM, HMiles <[email protected]> wrote: >> >> I have a couple of questions about the configuration for a mssql >> database. >> Can you tell me what I am doing wrong? >> >> 1. Does anyone know where I can get the mssql-jdbc.jar from.. >> 2. Will the sqljdbc4.jar from microsoft work with openmeetings? >> 3. Does anyone have the syntax that will make it auto create the >> database is in MYSQL configuration? >> I taken the following steps and I am still unable to connect to my MS >> SQL SERVER: >> >> I copied the sqljdbc4.jar into the red5\webapps\openmeetings\WEB-INF >> \lib directory >> I changed the following lines in the hibernate.cfg.xml file >> >> 'Rem the User /Password are included in the connection.url >> 'Rem the dialect was changed to >> "org.hibernate.dialect.SQLServerDialect" >> 'Rem the connection.driver_class was changed to >> "com.microsoft.sqlserver.jdbc.SQLServerDriver" >> 'Rem the connection.url was change to " jdbc:sqlserver:// >> xxx.xxx.xxx.xxx:1433;user=xxx;password=xxx;databasename=openmeetings? >> >> autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8" >> >> -- >> >> You received this message because you are subscribed to the Google Groups >> "OpenMeetings User" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/openmeetings-user?hl=en. >> >> > > -- > > You received this message because you are subscribed to the Google Groups > "OpenMeetings User" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/openmeetings-user?hl=en. > -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
