i have a simple form with an adodc1 on it. i right clicked adodc1 and clicked properties. then i selected "Use ODBC Data source name" and entered datasource name (dblive) there. after that, when i selected record source tab to identify table i received following error:

[Microsoft][ODBC Driver Manager]Driver'sSQLSelectConnectAttr failed

Please note that same ODBC data source i have used to access data from excel and i have successfuly retrieved data.

any suggetion from u EXPERTS ?

thanx in advance for help.