Home > Archive > MS SQL Server > April 2006 > <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

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

2006-04-03, 8:23 pm

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(client 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.sqlConnection1.ConnectionString = "workstation id=MYCOMP;packet
size=4096;integrated
security=SSPI;data source=MYCOM" +
"P;persist security info=False;initial 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 HEEEEEEEEEEEEEEEELP !!!!!!!

thnks for now......

Jens

2006-04-03, 8:23 pm

Hi, no need to multipost.

Answered in .programming.


HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com