Results 1 to 2 of 2

Thread: OLEDB and ADO??

  1. #1
    Join Date
    Dec 1969

    Default OLEDB and ADO??

    Hi<BR><BR>I have some problems when I connect to SQL Server 7.0 the OLEDB way (as described in the "OLEDB For Me" article).<BR><BR>If I do like this:<BR><BR>rs.Open SQL, Conn, adOpenKeySet, adLockPessimistic<BR>rs.AddNew<BR>rs("Field1") = Value1<BR>rs("Field2") = Value2<BR>rs.Update<BR>intID = rs("ID") &#060;-- HERE IS THE PROBLEM<BR>rs.Close<BR><BR>The server returns a message saying the it&#039s unavailbale to determine the ID of the currently inserted record.<BR><BR>I&#039ve no problems when I connect via. ADO<BR><BR>Anyone know why?<BR><BR>Best regards<BR><BR>Dennis

  2. #2
    Jason Miller Guest

    Default RE: OLEDB and ADO??

    try a straight execute of "insert into tableName (field1, field2) values (val1, val2)"

Posting Permissions

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