Ask a Question

Got "Incorrect syntax near 'NULLDROP'" when trying to connect to DB

SOLVED
whuang
Regular Contributor

Got "Incorrect syntax near 'NULLDROP'" when trying to connect to DB

Hi there,

 

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
DBConnection.Open

3 REPLIES 3
AlexKaras
Champion Level 3

Hi,

 

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.

 

Regards,
  /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.
https://community.smartbear.com/t5/Community-Champions/About-the-Community-Champions-Program/gpm-p/252662
================================
sonya_m
SmartBear Alumni (Retired)

Thank you, Alex!

 

@whuang does this help?


Sonya Mihaljova
Community and Education Specialist

whuang
Regular Contributor

Thanks for the help. It actually turns out the issue was in my query, my script was fine.

cancel
Showing results for 
Search instead for 
Did you mean: