dbTalk Databases Forums  

Configuring protocols in SQL Native Client

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Configuring protocols in SQL Native Client in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Francois PIETTE
 
Posts: n/a

Default Configuring protocols in SQL Native Client - 03-13-2007 , 08:17 AM






When SQL Native Client has been installed on a client computer using
SQLNCLI.MSI, the Configuration Manager is not installed. Hence the question:
How do we configure the protocol to be used to connect to the server ?

--
Francois PIETTE
http://www.overbyte.be



Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Configuring protocols in SQL Native Client - 03-13-2007 , 09:02 AM






Connect from what application, how are you connecting? If it's a
connection string, you can include network library in your connection
string.

-Sue

On Tue, 13 Mar 2007 15:17:40 +0100, "Francois PIETTE"
<fpiette (AT) newsgroups (DOT) nospam> wrote:

Quote:
When SQL Native Client has been installed on a client computer using
SQLNCLI.MSI, the Configuration Manager is not installed. Hence the question:
How do we configure the protocol to be used to connect to the server ?


Reply With Quote
  #3  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Configuring protocols in SQL Native Client - 03-13-2007 , 09:20 PM



Hello Francois,,

If you'd like to connect to server by using SQL native client, you may need
to install sql client tool which include configuration manager. Actually
configuration manager use WMI API to connect to WMI provider to get sql
native client related information. If you don't want to use configuration
manager, you may need to develop your own code/script to do this job:

#WMI Provider for Configuration Management
http://msdn2.microsoft.com/en-us/library/ms180499.aspx

http://blogs.msdn.com/sql_protocols/...19/482840.aspx

If you have any feedback or wishes on this feature, I encourage you submit
via the link below and our product team would like to hear your voice:

http://lab.msdn.microsoft.com/produc...k/default.aspx

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================




Reply With Quote
  #4  
Old   
Francois PIETTE
 
Posts: n/a

Default Re: Configuring protocols in SQL Native Client - 03-14-2007 , 02:12 AM



Quote:
Connect from what application, how are you connecting? If it's a
connection string, you can include network library in your connection
string.
The application use an ODBC datasource. You have no parameter except the
datasource name.

--
Francois PIETTE
http://www.overbyte.be




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.