I want to query a Deltek GCS database. I would like to supply the query inside of my VBA code, instead of invoking a query on the cloud that I am connecting to.

1. Is there a function to create an ODBC connection?
2. What parameters will I need to supply besides userid and password?