OLEDB Query Time Out Error

[TimothyLong]

I keep getting the below error when trying to execute an SQL query via OLEBD. The query is fully optimized. Has anyone else had this issue?   Could not execute code stage because exception thrown by code stage: [00000] [Native Code: 30149] [ASEOLEDB]The command has timed out.

[John__Carter]

Sounds like the default timeout may not be long enough and you need to specify a bespoke value via the connection string. You'll need to research the correct syntax but it will be something like Connect Timeout=60

[TimothyLong]

I've tried various syntax and that does not seem to resolve the issue