Results 1 to 3 of 3
  1. #1

    JDBC Integrated Security Authentication DLL

    I'm trying to connect to my SQL Server database using JDBC, and I used the JDBC adapter example that Alessandro so graciously provided (modifying it for use with SQL server instead of MySQL), but I don't know where to place the authorization dll (sqljdbc_auth.dll) so that it packages correctly when the LightStreamer server is started.

    Any help would be greatly appreciated. Thank you!

  2. #2
    Particularly, my DataAdapter's init function looks like this:

    Code:
        
    public void init(Map params, File configDir) {
                try {
            
            errorThing = "after";
                
                   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
                   conn = java.sql.DriverManager.getConnection("jdbc:sqlserver://local:1433;databaseName=Database;integratedSecurity=true;");
                   
                   
                   if(conn!=null)
                   {
                    errorThing = "is not null";
                   }
                   else
                   {
                   errorThing = "is null";
                   }
                  
            } catch (SQLException ex){
                System.out.println(ex.getMessage());   
    
    
                errorThing = ex.getMessage();            
                //throw new DataProviderException(ex.getMessage());    
            }
            catch(ClassNotFoundException ex){
                System.out.println(ex.getMessage());  
                errorThing = "ClassNotFoundException";
            }
            catch(Exception ex)
            {
                errorThing = ex.getMessage();
                errorThing = "Exception";
            }
    
    
        }
    Which is populating errorThing with

    "This driver is not configured for integrated authentication. ClientConnectionId:524003dc-8943-42a7-a0da-2799cbad1df0"

    Which is symptomatic of the dll being missing.

  3. #3
    Sorry, this was easy. I just had to add the java library path to the LS.bat file.

 

 

Similar Threads

  1. JDBC Data Adapter [Java]
    By Alessandro in forum Adapter SDKs
    Replies: 12
    Last Post: May 22nd, 2023, 02:42 PM
  2. Replies: 3
    Last Post: January 7th, 2010, 09:57 AM
  3. Replies: 8
    Last Post: May 22nd, 2008, 06:01 AM
  4. error jdbc Orcale
    By khalil78 in forum Adapter SDKs
    Replies: 2
    Last Post: April 22nd, 2008, 12:46 PM
  5. Replies: 6
    Last Post: May 7th, 2007, 06:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT +1. The time now is 12:56 AM.