Thanks Manish Gupta and Aman Khanna for your help. I was able to get this to work using Aman's solution once I followed the simple instructions and remove the "&" from the url.
Again thanks much to you both.. Manish I am still interested in jtds solution as well and would like to know what was wrong in my url.. Miles On Dec 29, 7:58 pm, Manish Gupta <[email protected]> wrote: > jtds driver works fine with MSSQL db for me , its open source can be > found herehttp://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.- Hide quoted text - > > - Show quoted text - -- 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.
