Accessing SQL server database

Hi,

I am trying to access SQL server database using the driver provided by microsoft.

The connection string used is jdbc:microsoft:sqlserver://mymachine:1433;DatabaseName=Temp

but the problem is my deployment machine is not able to support TCP/IP protocol for communication. Is there a way to specify the protocol of communication in connection string.

As far i knw SQL server supports 3 types of protocol 1.Names pipelines 2.Shared memory 3.TCP/IP

I want to use a connection string where i can specify first or second option as the protocol.


regards,
Naval
LVL 8
navalarya1982Asked:
Who is Participating?
 
CEHJCommented:
0
 
CEHJCommented:
Try the jtids driver - it supports named pipes
0
 
objectsCommented:

try jdts and set the namedPipe parameter
http://jtds.sourceforge.net/faq.html
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
navalarya1982Author Commented:
is it free ?
0
 
CEHJCommented:
YEs
0
 
navalarya1982Author Commented:
can you send me sample connection string format :)

regards,
Naval
0
 
CEHJCommented:
0
 
objectsCommented:
> can you send me sample connection string format :)

jdbc:jtds:sqlserver://dbserver/dbname;namedPipe=pipename

see my comment above reagrds the namedPipe parameter for more details
0
 
hoomanvCommented:
By default, Windows XP will install TCP/IP when you install a network card
go to "network connections" and install it manually
0
 
Mayank SAssociate Director - Product EngineeringCommented:
You'll get a list of most JDBC drivers here:

http://developers.sun.com/product/jdbc/drivers

Select your DB and pick the one you wanna use.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.