Hi

[javed007]

i am trying to acces sql-servetr over internet.it gives error [dbnmpntw] connectionopen(creat fie()...) but it's working fine on those m/c that have sql-server installed.

pls help me
my connection string
cn.Open "Provider=SQLOLEDB;DATA SOURCE=host.domain.com;UID=sa;DATABASE=name

 

[DougP]

try this instead

<%
Set Conn = server.CreateObject(&quot;ADODB.Connection&quot
Conn.Open &quot;driver=SQL Server;server=host.domain.com;uid=sa;pwd=password;database=name;&quot;
Set RS1 = Conn.Execute(&quot;SELECT * From yourtable Where ....&quot
%> DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[javed007]

Thanks to reply but the things is sql driver should in client m/c how i can push that driver into cleint m/c

Pls help me