GET ODBC SUBSCRIPT connect string
GET ODBC SUBSCRIPT connect string
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.
-
- Super Administrator
- Posts: 4608
- Joined: Wed Mar 05, 2003 3:10 am
Re: GET ODBC SUBSCRIPT connect string
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.
You can use a string variable to store the connect string. This can then be set using a CIN file.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: GET ODBC SUBSCRIPT connect string
Will this also work when we publish the model in DSS to a vpmx and make it only readable by DSS?
-
- Super Administrator
- Posts: 4608
- Joined: Wed Mar 05, 2003 3:10 am
Re: GET ODBC SUBSCRIPT connect string
It should. But if you are distributing the model, you will need to hard code the subscript ranges into it.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559