Problem passing Connection string in Sub

[j_Southern]

I want to use the following procedure to operate an ODBC link

Please Login or Register  to view this content.

But I get a compile error at line 10 "A constant expression is required"
When I use an ADODB connection all I need is to Dim ConStr as String
I am trying to use sub oldSQL for three different databases all with different ConStr.
The ODBC one defeats me because I don't know how to give the constant SAGECONN1 its string value, at least I think that's it. Can someone point me in the right direction please?
John

Moderator's Note: Please use titles that describe your question. I have changed your title to reflect the question.

[CK76]

Just Dim SAGECONN1 as string. It isn't a constant from your description "...for three different databases all with different ConStr."

Try...

Please Login or Register  to view this content.