Page 2 of 2
Posted: Thu Nov 30, 2006 1:52 pm
by Ultramundane
The below commands should list the project locations where uvodbc.config needs to be edited.
Code: Select all
## CHANGE TO Directory Containing the VOC
cd $DSHOME
## GET PROJECT LIST
echo "$(dssh "SELECT PATH FMT '80L' \
FROM UV.ACCOUNT \
WHERE @ID NOT IN ('UV', 'uv', 'DS', 'ds') \
AND @ID NOT LIKE 'HS.%';" \
| awk '{print $1}' \
| grep '/')"
[/quote]
Posted: Thu Nov 30, 2006 2:03 pm
by kjaouhari
I thought it was not necessary to configure uvodbc.config in the directory of each project ...
I let know when It runs succesfuly...
thanks again.
Posted: Fri Dec 01, 2006 3:45 am
by kjaouhari
I put the odbc.ini in $DSHOME but I have still the same error message ...
>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: MyDatabase
DBMS Type: ODBC
>DS_CONNECT MyDatabase
Enter username for connecting to 'PhoneNumber' DBMS [dsadm]: MyDatabase
Enter password for MyDatabase:
SQLConnect error: Status = -1 SQLState = IM002 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Data source name not found and no default driver specified
... do i need to add something in the uvodbc.config file ?
Posted: Fri Dec 01, 2006 4:07 am
by rameshrr3
this is what i did to add a sybase ODBC DSN in my system
added this entry to
.odbc.ini ( IN $DSHOME directory)
Code: Select all
[car]
Driver=/app/ascential/Ascential/DataStage/branded_odbc/lib/VMase20.so
Description=DataDirect Sybase Wire Protocol
ApplicationName=
ApplicationUsingThreads=1
ArraySize=50
Charset=
CursorCacheSize=1
Database=car
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
InitializationString=
Language=
LogonID=
NetworkAddress=sybsrv2.ky.bbxxx.com, 4100
OptimizePrepare=1
PacketSize=0
Password=
RaiseErrorPositionBehavior=0
SelectMethod=0
WorkStationID=
Added the following to
uvodbc.config ( in project directory)
I guess you would have done something similar, mentioning the same schema/db name in the entries in both files.
I did not really understand
I put the odbc.ini in $DSHOME but I have still the same error message ...
, .odbc.ini already exists in $DSHOME
Posted: Fri Dec 01, 2006 7:15 am
by kjaouhari
:D Thanks very much all for your help !!!
I've just resolved because I modified a odbc.ini file but this is the
.odbc.ini file that I have to modify ...
in fact it's very easy to configure an odbc connection but we have just to modify the good file ...
Thanks again !