FreeQueryBuilder / Discussion / Help: cannot connect to sql server

hao - 2006-02-17

Hi,
I got a problem to use SQLeonardo to connect to my sql server. It seems that I cannot add the JDBC driver.
I followed the instructions on the website to put three sqlserver jdbc .jar files into the right place and choose .SQLServerDriver as the driver class, but after i clicked the "ok", there are some execptions thrown out, like "noclassdeffounderror:com/.../basedriver. I set the CLASSPATH to the other two .jar files. The problem is still there.
Can you give me some help? Thanks
Hao

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- nickyb - 2006-02-17
  
  Hello,
  
  Strange. Please could you me send a screenshot of the "new.driver" dialog (the first step)? and what's your environment as OS and Java?
  
  (nickyb@users.sourceforge.net)
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- hao - 2006-02-18
  
  Thanks nickyb,
  
  I have posted a description of my problem on the internet. Please take a loot at following link:
  http://tinman.cs.gsu.edu/~cschntx/problemDes.htm
  
  Hao
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - nickyb - 2006-02-18
    
    WOW!!!
    
    Well, you must put the 3 jars in this dir:
    c:\Program Files\Java\jdk1.5.0_05\jre\lib\ext
    
    Then choose the mssqlserver.jar in the tree
    
    Nicky
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - hao - 2006-02-19
      
      It does not work to put them into \jdk1.5.0_05\jre\lib\ext\, and modify the CLASSPATH to the new directory.
      I got the same exceptions. ?
      Hao
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - nickyb - 2006-02-20
        
        try:
        
        java -cp sqleonardo.jar;<dir>\msbase.jar;<dir>\mssqlserver.jar;<dir>\msutil.jar; nicky.sqleonardo.Application
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
        
        hao - 2006-02-21
        
        Thanks nickyb,
        It is working now.
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

cannot connect to sql server

Forums

Help

cannot connect to sql server document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

cannot connect to sql server