p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

activex_data_objects thread: ADO Connection Problem w Remote SQL Server


Message #1 by "Ammar Electricwala" <ammarne@y...> on Mon, 9 Apr 2001 06:53:09
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
Message #2 by dtremblay@t... on Wed, 18 Apr 2001 16:26:33
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

> 


  Return to Index