Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 connecting SQl 2000 through Visual Basic

Author  Topic 

shakumar_21
Starting Member

1 Post

Posted - 2008-03-25 : 06:56:03
Hi

i created database in MSSql Server 2000, and i can access all the table in database(select,delete,update..)through Visual Basic.

i want to access this database table from another computer .

how i can do,is it Sql server issue or Visual Basic issue.

regards
shakumar

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-25 : 06:58:51
Make sure another computer (say PC02) is on network and you can access SQL server using query analyzer from PC02.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

Imukai
Starting Member

29 Posts

Posted - 2008-03-31 : 08:02:20
If you have a firewall on the SQL Server box, make sure port 1433 (or whichever port you configured when setting it up) is open to that 2nd computer otherwise you will fail to connect.
Go to Top of Page
   

- Advertisement -