Hi,



I have a Client VB Application which connects to a remote sql server over 

the internet , well the connection is successful if the default netlibrary 

is set to tcp/ip either using the sql client network utility or by 

creating a dsn which points to the server I wish to connect with the port 

as 1433



But the problem is my client does not have sql server client installed and 

I cannot ask hime to create a dummy dsn which points to my sql server 

(b'coz this app is on the net). Is it possible to programatically set the 

default netlibrary to tcp/ip either by using some odbc api or my modifying 

the registry at the time of my app installation.Also I came across the 

NetLibrary and NetworkAddress property in the connection string but not 

able to use them , can you plz comment on the usage of these properties if 

they can solve this problem.





Thanks



Ammar

Whenever you install MDAC (installed with Internet Explorer), an 

application named cliconfg.exe is installed in your system directory.  Use 

this application to setup your connection.



> Hi,

> 

> I have a Client VB Application which connects to a remote sql server 

over 

> the internet , well the connection is successful if the default 

netlibrary 

> is set to tcp/ip either using the sql client network utility or by 

> creating a dsn which points to the server I wish to connect with the 

port 

> as 1433

> 

> But the problem is my client does not have sql server client installed 

and 

> I cannot ask hime to create a dummy dsn which points to my sql server 

> (b'coz this app is on the net). Is it possible to programatically set 

the 

> default netlibrary to tcp/ip either by using some odbc api or my 

modifying 

> the registry at the time of my app installation.Also I came across the 

> NetLibrary and NetworkAddress property in the connection string but not 

> able to use them , can you plz comment on the usage of these properties 

if 

> they can solve this problem.

> 

> 

> Thanks

>