navalarya1982
asked on
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;Data baseName=T emp
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
I am trying to access SQL server database using the driver provided by microsoft.
The connection string used is jdbc:microsoft:sqlserver:/
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
Try the jtids driver - it supports named pipes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is it free ?
YEs
ASKER
can you send me sample connection string format :)
regards,
Naval
regards,
Naval
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By default, Windows XP will install TCP/IP when you install a network card
go to "network connections" and install it manually
go to "network connections" and install it manually
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.