my dog learned polymorphism*
The moose likes IDEs, Version Control and other tools and the fly likes Connecting to SQL Server from NetBeans Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Connecting to SQL Server from NetBeans" Watch "Connecting to SQL Server from NetBeans" New topic
Author

Connecting to SQL Server from NetBeans

kelly devon
Ranch Hand

Joined: Apr 15, 2004
Posts: 75
How do i connect to SQL server from the SQL server itself or should i write the JDBC ODBC code? because from the netbeans application i cannot link. please help
thank you


kel
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Do you mean what client should you use? SQL Server Management Studio comes with the SQL Server tools.


or should i write the JDBC ODBC code

Unless your database is Access you should never have to write JDBC-ODBC code.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
kelly devon
Ranch Hand

Joined: Apr 15, 2004
Posts: 75
Am sorry i meant what client should i use. cause i tried asking the netbeans application to locate the sql server which it didnt so am confused. its not even recognising it. please help thank you
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

I am moving this post to our IDE forum.
I adapted to title to show that you can't connect to SQL Server with NetBeans.


OCUP UML fundamental and ITIL foundation
youtube channel
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

Two steps: first register the JDBC driver, then register the database. Details:

1) Click on the Services tab (it is in the top-left panel, next to the Projects ans Files tabs). Expand databases and right-click Drives, choose New Driver. In the New JDBC Driver dialog click Add and locate the JDBC driver JAR file. Once you identify the driver JAR the rest of the fields in the dialog should be filled. Click OK

2) Right-click the driver and select Connect Using. Fill out the New Database Connection dialog for your database. Click OK. A new entry for your database shows up under Database.

You can then expand the database entry to view tables and data.


JBoss In Action
kelly devon
Ranch Hand

Joined: Apr 15, 2004
Posts: 75
Thank you so much
 
wood burning stoves
 
subject: Connecting to SQL Server from NetBeans
 
Similar Threads
Connection error to SQL database
JDBC ODBC Connection
Connecting to sql server
uploading ms word document into sql database
SQL Server express 2008 jdbc connection problem