Function to Connect to SQL - where to put it

[ker9]

Hi,
I have a workbook that has several modules that make calls to the SQL database. I have a function defined for the connection string. The function is at the top of the module. There are two different connection strings (so 2 diff functions). I wanted to put both functions in a single location, but when I don't have it at in the module I get an "ambiguous name" error.

What would be the right way to handle this?

Thanks!

EDIT: I finally figured out that what I really need to do is to define the connection strings as Constants (example below)

Please Login or Register  to view this content.