Guys, I solved the problem by figuring out that my Personal Web Server and SQL Server should be on the same physical box because the asp file is coded not...

Guys, I have finally found a solution to my the connection problem. Thanks for all the efforts to help.

Here is the code:

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "WFS"