You can do it a few ways.

You can open a rs passing the SQL.
You can use a command object as the source for a rs when you open it.
You can execute from the connection object without returning a rs.

So it depends on what you need - rs or not.
Also it depends, if you need a rs, if it needs to be updateable or scrollable.