Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    16

    Unhappy Unanswered: IIS virtual directory - what to do?

    Why why why do I get the message "an error occured connecting to the server 'servername'. This server does not exist or is unavailable" when trying to connect to a server in IIS. I know the server exists (it's the same computer I'm using) and that is up and running. Also, why do I need to connect, can I use the SQLXML features without a virtual directory? I have no need to access my DB from the Internet.
    Thank you,
    Helena

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Hi

    Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

    Is the SQL server oyu are trying to connect to the default instance or a named instance?

    Are you using OLEDB or ODBC connection to SQL from IIS?

    Cheers

    SG

  3. #3
    Join Date
    Sep 2003
    Posts
    16
    Yes, the SQL account exists.

    The server I'm trying to connect is a named instance. (But it should be the default as well since i only have one server?)

    I have no idea whether I use OLEDB and ODBC connection, how do I know..?

    Thank you, Helena


    Originally posted by sqlguy7777
    Hi

    Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

    Is the SQL server oyu are trying to connect to the default instance or a named instance?

    Are you using OLEDB or ODBC connection to SQL from IIS?

    Cheers

    SG

  4. #4
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Hi Helena,

    If you are using OLEDB ( i.e a DSN-less connection ) you will see the connection string like this in your ASP page :

    Connection.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQLADMIN1;UID=testiis1sql;PWD=password;DATA BASE=ServerMon"

    If you had an ODBC ( i.e. a DSN connection ) it would look like this :

    "Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyP assword;"

    see also :
    http://msdn.microsoft.com/library/de...roviders_2.asp

    See also :

    http://www.able-consulting.com/MDAC/...rODBCDatabases

    What does your connection look like?

    Cheers

    SG.

Posting Permissions

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