acessing data from other system on a network

6 Jan 2007 6:50 AM

a.mustaq@gmail.com

Hi,

I have installed sql server in my
system.I have developed a program which have to access the data. I want
to run this program on other sytem.How can I to connect to sql server
on my sytem and store the data entered on that system.please send how
to write connection string.

6 Jan 2007 9:21 AM

Miha Markic [MVP C#]

www.connectionstrings.com

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

<a.mus***@gmail.com> wrote in message

Show quote

news:1168066221.427720.66920@i15g2000cwa.googlegroups.com...
> Hi,
>
>
> I have installed sql server in my
> system.I have developed a program which have to access the data. I want
> to run this program on other sytem.How can I to connect to sql server
> on my sytem and store the data entered on that system.please send how
> to write connection string.
>

6 Jan 2007 6:02 PM

William (Bill) Vaughn

It's not that easy. By default SQL Server is configured to be invisible to
other systems on the network. See my whitepaper on getting connected
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html or
Chapter 9 in my new book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

<a.mus***@gmail.com> wrote in message

Show quote

news:1168066221.427720.66920@i15g2000cwa.googlegroups.com...
> Hi,
>
>
> I have installed sql server in my
> system.I have developed a program which have to access the data. I want
> to run this program on other sytem.How can I to connect to sql server
> on my sytem and store the data entered on that system.please send how
> to write connection string.
>