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
Solved! Go to Solution.
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.
/Alex [Community Champion]
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.