dbTalk Databases Forums  

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

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>> in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>> - 04-03-2006 , 03:14 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......


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>> - 04-03-2006 , 04:31 PM






Hello g n d z k d r,

You may well be better on a C# newsgroup than this one.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
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......




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.