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.