'Unspecified Error' When attempting to inp

Results 1 to 2 of 2

Thread: 'Unspecified Error' When attempting to inp

  1. #1
    KKing Guest

    Default 'Unspecified Error' When attempting to inp

    I have used this same script for other elections and they still work. This one, however is giving me an &#039unspecified error&#039 on the last line of this script. Any suggestions?<BR><BR>strDatabaseLocation = "D:elections.mdb"<BR>set electionsDB = Server.CreateObject("ADODB.Connection")<BR>set CmdAddRecord = Server.CreateObject("ADODB.Recordset")<BR><BR>elec tionsDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;Data Source=" _<BR> & strDatabaseLocation<BR> electionsDB.Open<BR> strSQL = "SELECT * FROM Local " & "ORDER BY ID"<BR> <BR>CmdAddRecord.Open strSQL, electionsDB, 1, 3<BR><BR>Thanks<BR>KKing<BR>TVEditboy8@aol.com

  2. #2
    Join Date
    Dec 1969

    Default RE: 'Unspecified Error' When attempting to

    instead of this:<BR><BR>strSQL = "SELECT * FROM Local " & "ORDER BY ID"<BR><BR>CmdAddRecord.Open strSQL, electionsDB, 1, 3<BR><BR><BR>do this:<BR><BR>CmdAddRecord.Open="SELECT * FROM Local ORDER BY ID"<BR><BR>it works the same...<BR><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