ODBC Connector Issue

nagarjuna · Post by **nagarjuna** » Fri Dec 28, 2012 2:08 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Dec 28, 2012 3:14 pm

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

nagarjuna · Post by **nagarjuna** » Sat Dec 29, 2012 10:48 am

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

ray.wurlod · Post by **ray.wurlod** » Sat Dec 29, 2012 3:25 pm

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?