Hi Lee,
My problem was the Service Pack for MS SQL SERVER 2000. After I update It
worked fine when SQL Server 2000 reside on Win XP SP2 machine. I use this
machine as test mechine.
So after I search I found that If you connect SQL Server that resides on WIN
XP Pro with SP2 that means the Firewall is on than you cannot connect. Unless
you turn WIN XP PRO SP2 firwall to off mode. Than it connected. Than I search
and find the article (I posted previously) that I should adjust the setting
of the 2 machine to connect to SQL Server while WIN XP PRO SP2 Firewall in
the ON mode.
Now everythings fine with me expect the problem having in log In section.
I posted my problem how to convert SQL Server Binary data type to string and
string to Binary data type that I can store in SQL Server back when admin
people can register the new user.
If I mange this I will try to write small article about Employee application
that will be secure to connect to SQL Server for a small scale companies.
Thank you.
Rgds,
GC
"Lee" wrote:
I use this all the time to connect to any sql server using a .NET
SQLConnection...
"Server=190.168.0.97;Database=DBank;Trusted_Connec tion=No;UID=myuid;PWD=mypwd;"