Results 1 to 8 of 8
  1. #1
    swati.jyoti is offline Member
    Join Date
    Mar 2009
    Posts
    42
    Rep Power
    0

    Default connection of microsoft sql server 2005 with netbeans ide 6.1

    hi,

    I am not able to connect my netbeans Ide 6.1 with Microsoft Sql server 2005.
    Can anyone help me to fix this problem so that i can continue with my work further.

    Thanks

  2. #2
    dswastik is offline Senior Member
    Join Date
    Dec 2008
    Location
    Kolkata
    Posts
    282
    Rep Power
    6

    Default

    It will depend upon the type of jdbc driver you are using. If you are using jdbc-odbc bridge driver you dont need any specific settings from netbeans, however if you are using type-IV driver you need to include the jar file into the classpath of your project.

  3. #3
    swati.jyoti is offline Member
    Join Date
    Mar 2009
    Posts
    42
    Rep Power
    0

    Default

    ok thanks..
    wl check it out

  4. #4
    jazz2k8's Avatar
    jazz2k8 is offline Senior Member
    Join Date
    Apr 2008
    Posts
    150
    Rep Power
    7

    Default

    Hi Swathi.jyothi,

    Hav you enabled your TCP/Ip protocal for SQL server2005?

  5. #5
    ju.serey is offline Member
    Join Date
    Mar 2009
    Posts
    1
    Rep Power
    0

    Default

    Acceso a SQL Server en NetBeans utilizando JDBC, Parte I: Crear una conexión

  6. #6
    JpennPSM is offline Member
    Join Date
    Apr 2010
    Posts
    1
    Rep Power
    0

    Default How to include the jar file into the classpath in my project when connecting to sq?

    I believe I've added the jar file to the classpath, but I can't seem to connect to my data base.
    Im connected to the database with NetBeans 6.8, and can get to the database and see all the tables but keep getting:

    SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "databaseName" requested by the login. the login failed.


    In my services window I have a conection:
    jdbc:sqlserver://myLocalServer\myLab;databaseName= myDataBase [myLab on dbo]

    below that I have my list of databases including the one I want to access:
    myLab

    and in this I have more databases, and the one I want to access:
    dbo

    and the table I'd like to access.

    Someone please help
    Last edited by JpennPSM; 04-30-2010 at 05:45 AM. Reason: worked out my initial problem

  7. #7
    Kalai Arasi is offline Member
    Join Date
    Mar 2012
    Posts
    1
    Rep Power
    0

    Post Re: connection of microsoft sql server 2005 with netbeans ide 6.1

    Quote Originally Posted by dswastik View Post
    It will depend upon the type of jdbc driver you are using. If you are using jdbc-odbc bridge driver you dont need any specific settings from netbeans, however if you are using type-IV driver you need to include the jar file into the classpath of your project.
    Can u send me the step wise procedure to connect netbeans IDE 6.9.1 with sql server 2005. I don't know the exact procedure.

  8. #8
    noobplus's Avatar
    noobplus is offline Senior Member
    Join Date
    Feb 2012
    Location
    chennai,south of India(south east of asia)
    Posts
    232
    Rep Power
    3

    Default Re: connection of microsoft sql server 2005 with netbeans ide 6.1

    Quote Originally Posted by Kalai Arasi View Post
    Can u send me the step wise procedure to connect netbeans IDE 6.9.1 with sql server 2005. I don't know the exact procedure.
    It is very easy first make sure that when you install sql 2005 you have used mixed aut. and after that on net beans when you connect use the use name "sa" and the pass you gave it when you installed. that will work.

    regards
    dhilip

Similar Threads

  1. Replies: 4
    Last Post: 09-07-2010, 06:51 AM
  2. Replies: 0
    Last Post: 12-16-2008, 08:32 AM
  3. Replies: 1
    Last Post: 10-16-2008, 02:09 PM
  4. Java connecting to sql server 2005
    By pelegk2 in forum JDBC
    Replies: 0
    Last Post: 04-05-2008, 09:17 PM
  5. SQL Server 2005 Jdbc connection
    By mgt83 in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 07-27-2007, 04:52 AM

Posting Permissions

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