connect string ASP / SQL EXPRESS

Discussion in 'ASP General' started by shank, Jul 11, 2009.

  1. shank

    shank Guest

    What's the correct connect string for ASP classic and SQL Express installed
    on the same web server? The web host has a control panel that generates the
    below string. But I get this error:

    Multiple-step OLE DB operation generated errors. Check each OLE DB status
    value, if available. No work was done.
    /teststate.asp, line 7 ... which is ... conn.open ConStr


    <%
    Dim ConStr
    ConStr = "Data Source=(local)\sqlexpress;Network Library=;Connection
    Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sth;Encrypt=no;"

    set conn = CreateObject("ADODB.Connection")
    conn.open ConStr
    sql = "SELECT DISTINCT Abbrev, State FROM States ORDER BY State"
    %>

    thanks
     
    shank, Jul 11, 2009
    #1
    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. =?Utf-8?B?Q2FybCBNLg==?=
    Replies:
    4
    Views:
    2,516
    sivlookingforu
    Aug 7, 2006
  2. Gabriel
    Replies:
    9
    Views:
    615
    Juan T. Llibre
    Mar 12, 2007
  3. helveticus
    Replies:
    1
    Views:
    314
    Alexey Smirnov
    Apr 29, 2010
  4. Mike
    Replies:
    0
    Views:
    763
  5. Jake Henderson

    Visual Web Developer 2005 Express and SQL 2005 Express

    Jake Henderson, Mar 10, 2006, in forum: ASP .Net Web Services
    Replies:
    0
    Views:
    261
    Jake Henderson
    Mar 10, 2006
Loading...

Share This Page