Got "Incorrect syntax near 'NULLDROP'" when trying to connect to DB
I got error "Incorrect syntax near 'NULLDROP'" when my codes were trying to run DBConnection.Open
I have verified my code works when the query is quick, it only failed because this specific query was taking about 30 secs to return results. Does anyone know how I can fix this issue? Thanks in advance!
Set DBConnection = ADO.CreateADOQuery
DBConnection.ConnectionString = xxxxxxxxxxxx
DBConnection.SQL = QueryToRun
If I remember it right, pure ADO has a property named like Timeout. Try to check if it is provided by the ADO object in TestComplete.
If it is not, double-check with ADO documentation on MS site if my memory is correct and consider to port your code from TestComplete's ADO object to pure native ADO.