• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting to SQL Server from NetBeans

 
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
kelly devon
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
author
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
kelly devon
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you so much
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic