Devart Forums

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

Additional Information:

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

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.

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