Connectivity Problem...
Posted: Mon Apr 11, 2005 3:53 am
Hi
I'm working with one of the top software companies in India. I'm new in Data Warehousing and am toddling my way around with tools like DataStage. I've had this connectivity problem with DSEE.
I created a Data Source of an Access database in the Administrative tools in XP using ODBC connectivity. Access database doesn't mandatorily need a password for the connection, thought the ODBC Enterprise object for the connection needs the username and password to be specified. So, I set the same in the Data Source and gave the same username and password in the ODBC component.
When I run the job, the connection fails. I discovered that when I'm entering the password in the box provided in the object properties of the ODBC object, it just changes to something else. That is,when I enter, say a 4 character long password and click some other option, the password changes to a 5 character one. Can somebody tell me why...
[size=9][/size][size=7][/size][size=9][/size][size=7][/size]
I'm working with one of the top software companies in India. I'm new in Data Warehousing and am toddling my way around with tools like DataStage. I've had this connectivity problem with DSEE.
I created a Data Source of an Access database in the Administrative tools in XP using ODBC connectivity. Access database doesn't mandatorily need a password for the connection, thought the ODBC Enterprise object for the connection needs the username and password to be specified. So, I set the same in the Data Source and gave the same username and password in the ODBC component.
When I run the job, the connection fails. I discovered that when I'm entering the password in the box provided in the object properties of the ODBC object, it just changes to something else. That is,when I enter, say a 4 character long password and click some other option, the password changes to a 5 character one. Can somebody tell me why...
[size=9][/size][size=7][/size][size=9][/size][size=7][/size]