/build/static/layout/Breadcrumb_cap_w.png

Configuring ODBC in Wise

I need to create an ODBC entry in my package. In my WPS 6.x wsi how can I check whether the user's machine has Oracle 9 or 10? Depending on the version on the user's machine, I need to create an Oracle ODBC entry.

How can I do it from within Wise Package Studio?

0 Comments   [ + ] Show comments

Answers (4)

Posted by: aogilmor 15 years ago
9th Degree Black Belt
0
You will want to use the System Search feature, and populate 2 properties with the registry values unique to versions 9 and 10.
Posted by: aek 15 years ago
Purple Belt
0
registry values unique to versions 9 and 10.

Here is what I have done: created 2 features OracleODBC_9 and OracleODBC_10. Now, I went to ODBC and selected that feature (Eg. In the OracleODBC_9 feature - I created an ODC entry corresponding to Oracle 9 driver. Then I installed Oracle 10 on the machine, and created a ODBC entry and then opened my wsi and for the feature OracleODBC_10, I imported the ODBC entry corresponding to Oracle 10.

Question - Do I need to build a query in my features? Like right now, I have just added those features. Is wise smart enough to detect the Oracle driver on the machine and create the corresponding ODBC config?

Thanks
Posted by: aogilmor 15 years ago
9th Degree Black Belt
0
ORIGINAL: aek

registry values unique to versions 9 and 10.

Question - Do I need to build a query in my features? Like right now, I have just added those features. Is wise smart enough to detect the Oracle driver on the machine and create the corresponding ODBC config?



No, the System Search is itself the query which returns a value to a property. You would build conditions into the components containing the Oracle 9 and 10 ODBC configurations.

Look up conditional syntax in your msi.chm file
Posted by: anonymous_9363 15 years ago
Red Belt
0
I'd make two points:

- Since ODBC junk ends up in the registry, set up your DSN after you've installed whatever flavour of Oracle you need, then export the relevant registry entries to .REG files. Finally, import those .REGs into your WPS project. See also the discussion 'ODBC error 1918'.
- Use SystemSearch along with LaunchCondition.
Note that the default WPS set-up has the LaunchCondition sequenced BEFORE SystemSearch, as sub-optimal an arrangement as is possible to imagine, so alter your WPS template so that SS comes before LC.
For your SS, decide whether you'll detect file, folder or registry entry to determine whether the requisite Oracle flavour is installed and then use the property's content as your LC.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ