Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learner007
Starting Member
4 Posts |
 Posted - 2007-08-16 : 23:58:57
|
| hi all.can any1 help me in "SQL Server Database & Java Connectivity" plz. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-17 : 00:04:02
|
| What do you like to know? |
 |
|
|
learner007
Starting Member
4 Posts |
Posted - 2007-08-17 : 15:04:36
|
quote:
Originally posted by rmiao
What do you like to know?
I want to know that do we need to do any sort of configuration either in SQL Server or JBuilder for connectivity(when we connect JBuilder with Oracle, we add(JBuilder->tools->configure JDKs) one zip file of oracle, which is within bin of oracle 9i ).And I need one very simple code by which i can see the connectivity is working or not.i hv good knowledge on query & other sql stuffs.thanx in advance buddy. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:40:43
|
| Nothing in sql, you need build jdbc connection string. |
|
|
|
learner007
Starting Member
4 Posts |
Posted - 2007-08-18 : 02:07:43
|
| how to do that? plz give me 1 example. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 17:14:55
|
| The following sample code demonstrates how to specify a connection URL: con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password"); |
|
|
|
|
|
|
SQL Server Database & Java Connectivity