How to set up an ODBC connection on the server (Solaris).
Thanks
Creating ODBC in Solaris env
Moderators: chulett, rschirm, roy
I believe if you search this forum you will find your answer. This information is also covered in your DS documentation.
Regards,
Michael Hester
Regards,
Michael Hester
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
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
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
oracle connectivity
Even I face the same problem and unable to connect remote oracle server from datastage server.
I need ur guidance in this regard
Thanx
I need ur guidance in this regard
Thanx
nag0143 wrote: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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: