Hi Programmers

[javed007]

I am trying access sql-server thru tcp/ip netware library. i canfigure properly to tcp/ip netware library. below connectoion string is working fine with those m/c that have sql server installed

connectio string is
cn.Open &quot;driver=SQL Server;server=host.domain.com;uid=<name>;password=<password>database=<database name>&quot;
but it gives error to those m/c that have'nt sql server intalled

error is : [microsoft [odbc sql server driver] client unable to establish connection

javed

 

[balor]

Try this connectionstring:

cn.open = &quot;Provider=sqloledb;Data Source=<Servername>;Initial Catalog=<Database>;User Id=<UserId>;Password=<Password>&quot;