Remote Access

Results 1 to 4 of 4

Thread: Remote Access

  1. #1
    Fred Guest

    Default Remote Access

    I want to use ASP to Access a SQL 7.0 Database on a remote server (not on my network or location). Basically I want to modify the remote db from my server with ASP written pages. The remote server hosts our web site

  2. #2
    jimmy w Guest

    Default RE: Remote Access

    look up the following link<BR><BR>jimmy w<BR><BR>

  3. #3
    Fred Guest

    Default No Help

    I know about DNS-less connection for a site where the db is in the root web. How do I access a database at the web hosting company (in Texas) from ASP pages on my server (in Chicago)?

  4. #4
    jimmy w Guest

    Default RE: No Help - you're wrong, fred

    Fred,<BR>your Db server can be anywhere. For SQL 7.0 for example, let&#039s say your Chicago DB server&#039s IP is 123.456.789.11 and your DB Name is FredDb, you can connect to it by<BR><BR>connStr="DRIVER={SQL Server};SERVER=123.456.789.11;DATABASE=FredDB;UID= this;PWD=that"<BR><BR>Set Conn=Server.CreateObject("ADODB.Connection")<BR>Co nn.Open connStr<BR><BR>Hope this helps.<BR><BR>jw<BR>

Posting Permissions

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