ASP --> Access --> Excel & MsSQL(ODBC)

[p0o0q]

Dear All, I use ASP.net AccessDataSource to retrieve data from a Access file. In this Access file, two tables are updated automatically by a Excel file and MsSQL(ODBC) respectively. The Access file and Excel file are in the same folder, so Access file can retrieve data from the Excel one successfully. However, when ASP.net -> Access -> MsSQL(ODBC connection called "ProyectoCongelados"), I got the following error message:System.Data.OleDb.OleDbException: ODBC--connection to 'ProyectoCongelados' failed. Anyone can give me some advice? Thanks in advance. Regards, TM

[adatapost]

I am unable to judge where you got problem. Any code? You are using AccessDataSource - OleDB classes and where is code that uses ODBC?

A DATAPOST COMPUTER CENTRE (K.V Prajapati)