SELECT * mystery

Results 1 to 2 of 2

Thread: SELECT * mystery

  1. #1
    Join Date
    Dec 1969

    Default SELECT * mystery

    I am using an Access 2000 table as my datasource. I am using a connection string as follows:<BR> Conn.Open "Provider= MICROSOFT.JET.OLEDB.4.0;Data Source=D:inetpubwwwrootproject4slsxyz.mdb"<BR><BR> If I use the following SQL statement everything works just great:<BR>strSQL = "SELECT * FROM tblMarkets "<BR><BR>But if I use a statement such as <BR>strSQL = "SELECT rate,expires,building,location FROM tblMarkets WHERE market = &#039" & area & "&#039"<BR>I get the following error message:<BR><BR>error &#039 80004005&#039 <BR>Unspecified error <BR><BR>/project4/sls/markets.asp, line 23 <BR><BR>I KNOW my field/column names are correctly spelled. Strangely, if I use a system DSN, there is no problem. Could the problem be with the Native Provider string?<BR><BR>Thanks!!<BR><BR><BR>

  2. #2 Guest

    Default RE: SELECT * mystery

    Are you sure that there is a field in your db called "market", and is it a text field? <BR><BR>Also check that you have spelt all the other fields, and the table name correctly.<BR><BR>Put a line:<BR>Response.Write strSQL <BR>after your "strSQL = " line. <BR>This will display your SQL text. <BR><BR>You should then copy this text from the browser and run the query in Access and see if it works.

Posting Permissions

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