ASP.NET database access Error !

Discussion in 'ASP .Net' started by =?Utf-8?B?a29iZXRpbmc=?=, Feb 22, 2006.

  1. Dear All,

    I have created a webpage which will access a Access MDB file. However,
    there are some problem when I access the MDB file.

    I found that the problem is from SQL statement of OLEDBCommand. For example:
    if I use "Select * from Location", then the ASP.NET applicant can run
    normally; but when I use "Select LocationID from Location", then an exception
    is caught. But the exception message is : "Unknow". So I don't know how to
    fix this problem.

    Could you tell me what is the problem and how to fix it ?

    Thanks.

    P.S. I use Visual Web Developer 2005 to develop this ASP.NET application.
    The MDB file is created by using Access 2003
     
    =?Utf-8?B?a29iZXRpbmc=?=, Feb 22, 2006
    #1
    1. Advertising

  2. No idea if this will help but give Select Location.LocationID from Location a
    bash.

    "kobeting" wrote:

    > Dear All,
    >
    > I have created a webpage which will access a Access MDB file. However,
    > there are some problem when I access the MDB file.
    >
    > I found that the problem is from SQL statement of OLEDBCommand. For example:
    > if I use "Select * from Location", then the ASP.NET applicant can run
    > normally; but when I use "Select LocationID from Location", then an exception
    > is caught. But the exception message is : "Unknow". So I don't know how to
    > fix this problem.
    >
    > Could you tell me what is the problem and how to fix it ?
    >
    > Thanks.
    >
    > P.S. I use Visual Web Developer 2005 to develop this ASP.NET application.
    > The MDB file is created by using Access 2003
     
    =?Utf-8?B?Sm9u?=, Feb 23, 2006
    #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. =?Utf-8?B?a21jY29za2V5?=

    ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO

    =?Utf-8?B?a21jY29za2V5?=, Apr 24, 2007, in forum: ASP .Net
    Replies:
    7
    Views:
    483
    =?Utf-8?B?a21jY29za2V5?=
    Apr 30, 2007
  2. Jay
    Replies:
    2
    Views:
    1,099
  3. Tony Johansson
    Replies:
    7
    Views:
    519
    Gregory A. Beamer
    Dec 23, 2009
  4. kmccoskey
    Replies:
    2
    Views:
    272
    Paul Clement
    Apr 27, 2007
  5. william

    Access remote access database from ASP

    william, Feb 10, 2004, in forum: ASP General
    Replies:
    5
    Views:
    141
    william
    Feb 13, 2004
Loading...

Share This Page