connection of microsoft sql server 2005 with netbeans ide 6.1

Printable View

03-06-2009, 01:31 PM
swati.jyoti

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
03-06-2009, 01:34 PM
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.
03-09-2009, 01:17 PM
swati.jyoti

ok thanks..
wl check it out
03-09-2009, 01:21 PM
jazz2k8

Hi Swathi.jyothi,

Hav you enabled your TCP/Ip protocal for SQL server2005?
04-05-2009, 06:57 AM
ju.serey

Acceso a SQL Server en NetBeans utilizando JDBC, Parte I: Crear una conexión
04-30-2010, 05:23 AM
JpennPSM

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
03-17-2012, 10:40 AM
Kalai Arasi

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

Quote:

Originally Posted by 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.

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.
03-17-2012, 10:46 AM
noobplus

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

Quote:

Originally Posted by Kalai Arasi

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