Page 1 of 1

ODBC SQL SERVER => problem

Posted: Wed Jul 28, 2004 7:23 am
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:

Posted: Wed Jul 28, 2004 2:50 pm
by ray.wurlod
Try using an explicit name for the ODBC data source, rather than SQLServer (which may be a reserved word).