Shared Memory Connections not supported ?

martin · Post by **martin** » Fri 10 Jul 2009 07:45

I try to connect to a local sql server using the Shared Memory protocol by specifying:

lpc:servername

Connection is established but with the named pipes protocol. The lpc prefix must be correct and recognized because if I use an invalid prefix, the connection does not get established.

Simple Question: Does dbExpress SQL Server Driver support the Shared Memory Protocol ?

Thanks
Martin

martin · Post by **martin** » Fri 10 Jul 2009 08:11

Additional Information:

Delphi 6.02
Latest dbExpress Drivers
Win2003 SP2 Enterprise
SQL Server 2008 SP1 Enterprise

Challenger · Post by **Challenger** » Mon 13 Jul 2009 10:21

There is no need to specify the lpc prefix. The Shared Memory protocol is always tried first. To use it you should use the Native Client provider. Please try to set the sqlncli value to the VendorLib property of the TSQLConnection.

martin · Post by **martin** » Mon 13 Jul 2009 11:04

Challenger wrote:There is no need to specify the lpc prefix. The Shared Memory protocol is always tried first. To use it you should use the Native Client provider. Please try to set the sqlncli value to the VendorLib property of the TSQLConnection.

We switched to Native Client Provider and now it works. Thanks for helping.

PS: Could you please look at my other issue with the Broken Connections ?

Thanks
Martin