473,549 Members | 2,346 Online
Bytes | Software Development & Data Engineering Community
+ 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 1083
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 connectionstrin g,
ConnectionStrin g


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
17656
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 need to make a socket connection through it. The reason (with code example) is as follows : I am hacking "Tiny HTTP Proxy" by SUZUKI Hisao to make...
0
2166
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 Type: Error Event Source: Schannel Event Category: None Event ID: 36870 Date: 10/21/2004 Time: 8:36:21 AM
1
2404
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 occasionally fails with the following error: 1) Exception Information ********************************************* Exception Type:...
6
5629
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 somehow make it use _one_ persistent connection where I can do multiple GET->"receive data" passes before the connection is closed? /David
2
1901
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 process ignore child programs (to avoid zombies when child processes stop)
2
1200
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 cn.Close Set cn = nothing
35
4817
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 string in the web.config. I created a class with a static database connection and the class opens and closes the database.
0
1387
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 be the problem. I created DSN & ODBC, thru Control Panel of my Web Server. I want to Work on Database, for that i wanna to retrieve database...
6
1231
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 Security=True;Connect Timeout=30;User Instance=True" im installing the software in a company that has alot of computers. each computer will have the...
1
1126
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 occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default...
0
7546
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7740
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7985
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7503
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7830
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5387
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5111
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3517
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
784
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.