• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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
0
navalarya1982
Asked:
navalarya1982
  • 4
  • 2
  • 2
  • +2
3 Solutions
 
CEHJCommented:
Try the jtids driver - it supports named pipes
0
 
CEHJCommented:
0
 
objectsCommented:

try jdts and set the namedPipe parameter
http://jtds.sourceforge.net/faq.html
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now