GET ODBC SUBSCRIPT connect string

[MKui]

The CONNECT string in GET ODBC SUBSCRIPT() is hard coded in the model. When we package the model to a vpmx and distribute the model where the database is on a other location that doesn't work. We like the path to the database in the connect string to be flexibel, so it can be speficied outside the model.

[Administrator]

One of the limitations of GET ODBC SUBSCRIPT is that it cannot be used in the model reader. So if you do want to distribute the model and use this function, the other users will need Vensim DSS as well.

You can use a string variable to store the connect string. This can then be set using a CIN file.

[MKui]

Will this also work when we publish the model in DSS to a vpmx and make it only readable by DSS?

[Administrator]

It should. But if you are distributing the model, you will need to hard code the subscript ranges into it.