Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    47

    Unanswered: SQL Server 7.0 Beta/Testing ASP Application

    Hi Group,
    I'm trying to test an ASP application in 'isolation' and seem to be having problems with connecting to the Server.
    The setup is EXACTLY like the production environment except for the fact that I am using the Beta version of SQL.

    The error refers to SQL Server not existing. I get this error also if I try to open the Query Analyzer without FIRST starting the Services via the Service Manager - so I think it is probably something wrong with the Beta Installation rather than using the BETA version as a back-end.

    I've tried using the Computer name as the Server to connect to as well as 127.0.0.0 - neither seem to want to connect.

    I can connect manually and see the Database objects. I've even connected, left the connection open and tried running the application again. I still get the same error.


    Has anyone experienced this before? i.e not being able to connect to a BETA version of SQL to test an ASP application locally.



    TIA

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the connection string used to connects SQL server from ASP?

    http://www.sql-server-performance.co...ling_myths.asp for information on connection pooling.

    http://www.devarticles.com/c/a/ASP/T...-2000-Via-ASP/ - ways to connect.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2004
    Posts
    47
    strConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Performance;Data Source=127.0.0.0"

    Originally posted by Satya
    What is the connection string used to connects SQL server from ASP?

    http://www.sql-server-performance.co...ling_myths.asp for information on connection pooling.

    http://www.devarticles.com/c/a/ASP/T...-2000-Via-ASP/ - ways to connect.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

Posting Permissions

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