Trying to Log into SQL Server server

Discussion in 'ASP General' started by Alan, Sep 6, 2003.

  1. Alan

    Alan Guest

    I'm new to ASP, so I'm sorry if this is a dumb question.
    I'm trying to log into our SQL Server using ASP. Here's what I've got
    so far.

    Set objConn=Server.CreateObject("ADODB.Connection")
    objConn.Open "Provider SQLOLEDB.1;Integrated Security=SSPI;Persist
    Security Info=False;User ID=tester;Password=tester;Initial
    Catalog=patyo;Data Source=WEB04WIN"

    The error I get is:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no
    default driver specified
    /projects/project_search_results.asp, line 72

    I've tried every hook up I can think of and nothing works. Is there
    something wrong with the code or our server. We set it up ourselves
    so I wouldn't be surprised.

    Let me know,
    Alan
    Alan, Sep 6, 2003
    #1
    1. Advertising

  2. Alan

    Curt_C [MVP] Guest

    www.darkfalz.com/1059


    --
    ----------------------------------------------------------
    Curt Christianson (Software_AT_Darkfalz.Com)
    Owner/Lead Designer, DF-Software
    http://www.Darkfalz.com
    ---------------------------------------------------------
    ...Offering free scripts & code snippits for everyone...
    ---------------------------------------------------------


    "Alan" <> wrote in message
    news:...
    > I'm new to ASP, so I'm sorry if this is a dumb question.
    > I'm trying to log into our SQL Server using ASP. Here's what I've got
    > so far.
    >
    > Set objConn=Server.CreateObject("ADODB.Connection")
    > objConn.Open "Provider SQLOLEDB.1;Integrated Security=SSPI;Persist
    > Security Info=False;User ID=tester;Password=tester;Initial
    > Catalog=patyo;Data Source=WEB04WIN"
    >
    > The error I get is:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > [Microsoft][ODBC Driver Manager] Data source name not found and no
    > default driver specified
    > /projects/project_search_results.asp, line 72
    >
    > I've tried every hook up I can think of and nothing works. Is there
    > something wrong with the code or our server. We set it up ourselves
    > so I wouldn't be surprised.
    >
    > Let me know,
    > Alan
    Curt_C [MVP], Sep 6, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Henrik_the_boss
    Replies:
    0
    Views:
    2,643
    Henrik_the_boss
    Nov 5, 2003
  2. Amratash
    Replies:
    0
    Views:
    517
    Amratash
    Apr 13, 2004
  3. =?Utf-8?B?VG9tIFdpbmdlcnQ=?=

    My.Log.Writeexception not writing to Application Event Log.

    =?Utf-8?B?VG9tIFdpbmdlcnQ=?=, Jan 20, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    2,369
    =?Utf-8?B?VG9tIFdpbmdlcnQ=?=
    Jan 20, 2006
  4. Harry Zoroc
    Replies:
    1
    Views:
    930
    Gregory Vaughan
    Jul 12, 2004
  5. vj
    Replies:
    0
    Views:
    677
Loading...

Share This Page