Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: IIS/MS SQL/ASP... can't connect

    I have an ASP script with the following code in the global.asa:

    Code:
    Application("DBConnectString")="DSN=Test_Server;UID=Michael;PWD=xxxx"
    But I get the error:

    Code:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    /TheResort/i_asputils.asp, line 8
    Problem:

    I setup the ODBC portion and it correctly saw the MS SQL server, and the test connection worked fine. Yet when I ever I enter that ODBC name "Test_Server", and the password of the Win XP Pro user I am signed in as, it fails to connect.

    How can I be sure what domain,user,password I need to enter?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ttry using "DSN=asset;UID=;PWD=" and don't forget to insert the user id and password.

    Also, when you set up the odbc "system" dsn, remember to click on the test connection button to verify the connection.

    http://www.google.com/url?sa=U&start.../77.asp&e=7415 information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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