target folder & odbc datasource

iso96 · Post by **iso96** » Fri Jan 25, 2008 4:37 pm

Hello,

Hope somebody can help me with this.

On installation i would like the user to be able to browse to a specific location instead of C:\\Program Files. This new location needs then to be set within the odbc datasource attributes

DBQ=C:\\Program Files\\xxx\\yyydb.mdb
FIL=MS Access
UID=

thankyou for looking

regards

lance

iso96 · Post by **iso96** » Wed Jan 30, 2008 4:21 am

can nobody help on this!

is it not possible in installware? i would have thought this was a common problem!

thanks

lance

Roostar2004 · Post by **Roostar2004** » Wed Jan 30, 2008 2:38 pm

Have you tried using the variable $TARGETDIR$ this si the variable that get populated when the user chose which directory they would like to install it. So in the case of c:\\Program Files\\Application $TARGETDIR$ would = c:\\Program Files\\Application. This is what my company uses for our registry keys so I would imagine it would work the same with ODBC.I hope this helps.

iso96 · Post by **iso96** » Thu Jan 31, 2008 4:56 am

thanks roostar

thats exactly what i was after the only difference is within the odbc you use sq brackets instead of $$

thanks again

Roostar2004 · Post by **Roostar2004** » Mon Feb 04, 2008 10:04 am

No problem glad I could help.

target folder & odbc datasource

target folder & odbc datasource

Try this.