Database on different computer behind firewall

Results 1 to 2 of 2

Thread: Database on different computer behind firewall

  1. #1
    Join Date
    Dec 1969

    Default Database on different computer behind firewall

    How can I deposit contact data from an Info. Request Form submitted via the Web to a database in our local area network (behind firewall)? If I put a System DSN on the LAN&#039;s SQL2000 Server, what connection syntax with the database username and password would go through an open port in the firewall into the LAN to update the database? What about security?<BR><BR>In the following, where would I include the computer name or port number to get to the database on different computer inside a firewall on a LAN? What users would have permission on that computer in order to update the database? Do all of them have permission because the user id and password are passed in?<BR><BR>Set objConn=Server.Createobject("ADODB.Connection") <BR>objConn.ConnectionString = "Provider=SQLOLEDB; Data Source=dsnBlahBlah; User ID=abc; Password=xyz" <BR>objConn.Open<BR><BR>How can I find out if the database uses SQL Server Authentication or Integrated Authentication? What is the difference?

  2. #2
    Join Date
    Dec 1969

    Default You need to talk to

    the person incharge of your firewall

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts