connection of microsoft sql server 2005 with netbeans ide 6.1

[swati.jyoti]

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

[dswastik]

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.

[swati.jyoti]

ok thanks..
wl check it out

[jazz2k8]

Hi Swathi.jyothi,

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

[ju.serey]

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

[JpennPSM]

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

[Kalai Arasi]

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.

[noobplus]

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