Trying to Log into SQL Server server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan
    #1

    Trying to Log into SQL Server server

    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("A DODB.Connection ")
    objConn.Open "Provider SQLOLEDB.1;Inte grated Security=SSPI;P ersist
    Security Info=False;User ID=tester;Passw ord=tester;Init ial
    Catalog=patyo;D ata 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
    Tags: None
    • Curt_C [MVP]
      #2
      Re: Trying to Log into SQL Server server

      Darkfalz.com
      https://www.darkfalz.com/1059



      --
      ----------------------------------------------------------
      Curt Christianson (Software_AT_Da rkfalz.Com)
      Owner/Lead Designer, DF-Software
      Darkfalz.com
      http://www.Darkfalz.com

      ---------------------------------------------------------
      ...Offering free scripts & code snippits for everyone...
      ---------------------------------------------------------


      "Alan" <alan@ugtv.or g> wrote in message
      news:a0fc4032.0 309051505.7193c e57@posting.goo gle.com...[color=blue]
      > 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("A DODB.Connection ")
      > objConn.Open "Provider SQLOLEDB.1;Inte grated Security=SSPI;P ersist
      > Security Info=False;User ID=tester;Passw ord=tester;Init ial
      > Catalog=patyo;D ata 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[/color]


        Comment

        Previous template Next
        Working...