SQL Server database connection not working
Posted: Sun Dec 08, 2013 7:48 pm
Hi Experts,
I have made a new SQL server database connection by editing the .odbc.ini and uvodbc.config files.
Entry:
[RockfaceET_PROD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=EE2SQL
LogonID=******
Password=******
Address=sodium,1433
QuotedId=No
QEWSD=2455182
AnsiNPW=No
But I am getting an error while ODBC metadata import.
Error:
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('RockfaceET_PROD','wiproee')) : BCI Error :
SQLSTATE=28000,CODE=18456,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Login failed for user 'wiproee'.
Search is not helping... Please help.
I have made a new SQL server database connection by editing the .odbc.ini and uvodbc.config files.
Entry:
[RockfaceET_PROD]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=EE2SQL
LogonID=******
Password=******
Address=sodium,1433
QuotedId=No
QEWSD=2455182
AnsiNPW=No
But I am getting an error while ODBC metadata import.
Error:
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('RockfaceET_PROD','wiproee')) : BCI Error :
SQLSTATE=28000,CODE=18456,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Login failed for user 'wiproee'.
Search is not helping... Please help.