HOw do connect Sql Server 2000 from client (VB.NET)

i HAVE 2 PC(LAN, server 2003)
pc1-SQL2000 SERVER, net framework 1.1
pc2-ms Visual Studio .NET

      on PC2, I MAKE PROGRAME get data in sqlServer
      run ok, connect,make data OK

but can not run it on pc1 (and any PC on LAN),"error sqlconnection1.open()"
(copy ,MyApp.exe & dataset1.vb.dll from pc2 to pc1 and RUn here)


ConnectionString = "data source=POWER;initial catalog=Accountant;password=123456;persist security info=True;user id=UserAcc;packet size=4096"

LearnITvnAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
VIkasumitConnect With a Mentor Commented:
Hi..

Please give the error message you get in your application...As there are lot of reason that you open statemetn gives an error. Also try adding the Computer's Network name of SQL server to data source like
Data source=pc1\POWER

Also, check the database permission and Network configuration but first let us knwo the name of computer and Error Message

VIkasumit
0
 
Éric MoreauSenior .Net ConsultantCommented:
Is your PC1 name is POWER?

Do you have firewalls?
0
 
LearnITvnAuthor Commented:
NO, I don't have firewalls
0
 
Éric MoreauSenior .Net ConsultantCommented:
Is your PC1 name is POWER?
0
All Courses

From novice to tech pro — start learning today.