odbc configuration not working
Posted: Tue Dec 04, 2007 5:51 pm
Hi,
I have some weired thing that is going on..I created a new odbc for sqlsever in the .odbc.ini and follwoing thing on my project folder but it is not working..the same connection from development is working there is no firewall or any thing but it gives me that login failed..but the same same login works from the database and my another datastage machine...
this is the erroe that i get...
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SQL-1','dwuser')): BCI Error:
SQLSTATE=0,CODE=4060,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Operations
'. Login fails.
but i do login with the same user in my development datastage and from my databse...Pls help me out...
I have some weired thing that is going on..I created a new odbc for sqlsever in the .odbc.ini and follwoing thing on my project folder but it is not working..the same connection from development is working there is no firewall or any thing but it gives me that login failed..but the same same login works from the database and my another datastage machine...
this is the erroe that i get...
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SQL-1','dwuser')): BCI Error:
SQLSTATE=0,CODE=4060,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Operations
'. Login fails.
but i do login with the same user in my development datastage and from my databse...Pls help me out...