DSXchange

I am trying to connect to MS SQL server database using ODBC connector . I am getting error like invalid data source name .

I am using the same data source name , user id & password in ODBC enterprise & DRS stages . Those stages are working fine . But , ODBC connector is giving the issue .

Please suggest .

Thank

Does the DSN exist in the uvodbc.config file in your project?

DRS & ODBC Enterprise stage are working fine . I guess , both of those stages use uvodbc.config file . So , DSN name should be present in uvodbc.config file . Anyways I will check & confirm it .

Thanks

Are all the connection properties set up correctly in your ODBC Connector stage? What error message is generated? Can you Test the connection from within the ODBC Connector stage? Can you View Data?