Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    56

    Unanswered: Intranet Set up with SQL server and ASP

    Dear all,

    I am trying to make a Intranet connection with SQL 2000 and ASP,
    but a serious problem in connection string. Please can you help me in this issue

    I am using following connection string.


    (windows authontication)

    Set conn=Server.CreateObject("ADODB.Connection")

    conn.Mode=adModeReadWrite
    conn.Open="PROVIDER=SQLOLEDB;Integrated Security=SSPI;Initial cataloge =nrth;DataSource=server"


    System dsn =nrth
    server name =server


    This string makes following error


    Microsoft OLE DB Provider for SQL Server error '80040e4d'

    Invalid connection string attribute

    //global.asa, line 17

    Microsoft OLE DB Provider for SQL Server error '80040e4d'

    Invalid connection string attribute

    /test2.asp, line


    can you correct this or suggest a valid connection string


    Thank you

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The DSN probably only exists on the one server. Try replacing it with
    Server=servername.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    56
    Originally posted by Satya
    The DSN probably only exists on the one server. Try replacing it with
    Server=servername.

    still having error,

    I am checking it in server itself

Posting Permissions

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