Solved

How can we connect Local Sql Server to Web Server?

Posted on 2013-10-30
3
265 Views
Last Modified: 2013-11-15
How can we connect Local Sql Server to Web Server?


Thanks in advance
0
Comment
Question by:hc_gupta
  • 2
3 Comments
 
LVL 19

Expert Comment

by:Peter Hutchison
ID: 39611302
A bit more information is required. Is it a MySQL server or Microsoft SQL Server?
Is it an IIS web server or an Apache web server?
What language are you using on web pages? ASP, ASPX, PHP, Perl, Java?
For non-Microsoft scripting, you need to use FreeTDS add-on to connect to SQL databases:
http://freetds.schemamania.org/
0
 

Author Comment

by:hc_gupta
ID: 39613383
I am using Microsoft SQL Server.And the language is ASP.Net
0
 
LVL 19

Accepted Solution

by:
Peter Hutchison earned 500 total points
ID: 39616159
If using asp.net then you can use the ADODB v7 objects to connect to sql.
e.g.
USe ADODB.Connection to create a connection to a SQL database.
Use ADODB.Command to send commands to a SQL server.
Use ADODB.Recordset to store SQL table contents.
Use connection.Open to open a SQL table
use table.AddNew to add a row to SQL table
use table.Fields("name") to get or set fields in a table
Use table.Update to write changes to a table.
etc.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question