Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: connect to server via intranet - how is it done (new to this)

    Hi all!

    I have msde2000 on one machine. want to connect to it from other machine. both machines are connected via a switch with integrated firewall.

    Do I need to set up this firewall to enable connections? Like opening ports for msde in the virtual servers settings of the firewall?

    If I do this, will that make my sql-server visible and accessible to the internet?

    Or should I be able to find my sql server without such steps. And if so how?

    networking is up and i can access folders of both machines via the intranet. Is that enough or do i need more settings here?

    Let's say the machine and thus the server is called Alpha. What goes into my connectionstring from the other machine?

    this wont be enough, right?
    strconn = "Provider=SQLOLEDB;" & _
    "Data Source="Alpha";"

    Please shed some light on these questions.



  2. #2
    Join Date
    Feb 2002
    Assam, India


    First you will have to configure the ODBC settings in your machine. Make sure the datasource name is "alpha" , the same as the server name. You can then use "alpha" in the connection string. The code that is required is

    'VB Code starts here

    Set db = New ADODB.Connection

    db.Properties("Data Source").Value = "alpha"
    db.Properties("Initial Catalog").Value = "Northwind"
    db.Properties("User ID").Value ="XXX"
    db.Properties("Password").Value = "YYYYY"

    'ASP Code starts here
    Set db = Server.CreateObject("ADODB.Connection")
    db.Open "Provider=SQLOLEDB;Data Source=alpha;Initial Catalog=Northwind;User Id=XXX;Password=YYY"


    Roshmi Choudhury
    Last edited by Roshmi Choudhury; 09-22-04 at 02:25.

Posting Permissions

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