Hi All,
I'm trying to get connection from our Sun Solaris 8 box to a SQL server 2000 Database but am having trouble. DataStage version is 7.0.
The error message is:
$ cd $dshome
$ pwd
/export/home/dsadm/Ascential/DataStage/DSEngine
$ ./bin/dssh
PRINTER memory segment removed
DataStage Command Language 6.0
(c) Copyright 2002 Ascential Software, Inc. - All Rights Reserved
DSEngine logged on: Tue Apr 20 09:27:24 2004
>CONNECT
Data Source information from /export/home/dsadm/Ascential/DataStage/DSEngine/uvodbc.config:
Data Source: localuv
DBMS Type: UNIVERSE
Network Type: TCP/IP
Host System: localhost 127.0.0.1
Service Name: uvserver
Data Source: asiqdemo
DBMS Type: ODBC
Data Source: ingres
DBMS Type: ODBC
Data Source: mssqlserver
DBMS Type: ODBC
Data Source: empower
DBMS Type: ODBC
Data Source: dwh
DBMS Type: ODBC
Press any key to continue...
Data Source: dwh_prod
DBMS Type: ODBC
>CONNECT empower
Enter username for connecting to 'empower' DBMS [dsadm]: sa
Enter password for sa:
SQLConnect error: Status = -1 SQLState = 10 Natcode = 11
[ODBC:11] [unixODBC]DtDrc]OB Q evrDie]lbslet8CnetoOe dhpo()
>Q
This is what my .odbc.ini looks like:
[ODBC Data Sources]
dwh=Sybase ASIQ-M 12.5 Wire Protocol
ingres=Ingres
mssqlserver=
empower=
[dwh_prod]
Driver=/export/home/sybase/ASIQ-12_5/lib32/dbodbc7.so.1
EngineName=dwh_prod
CommLinks=tcpip{host=dwh;port=8000}
UserID=DBA
Password=SQL
[dwh]
Driver=/export/home/sybase/ASIQ-12_5/lib32/dbodbc7.so.1
EngineName=dwh
CommLinks=tcpip(host=dwh;port=9000)
Userid=DBA
Password=SQL
[asiqdemo]
Driver=/export/home/sybase/ASIQ-12_5/lib/dbodbc7.so
CommLinks={port=2638}
ServerName=asiqdemo
DatabaseName=asiqdemo
[ingres]
Driver=Ingres
Server=stores
Database=mphm
ServerType=Ingres
[mssqlserver]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Database=Harmony CS
LogonID=sa
Password=
Address=10.0.6.52,1433
QuotedId=No
AnsiNPW=No
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No
[ODBC]
Trace=1
TraceFile=odbctrace.out
TraceDll=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/odbctrac.so
ConversionTableLocation=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/tables
UseCursorLib=0
InstallDir=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc
This is what my uvodbc.config file looks like for the specific project:
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<ingres>
DBMSTYPE = ODBC
network = TCP/IP
<dwh_prod>
DBMSTYPE = ODBC
network = TCP/IP
<empower>
DBMSTYPE = ODBC
network = TCP/IP
<mssqlserver>
DBMSTYPE = ODBC
network = TCP/IP
<dwh>
DBMSTYPE = ODBC
network = TCP/IP
Some assistance would really be appreciated, please.
TIA.
Ciao.
Faeez
ODBC connection error
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration