I am running SQL and I usually pass the DSN for my connection through a property, Ex:

SQLCONN(.mcOdbc,"userid","password").

Most of the time I hard code the connection name into the form property.

The thing is we are going to production so I pull the DSN from a table and then store it to a propety, but I get the following error when I do this: "Driver not found,DSN name not found".

How come, when I hard code the DSN name to the property I get my connection, but when I store it from a field Ex: .mcOdbc = admin.connection.
and I run SQLCONN(.mcOdbc,"userid","password"), I get the above error?