Named Pipes vs TCP/IP (setting automatically during app install or within app)

Named Pipes vs TCP/IP (setting automatically during app install or within app)

Post by Greg Berthum » Thu, 27 Jul 2000 04:00:00



My installation program gives the user the option to run MDAC_TYP.EXE to
install the SQL Server 7 connectivity components.  The Network Library
Configuration is defaulting to Named Pipes.  I would like to give the user
the option to use TCP/IP and have the installation take care of it.

How can this be done?  Is there a MDAC_TYP.EXE command line option?  Is
there a WinAPI function I can use to do it?  Is there a INI file setting
somewhere?

My application's SQL Server connect string is stored in an ini file, ie:
SERVER,DATABASE,LOGIN,PASSWORD

Is there a connection parameter to specify the connection method?
--
Thanks,
Greg Berthume

http://members.aol.com/gberthume

 
 
 

Named Pipes vs TCP/IP (setting automatically during app install or within app)

Post by Neil Pik » Fri, 28 Jul 2000 04:00:00


Greg - I think you'll have to amend the registry settings in HKCU yourself - no
API I know of.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or    http://www.ntfaq.com/Section.cfm?sectionID=34
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

 
 
 

1. Named Pipes vs TCP/IP (setting automatically during app install or within app)

My installation program gives the user the option to run MDAC_TYP.EXE to
install the SQL Server 7 connectivity components.  The Network Library
Configuration is defaulting to Named Pipes.  I would like to give the user
the option to use TCP/IP and have the installation take care of it.

How can this be done?  Is there a MDAC_TYP.EXE command line option?  Is
there a WinAPI function I can use to do it?  Is there a INI file setting
somewhere?

My application's SQL Server connect string is stored in an ini file, ie:
SERVER,DATABASE,LOGIN,PASSWORD

Is there a connection parameter to specify the connection method?
--
Thanks,
Greg Berthume

http://members.aol.com/gberthume

2. Passing date to stored procedure

3. Named Pipes vs TCP/IP

4. RAISERROR and Error Log

5. .Addnew & .Update question

6. Name Pipe vs TCP/IP

7. Networked Oracle with VAXen

8. Named Pipes vs. TCP/IP

9. TCP IP vs Named Pipes

10. Strange connection problem (TCP/IP vs. Named Pipes)