• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

How can we connect Local Sql Server to Web Server?

How can we connect Local Sql Server to Web Server?


Thanks in advance
0
hc_gupta
Asked:
hc_gupta
  • 2
1 Solution
 
Peter HutchisonSenior Network Systems SpecialistCommented:
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
 
hc_guptaAuthor Commented:
I am using Microsoft SQL Server.And the language is ASP.Net
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now