Results 1 to 4 of 4

Thread: Connect to remote SQL Server (using IP)

  1. Feb 18th, 2002, 04:00 PM #1
    ShIzO
    ShIzO is offline

    Thread Starter
    Addicted Member ShIzO's Avatar
    Join Date
    Apr 1999
    Location
    Bartlett, IL
    Posts
    189

    Connect to remote SQL Server (using IP)

    how would my connection string look if i would want to connect to some remote SQL server using IP address, do i have to open any ports on my firewall??


    thanks,
    www.HardFind.com -buy/sell/trade your used hardware.
    Reply With Quote Reply With Quote
  2. Feb 19th, 2002, 07:21 AM #2
    thinktank2
    thinktank2 is offline
    Hyperactive Member thinktank2's Avatar
    Join Date
    Nov 2001
    Location
    Arctic
    Posts
    272
    The question isn't clear...

    from where and how ??

    Using VB ?
    From an ASP page ?
    From the SQL Server Client Program ?
    Reply With Quote Reply With Quote
  3. Feb 19th, 2002, 09:00 AM #3
    ShIzO
    ShIzO is offline

    Thread Starter
    Addicted Member ShIzO's Avatar
    Join Date
    Apr 1999
    Location
    Bartlett, IL
    Posts
    189
    from ASP, sorry!
    www.HardFind.com -buy/sell/trade your used hardware.
    Reply With Quote Reply With Quote
  4. Feb 19th, 2002, 06:26 PM #4
    thinktank2
    thinktank2 is offline
    Hyperactive Member thinktank2's Avatar
    Join Date
    Nov 2001
    Location
    Arctic
    Posts
    272
    I think, the easiest way is to create a DSN to the remote SQL Server on the IIS system.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width