Redbrick List Forum

Automatic ODBC-DSN installation and configuration

Posted By:
Date:

Hi everybody,

I'm trying to automate the installation of the odbc-client and the
configuration of a System-DSN on win2k-odbc. I found some basic informations
and played around. I didn't find more information in the "installation and
conectivity guide" so here are my questions:

- which of the two dll's is Driver and which one is setup? (rb32odbc.dll or
rb32odin.dll)
- what are the (possible) configuration parameters (<Parameter_key> and
<Parameter_value> for the driver setup)?
- what is the parameter for giving the username? (in the CONFIGDSN part)

Here is how far I am now (all placed in a batch file):

odbcconf /S INSTALLDRIVER "Red Brick (32)
Driver|Driver=????.dll|Setup=????.dll"
odbcconf /S CONFIGDRIVER "<Parameter_key>=<Parameter_value>"
odbcconf /S CONFIGSYSDSN "Red Brick (32) Driver"
"DSN=test_rb|SERVER=10.16.20.30:5050|Database=test"

Thanks in advance,

Lars Brade

Würth IT International
Business Intelligence & Data Warehouse
Drillberg 6
97980 Bad Mergentheim
Germany

Telefon: +49 7931 916 - 285
Telefax: +49 7931 917 - 285
Email: lars.brade@wuerth-it.com
Internet: www.wuerth-it.com

Messages In This Thread

• Automatic ODBC-DSN installation and configuration
  Brade Lars -- Tuesday, 25 March 2003, at 3:26 a.m.
  • RE: Automatic ODBC-DSN installation and configuration
    Gregory, Mark -- Tuesday, 25 March 2003, at 8:08 a.m.

Redbrick List Forum is maintained by Administrator with WebBBS 5.12.