ODBC SQL SERVER => problem
Posted: Wed Jul 28, 2004 7:23 am
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?
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?