Urgent - ODBC configuration

[aghosal]

Hi, I am new to Profile stage and I an trying to install it on my server but am not able to get beyond ODBC config as my test keeps failing. The odbc.ini file is included below. I have made all the environment changes as indicated by the Install guide. When I run the example, this is the message i get:

[psadmin@sdp-dbdwh /usr/local/ProfileStage/branded_odbc/example]$ ./example
./example DataDirect Technologies, Inc. ODBC Example Application.

Enter the data source name : dwh1

Enter the user name : psdb

Enter the password : psdb
SQLSTATE = 01000
NATIVE ERROR = 0
MSG =

SQLConnect: Retrying Connect.
SQLSTATE = 01000
NATIVE ERROR = 0
MSG =

SQLConnect: Retrying Connect.
SQLSTATE = 01000
NATIVE ERROR = 0
MSG =

SQLConnect: Retrying Connect.


Here is the odbc.ini file:


++++++++++++++++++++++++++++++++++++++++++++++++
[ODBC Data Sources]
## Repository Connections ##
PSDB_ORACLE=DataDirect 4.20 Oracle Wire Protocol
PSDB_SQLSERVER=DataDirect 4.20 SQL Wire Protocol
PSDB_DB2=DataDirect 4.20 DB2 Wire Protocol
## Source Connections ##
SOURCE_ON_ORACLE=DataDirect 4.20 Oracle Wire Protocol
SOURCE_ON_DB2_WIN=DataDirect 4.20 db2 wire Protocol
SOURCE_ON_SQLSERVER=DataDirect 4.20 SQL Server Wire Protocol
Text=DataDirect 4.20 TextFile(*.*)

####################################
##Oracle Connections PSDB and Source
####################################
[PSDB_ORACLE]
Driver=/usr/local/ProfileStage/branded_odbc/liib/VMora19.so
Description=DataDirect 4.20 Oracle Wire Protocol
LogonID=psdb
Password=psdb
HostName=10.0.2.105
PortNumber=1521
SID=dwh1
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1

[SOURCE_ON_ORA]
Driver=/usr/local/ProfileStage/branded_odbc/liib/VMora19.so
Description=DataDirect 4.20 Oracle Wire Protocol
LogonID=source
Password=source
HostName=10.0.2.105
PortNumber=1521
SID=dwh1
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1

Thanks a lot.

[mandyli]

Hi


I hope user id is not a dwh1 psadmin. If you have install.pdf guide please refer. inside install.pdf u have all the sepup details.

Thanks
MAN

[ray.wurlod]

There's no DSN for dwh1 in your odbc.ini file. You need, at a very minimum:
an entry for dwh1 in the [ODBC Data Sources] section
a section for [dwh1]