+ Reply to Thread
Results 1 to 2 of 2

Thread: connection to sql server

  1. #1
    Junior Member
    Join Date
    Feb 2012
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Unhappy connection to sql server

    Hi im using es5 and for the dbloginmysql example, i tried it with mysql and it worked.. i tried copying sqlserver-jdbc driver and also the dll for integrated security but it has been throwing an "Database error" all the time...Please help..

    the database.properties file has :



    database.driverClassName=com.microsoft.sqlserver.j dbc.SQLServerDriver

    database.url=jdbc:sqlserver://127.0.0.1:1433;instanceName=SQLExpress;database=us erinfo;integratedSecurity=true;

  2. #2
    Former Administrator tcarr's Avatar
    Join Date
    Dec 2007
    Posts
    7,709
    Thanks
    84
    Thanked 1,178 Times in 1,165 Posts
    I don't have any experience with SQLExpress. Can you give me the exact error messages that you see in ElectroServer5.log and Console.log, with a few lines above them for context? Maybe I can figure out what the problem is. I assume that SQL Server is case insensitive? I noticed that you give the database as userinfo instead of UserInfo.

    Things that other people have had problems with, in MySQL:
    * is the database installed and running? (seriously, somebody didn't know that he had to install MySQL first)
    * is the username and password in the database.properties file correct?
    * does that user have DDL privileges, or is the Users table already created?
    Teresa Carrigan
    Senior Software Developer
    Janus Research Group, Inc.
    previously
    Senior Engineer
    Electrotank, Inc.

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts