dsn less

Results 1 to 3 of 3

Thread: dsn less

  1. #1
    Sam_ Guest

    Default dsn less

    Hello<BR>There must be something wrong in this code. But where??<BR>I believe the error is caused in the line:<BR>conn.Open strconn<BR><BR>Thank you.<BR>Sam<BR>-------------script.asp ----------------<BR>..<BR>&#060;% <BR>Dim conn, strconn, Classifieds, Query, Category<BR>Category = Trim(Request("Category"))<BR>If Category = "" Then<BR>Response.Write "No Category specified.&#060;p&#062;"<BR> Else<BR> strconn = "DRIVER=Microsoft Access Driver (*.mdb); DBQ=" & Server.MapPath("secma.mdb")<BR> set conn = Server.CreateObject("ADODB.Connection")<BR> conn.Open strconn<BR><BR> Query = "SELECT ItemNum,Bezeichnung,Hersteller,Typ, Baujahr FROM masch "<BR> Query = Query & "WHERE Category=&#039" & Category & "&#039"<BR> Set Classifieds = Server.CreateObject("ADODB.RecordSet")<BR> Classifieds.Open (Query), conn, 2,2<BR><BR>%&#062;<BR>..<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default WHAT is the error??

    Unless you tell us what the error is how will we know

  3. #3
    Sam_ Guest

    Default RE: WHAT is the error??

    &nbsp;<BR>ADODB.Connection.1 error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR><BR>/category.asp, line 19<BR><BR>line 19 is:<BR>conn.Open strconn<BR>

Posting Permissions

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