473,486 Members | 2,429 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Making connection with sql server

198 New Member
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
3 1082
lotus18
866 Contributor
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
1,445 Recognized Expert Top Contributor
Hi,

For connectionstring,
ConnectionString


Regards
Veena
Nov 22 '07 #3
penzzap
1 New Member
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

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

Similar topics

4
17627
by: Fuzzyman | last post by:
In a nutshell - the question I'm asking is, how do I make a socket conenction go via a proxy server ? All our internet traffic has to go through a proxy-server at location 'dav-serv:8080' and I...
0
2163
by: Clark Laughlin | last post by:
I am trying to establish an SSL connection to our company's LDAP server from an ASP.NET application running on Windows 2003 Server and I am getting the following set of event log errors: Event...
1
2392
by: Chris Langston | last post by:
We are seeing a very frustrating intermittent problem. We are making Synchronious web service method calls from a .NET windows Service using the following syntax WebRequest.getResponse call it...
6
5624
by: David Rasmussen | last post by:
I use urllib2 to do some simple HTTP communication with a web server. In one "session", I do maybe 10-15 requests. It seems that urllib2 opens op a connection every time I do a request. Can I...
2
1894
by: lucifer | last post by:
hi i am making an http server it has following functions main() { if option is "-?", output the hints and stop check the directory supplied is sensible and not a security risk become a daemon...
2
1197
by: Řyvind Isaksen | last post by:
In asp 3.0 I used an procedure (that I included) to save and update articles, like this: <% Sub ConnObj(SQL) set cn = server.CreateObject("ADODB.Connection") cn.Open ConnString cn.Execute SQL...
35
4803
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
0
1382
by: sohail28 | last post by:
I want to make connection to Remote SQL Database table in Macromedia Dreamweaver MX 2004, but whenever i try to connect it, its shows error stating that "550_mmServerScripts:Access denied". what will...
6
1226
by: maghi85 | last post by:
hi, currently i'm using a SQL mdf file that i connect using a connection string. the connection string looks like this "Data Source=.\SQLEXPRESS;AttachDbFilename="c:\databasename.mdf;Integrated...
1
1118
by: john20 | last post by:
Hi All, I have recently installed Sql server 2005 on my machine and i am trying to connect to database for retreiving table information. but it is giving me below error : An error has...
0
7105
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7132
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6846
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7341
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5439
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3076
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3071
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1381
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
600
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.