<<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>

[gndzkdr]

hi all,

i m new on Sql and i have a project related to C# and Sql.

i have to do a project which must work on LAN, and there must be only
one database file on main computer(Server Computer) and other
computers(clien t computers) must connect database on main computer.

i m preparing my project on my personal computer(it is called MYCOMP)
and doing connection with wizard. then it doesnt work on other
computers(works only my personal computer). when i done connection with
wizard .Net create a connection code like below....

// sqlConnection1
//
this.sqlConnect ion1.Connection String = "workstatio n id=MYCOMP;packe t
size=4096;integ rated security=SSPI;d ata source=MYCOM" +
"P;persist security info=False;init ial catalog=migros" ;
i think, because of taking my computer's name in connection string it
doesnt work on other computers...

what can i do for this problem :((((((((

please write me a solution as soon as possible...( i have only 15 days
to hand over and still couldnt start to write my codes, otherwise i
cant graduate....)

PLEASE HEEEEEEEEEEEEEE EELP !!!!!!!

thnks for now......

[Waqar]

dont give ur computer name like mycomp.. try to use localhost instead
of mycomp
and install client connectivity tools of sqlserver on each client.. May
it will solve ur porblem