how to access data through a hosted website from a local database

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hi Everyone,
I have a alredy hosted website and i want to fetch local database of an organisation .In this organisation every day thousand of records are updating ,And i want to fetch all data through website . what to do any body can help me? THANKS IN ADVANCE

Posted 11-May-12 21:01pm

kunalkumarsingh

Updated 11-May-12 21:38pm

v3

Add a Solution

Comments

Sandeep Mewara 12-May-12 3:35am

What for? Why? Are you allowed?

kunalkumarsingh 12-May-12 3:41am

what do u mean by what?why? allowed?

Sandeep Mewara 12-May-12 5:32am

What your question says is you want to fetch data of an organization through your website. Why you want to do that? Is the organization aware of it?

kunalkumarsingh 12-May-12 6:05am

sir,
its single organisation,
curreently i am working in copper production company and has more than 9 department and all departments are connected to the organisation server and every day thousands of records are updating on this.this company has own website and i want to fetch some departments data to the website.can u help me please .
Thanks in advance

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-05-11T23:00:00

Solution 3

Is this a question about How to configure MS SQL Server 2005 to allow remote connections[^] or How to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET[^]?

Posted 11-May-12 23:00pm

Maciej Los

Updated 11-May-12 23:03pm

v2

OriginalGriff · Answer 2 · 2012-05-11T21:22:00

Solution 1

Seriously?
I wouldn't recommend that at all - use MsSql or MySql to access the database instead of direct access to an Acess DB - Access is pretty poor in multiuser, and that is exactly what happens in a website. SQL is designed to handle it, and will give you a lot less odd problems.

Posted 11-May-12 21:22pm

OriginalGriff

Comments

Maciej Los 12-May-12 4:55am

OriginalGriff, I think OP want to fetch data from MS SQL 2005 local server, not from MS Access database...

OriginalGriff 12-May-12 6:03am

Yes. Good.
What's the problem with doing that? What part of that is giving you difficulties?

kunalkumarsingh 16-May-12 1:20am

sir OriginalGriff will you tell me in details.I have problem in this task and i want a solution for this.According to you how to perform this task can you explain me in details with code.

Thanks a lot in advance.

linhlevan · Answer 3 · 2012-05-11T22:59:00

Solution 2

Hi !
if you use sql for your database. You can connect to database throught sql server program. You need ip of server and account to access that database.
Goodluck!

Posted 11-May-12 22:59pm

linhlevan

Comments

kunalkumarsingh 15-May-12 4:21am

sir can you tell me that sql programme .I have IP & ACCOUNT of server .Please..,its seems very difficult for me.Thanks a lot in advaance