By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,059 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

Making connection with sql server

100+
P: 198
hello expert
i am making a project, i want to connect a sql server which is on my LAN network and access its data from the database
i know how to connect with sql server which is on my own machine but i have no idea about how to connect with server which is on my LAN Network
so please send some code or idea so that i can access the data from sql server
thanks
Nov 22 '07 #1
Share this Question
Share on Google+
3 Replies


lotus18
100+
P: 866
hello expert
i am making a project, i want to connect a sql server which is on my LAN network and access its data from the database
i know how to connect with sql server which is on my own machine but i have no idea about how to connect with server which is on my LAN Network
so please send some code or idea so that i can access the data from sql server
thanks
There are a lot ways on how to connect the sql server and shared it over the LAN network. You can use file dsn or system dsn.

Hope it helps : )
Nov 22 '07 #2

QVeen72
Expert 100+
P: 1,445
Hi,

For connectionstring,
ConnectionString


Regards
Veena
Nov 22 '07 #3

P: 1
There are a lot ways on how to connect the sql server and shared it over the LAN network. You can use file dsn or system dsn.

Hope it helps : )
No code is needed as long as you know of how to connect it to your SQL in your local machine.

Connecting to SQL on your machine is the same way connecting it to LAN but you have to implement the connection by creating a Local Administrator Account on your machine.

Example: If the SQL machine on your LAN has
Username: MyServer
Password: Server1

In your machine create the same local computer account t
Username: MyServer
Password: Server1

Try it.
Feb 6 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.