Creating ODBC in Solaris env

[boris]

How to set up an ODBC connection on the server (Solaris).
Thanks

[mhester]

I believe if you search this forum you will find your answer. This information is also covered in your DS documentation.

Regards,

Michael Hester

[nag0143]

In order to call on database servers via the ODBC stage, you have to enter the information in two places:

uvodbc.config (located in the projects directory) and odbc.ini(located as hidden file in the ./dshome)

in uvodbc.config
To get to any ODBC source other than UniVerse, you need entries
that look as follows (the data source must also be configured
via the operating system's own mechanisms):

<data source name>
DBMSTYPE = ODBC

in odbc.ini
for oracle (for example)
Driver=
Description=Oracle9
ServerName=oraclehost
LogonID=
Password=

HTH, i have done this long time back... may be i am missing something this should be close.

Thanks
Nag

[lax1996]

Even I face the same problem and unable to connect remote oracle server from datastage server.

I need ur guidance in this regard

Thanx

In order to call on database servers via the ODBC stage, you have to enter the information in two places:

uvodbc.config (located in the projects directory) and odbc.ini(located as hidden file in the ./dshome)

in uvodbc.config
To get to any ODBC source other than UniVerse, you need entries
that look as follows (the data source must also be configured
via the operating system's own mechanisms):

<data source name>
DBMSTYPE = ODBC

in odbc.ini
for oracle (for example)
Driver=
Description=Oracle9
ServerName=oraclehost
LogonID=
Password=

HTH, i have done this long time back... may be i am missing something this should be close.

Thanks
Nag

[ray.wurlod]

Red Brick Warehouse is different. In this case, the driver manager searches for $RB_CONFIG/odbc.ini.