Professional Web Applications Themes

Unspecified error with JET 4.0 - ASP Database

I've tried using this connection string which works fine: conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\clients\awt326\db\db127\store.md b" set con = Server.CreateObject("ADODB.Connection") con.open(conString) However, I keep getting an unspecified error on the line "set cat = con.Execute(sqlString,,1)" in the following: Set cat = Server.CreateObject( "ADODB.Recordset" ) sqlString = "SELECT * FROM categories Order By Position" set cat = con.Execute(sqlString,,1) Whereas this works without a problem?!?! Set welcome = Server.CreateObject( "ADODB.Recordset" ) sqlString = "SELECT * FROM welcome WHERE Key=1" set welcome = con.Execute(sqlString,,1) Is it me or are they the same thing, why is one not working?! I've tried changing the order etc. with ...

  1. #1

    Default Unspecified error with JET 4.0

    I've tried using this connection string which works fine:

    conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
    Source=C:\inetpub\clients\awt326\db\db127\store.md b"
    set con = Server.CreateObject("ADODB.Connection")
    con.open(conString)



    However, I keep getting an unspecified error on the line "set cat =
    con.Execute(sqlString,,1)" in the following:

    Set cat = Server.CreateObject( "ADODB.Recordset" )
    sqlString = "SELECT * FROM categories Order By Position"
    set cat = con.Execute(sqlString,,1)



    Whereas this works without a problem?!?!

    Set welcome = Server.CreateObject( "ADODB.Recordset" )
    sqlString = "SELECT * FROM welcome WHERE Key=1"
    set welcome = con.Execute(sqlString,,1)



    Is it me or are they the same thing, why is one not working?! I've tried
    changing the order etc. with no joy!

    Greg.


    Greg Guest

  2. #2

    Default Re: Unspecified error with JET 4.0

    I've got it, reserved words somewhere... needed square brackets around
    something so I just put them around everything and it works?! What's the
    reserved word? Position? categories?

    Greg

    "Greg" <com> wrote in message
    news:phx.gbl... 


    Greg Guest

  3. #3

    Default Re: Unspecified error with JET 4.0

    http://www.aspfaq.com/2080

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Greg" <com> wrote in message
    news:#phx.gbl... 
    >
    >[/ref]


    Aaron Guest

Similar Threads

  1. unspecified error
    By mathieu.page@gmail.com in forum ASP.NET Web Services
    Replies: 0
    Last Post: October 19th, 07:55 PM
  2. Unspecified Error
    By 3legs in forum Macromedia Flash
    Replies: 3
    Last Post: November 29th, 12:06 PM
  3. Unspecified error '80004005'
    By MY Cheng in forum ASP Database
    Replies: 1
    Last Post: June 16th, 01:22 PM
  4. Replies: 4
    Last Post: October 22nd, 10:02 AM
  5. Unspecified error using FSO
    By Tim Williams in forum ASP
    Replies: 0
    Last Post: July 6th, 07:41 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139