ODBC SQL SERVER => problem

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

Post Reply
l
Participant
Posts: 1
Joined: Wed Jul 28, 2004 3:39 am

ODBC SQL SERVER => problem

Post by l »

I want connecting SqlServer 7.0 database whith Datastage 4.2
i have Modify odbc.ini
'------------------
[ODBC DataSources]
SQLServer=

[SQLServer]
Driver=/opt/produits/datastage/v421r2/branded_odbc/lib/VMmsss15.sl
Description=SQL Server
Database=MyTable
Address=SSQLXXXX,1433
LogonID=sa
Password=
QuoteID=No
AnsiNPW=No
-----------------------------------------------------
and modify uvodbc.config into my project
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = localhost

<SQLServer>
DBMSTYPE = ODBC
----------------------------------------------------

But i want import/table definitons/odbc table definitons,
i have a error message :
------------------------------------------
dsr;megagMETEGETA...An unknownDBMS type hase been sprecified
sqlState=Im003,codeO,argentSqlClientAn illegalConfiguationOptionwasFound....
----------------------------------------------

What a problem? :oops:
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try using an explicit name for the ODBC data source, rather than SQLServer (which may be a reserved word).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply