Error 3709 
Author Message
 Error 3709

I get an error 3709 with the following code.Private Sub
cmdCallerSearch_Click()

    Dim adoPrimaryRS As Recordset
    Dim db As Connection

    Set db = New Connection
    db.CursorLocation = adUseClient
    db.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Initial Catalog=NWSCBase;Data Source=olympus"

    Set adoPrimaryRS = New Recordset
    adoPrimaryRS.Open "Select c.curdate 'Date', c.eventnumber 'Event',
p.fname + ' ' + p.lname 'Consultant', p2.fname + ' ' + p2.lname
'Caller', sy.symptomdescription 'Symptom', c.partno 'Part No.',
c.problemdescription 'Problem', c.solutiondescription 'Solution',
c.isissue 'Known Issue' , c.issuenumber 'Issue No.', c.isescalated
'Escalation', c.agreeescalation 'Escalation Agree',
c.manufacturingissue 'Mfg. Issue', c.toolsissue 'Tools Issue',
c.agreeRPL 'RPL Agree'  FROM consultlog c JOIN personnel p on(p.IdKey
=c.ConsultantId) JOIN personnel p2 on (p2.IdKey = c.CallerID) JOIN
systems s on (s.SystemId = c.SystemId) JOIN operatingsystem o on
(o.OsKey = c.OsKey) JOIN manufacturer m on (m.ManufacturerId =
c.ManufacturerId) JOIN symptom sy on (sy.SymptomId = c.SymptomId)
WHERE c.CallerId =" & dataCaller.BoundText & ", db, adOpenDynamic,
adLockOptimistic"

    Set frmResults.grdDataGrid.DataSource = adoPrimaryRS

    mbDataChanged = False

    db.Close

    frmResults.Show vbModal

End Sub

Can anyone see what is wrong with this and let me know ASAP.  Thanks



Mon, 15 Nov 2004 02:17:34 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Help! RunTime Error 3709

2. Intermittent ADO connection errors (3709) on Win98 machine

3. error 3709 search key not found

4. ADO, ACCESS, ERROR 3709

5. Closed Or Invalid Connection Error 3709

6. Ado error 3709

7. Error 3709 - The search key was not found in any record

8. ADO error 3709

9. Run Time Error 3709

10. Error 3709 When using RS.OPEN (url)

11. Help! Runtime error 3709

12. Run-time error '3709'


 
Powered by phpBB® Forum Software