Too much geek
What I did was instead of issuing the usual server name whenever you establish a connection via LAN I simply change it to IP address to establish a connection. And bam thats it. I can instantly do the usual code such as insert/update/delete statement. Here's the code:
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dns;Data Source=192.168.0.200"
conn.CursorLocation = adUseServer
See how simplier it is? relax nerdy don't be to harsh to yourself. hehehe