March 20, 2002 at 1:37 pm
Hello, I am trying to connect SQLDMO using TCP IP, I can do it in VB using a aDODB Connection object not having any problem, but i don´t find any info on how to do it using SQL DMO object. Also in MS, they say SQLDMO.dll uses default protocol that is specifien on clientconfiguration but i did not find where is it. I know i have correct configuration using svrnetcn.exe , becouse it works correctly using ADODB. Thanks for advance
March 20, 2002 at 1:53 pm
If you install the client tools or the entire SQL install you'll get the client configuration utility. You can use that to change the default. Are you having problems connecting with DMO to your server? If so please post your code and we'll try to help!
Andy
March 20, 2002 at 2:38 pm
I am now using msde on my computer, and it did not have any client with it. I think this is the problem, anyway it is strange MS did not put any place where we can chane network protocol. Thanks for helping, Dani
March 20, 2002 at 4:03 pm
I think what you need to change is located in the following registry key:
hkey_local_machine\software\microsoft\MSSQLServer\Client\SuperSocketNetLib
You should find a value there for Protocol order, on my machine it lists it as follows:
tcp np
That corresponds with my settings that have TCP/IP first followed by named pipes.
Possibly there is an easier way, but that might get you going for now.
Andy
March 21, 2002 at 10:17 am
Thanks a lot Andy the registry key was there but i finally find client tools you say at c:\Winnt\system32\cliconf.exe to use TCPIP as default.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply