Setting default Network Library for use with ADO connection string?

From: Barry Clark (b.clark_at_clinmed.gla.ac.uk)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 14:20:46 +0100

Hi

Is it possible to permanently modify the Delphi ADO connection string
builder for SQL server so that Network Library is automatically set to
"Network Library=dbmssocn;".

We have just solved a permissions problem (we have just moved to an IP-only
network) by adding this, and we now need to recompile all our programs.
(BTW: this forces the Delphi app to use TCP/IP as the transport protocol
rather than named pipes.)

It would be nice if in future creating an MS SQL connection string
automatically added "Network Library=dbmssocn;". Is it possible to do this?

TIA

Barry 

-- 
Dr Barry Clark
Senior Lecturer
Medical Education Unit
Faculty of Medicine
Wolfson Medical School Building
University of Glasgow
Glasgow G12 8QQ
Tel: 0141-330-4248
Email: b.clark@clinmed.gla.ac.uk

Relevant Pages

  • Re: SQL Server security exception
    ... but the SQL server is on the ... This is very strange because I'm using the same Connection String ... > | public SqlConnection SqlConn = new SqlConnection; ... > Do you happen to run this from a network drive? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: XMLBulkload fails in asp.net com interop but works in vb.net
    ... Is it possible that your asp.net process is running under the NETWORK ... If you webserver and sql server are on different boxes, ... >> There is something wrong with your connection string. ...
    (microsoft.public.sqlserver.xml)
  • Re: web service for accessing db?
    ... Plus I have connection string embeded in to code. ... All client are within the network or accesing network through VPN. ... be in using web service, I don't see benefits at all. ... malicious user can read its content and connect to sql server directly. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS
    ... Check www.connectionstrings.com and see if your connection string is valid. ... my sql server here on my laptop on my company's network. ... The timeout period elapsed prior to completion of the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Accessing a remote DB via wp_aspnet.exe
    ... runs under the local ASPNET account. ... account that wil also be authorized in the SQL Server. ... > you can use the SQl Server's name in the connection string. ... > If the other SQL Server is outside your network, ...
    (microsoft.public.dotnet.framework.aspnet)