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