Oracle Error

Results 1 to 2 of 2

Thread: Oracle Error

  1. #1
    Join Date
    Dec 1969

    Default Oracle Error

    I am attempting to retrieve data from an Oracle database. I am modifying code that I have successfully used with Access. I seem to be making a successful connection to the Oracle database, but I am getting an error when running my SQL statement. This is the code:<BR><BR>set oConn = server.CreateObject("adodb.connection")<BR><BR>oCo nn.ConnectionString = "Provider=OraOLEDB.Oracle;User ID=fldb;Password=fldb; Data;"<BR><BR>oConn.Open<BR><B R>set oRS = server.createobject("ADODB.recordset")<BR><BR>oRS. open "select * from Users where Username = &#039;" & (Request.Form("username")) & "&#039;;", oConn<BR><BR><BR>The last line ( is returning this error:<BR>OraOLEDB error &#039;80040e14&#039; <BR><BR>ORA-00911: invalid character <BR><BR>/fldb/fldb_login.asp, line 93<BR><BR><BR>I&#039;m very new to Oracle. Anyone have experience with this error?<BR><BR>Thank you,<BR>Mike<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Oracle doesn't need the semicolon... the end of the query.

Posting Permissions

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