Very Computer

We are running a VB program (3rd party) that accesses SQL7.

How do we control what network protocol is used to access SQL? (ie. tcp,
named pipes, etc.).

Do we have to install and run the SQL client network utility on each PC?

Thanks,

Quote:> We are running a VB program (3rd party) that accesses SQL7.

> How do we control what network protocol is used to access SQL? (ie. tcp,
> named pipes, etc.).

> Do we have to install and run the SQL client network utility on each PC?

> Thanks,

Paul,

If you are connecting with the ODBC driver, you can also create a DSN to
define the connection.  When configuring the DSN you have the option to
specify the client network library.  If you wanted to do it as a DSNless
conenction, create the DSN as a file DSN, open the file that is generated,
and semi-colon delimit the parms in it to make your connection string.

Having said all that, Carlo's link from to the KB article really spells it
out for you.  It is probably a little more straight-forward.

Bret Stateham

Quote:> If you don't want to install the client network utility, you can hack the
> registry or you could also specify the net lib in the connection string.
> Take a look at this kb article: