how to configure an odbc connection on unix
Moderators: chulett, rschirm, roy
how to configure an odbc connection on unix
Hi all ,
I'm trying to configure to configure an odbc connection (for sql server) on unix.
This is what I know about the database his ip, port, DSN, login and Pwd.
On windows is very simple but in unix It seems to be more complicated ...
what is the file I had to configure on DSEngine ?
thanks in advance
I'm trying to configure to configure an odbc connection (for sql server) on unix.
This is what I know about the database his ip, port, DSN, login and Pwd.
On windows is very simple but in unix It seems to be more complicated ...
what is the file I had to configure on DSEngine ?
thanks in advance
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: how to configure an odbc connection on unix
On windows is very simple but in unix It seems to be more complicated ...
I think it is ludicrous speed years simpler on Unix.
To add an odbc connection vi the $DSHOME/.odbc.ini file and add the connection. That is all you have to do to configure the odbc connection on unix. Vi one file and add an entry for the DSN.
To make the configured DSN accessible by a project you must add the DSN to projects uvodbc.config file.
I think it is ludicrous speed years simpler on Unix.
To add an odbc connection vi the $DSHOME/.odbc.ini file and add the connection. That is all you have to do to configure the odbc connection on unix. Vi one file and add an entry for the DSN.
To make the configured DSN accessible by a project you must add the DSN to projects uvodbc.config file.
ok thanks all !
i've just open odbc.ini with vi and I modified the file like this :
[SQLServer]
Driver=/export/DATASTAGE/Engine/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=MyDatabase
LogonID=MyDatabase
Password=Pxd_MyDatabase
Address=100.100.100.18,1479
QuotedId=No
AnsiNPW=No
then I had to modify the uvodbc.config file , I let you know if it works ...
i've just open odbc.ini with vi and I modified the file like this :
[SQLServer]
Driver=/export/DATASTAGE/Engine/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=MyDatabase
LogonID=MyDatabase
Password=Pxd_MyDatabase
Address=100.100.100.18,1479
QuotedId=No
AnsiNPW=No
then I had to modify the uvodbc.config file , I let you know if it works ...
I would suggest you not modify any of those example entries, but instead copy them and create new ones. That and name them approproately because the name in square brackets is what you will use to refer to the connection in the ODBC stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thank you chulett for your suggestion if I understood :
I have to rename [SQLServer] by [MyDatabase] for example and let a sample for other connection isn't ?
Moreover, I have just modify the uvodbc.config by adding :
<SQLserver>
DBMSTYPE = ODBC
So now I think I have just to restart the DS server...
I have to rename [SQLServer] by [MyDatabase] for example and let a sample for other connection isn't ?
Moreover, I have just modify the uvodbc.config by adding :
<SQLserver>
DBMSTYPE = ODBC
So now I think I have just to restart the DS server...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's any consolation, on older versions of Windows (we're talking 3.1 and earlier here) you had to edit an ODBC.INI file. That's why the Registry entry is still called ODBC.INI.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
this is what I have when I use DS_CONNECT :
Data Source information from /export/DATASTAGE/Projects/DEV/DEV_Primary_Dmt/uvodbc.config:
Data Source: localuv
DBMS Type: UNIVERSE
Network Type: TCP/IP
Host System: localhost 127.0.0.1
Service Name: uvserver
Data Source: PhoneNmber
DBMS Type: ODBC
Data Source: PhoneNumber
DBMS Type: ODBC
Do you have an idea ?
Data Source information from /export/DATASTAGE/Projects/DEV/DEV_Primary_Dmt/uvodbc.config:
Data Source: localuv
DBMS Type: UNIVERSE
Network Type: TCP/IP
Host System: localhost 127.0.0.1
Service Name: uvserver
Data Source: PhoneNmber
DBMS Type: ODBC
Data Source: PhoneNumber
DBMS Type: ODBC
Do you have an idea ?
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Do <name> and [NAME] match? The DSN name specified in the projects uvodbc.config must be the same as $DSHOME/.odbc.ini.
Does your uvodbc.config look similar to:
<PhoneNumber>
DBMSTYPE = ODBC
Does your .odbc.ini file look similar to:
[PhoneNumber]
Driver=/Ascential/DataStage/branded_odbc/lib/VMmsss21.so
Description=DataDirect SQL Server Wire Protocol
Database=
LogonID=
Password=
Address=I0050SQL01.ius.loc.com,1433
QuotedId=No
QEWSD=38891
AnsiNPW=No
Does your uvodbc.config look similar to:
<PhoneNumber>
DBMSTYPE = ODBC
Does your .odbc.ini file look similar to:
[PhoneNumber]
Driver=/Ascential/DataStage/branded_odbc/lib/VMmsss21.so
Description=DataDirect SQL Server Wire Protocol
Database=
LogonID=
Password=
Address=I0050SQL01.ius.loc.com,1433
QuotedId=No
QEWSD=38891
AnsiNPW=No
Thanks Ultramundane for your help ,
this now the error message :
Data Source: PhoneNumber
DBMS Type: ODBC
>DS_CONNECT PhoneNumber
Enter username for connecting to 'PhoneNumber' DBMS [dsadm]: PhoneNumber
Enter password for PhoneNumber:
SQLConnect error: Status = -1 SQLState = IM002 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Data source name not found and no default driver specified
I precise that I configures these 2 files not directly on the project directory and I'm working on a sun solaris system .
this now the error message :
Data Source: PhoneNumber
DBMS Type: ODBC
>DS_CONNECT PhoneNumber
Enter username for connecting to 'PhoneNumber' DBMS [dsadm]: PhoneNumber
Enter password for PhoneNumber:
SQLConnect error: Status = -1 SQLState = IM002 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Data source name not found and no default driver specified
I precise that I configures these 2 files not directly on the project directory and I'm working on a sun solaris system .
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: