Im trying to access data stored in notes tables/flat-files. And access it in ASP.NET.

What I did so far:-
1) I dowloaded a NOTESSQL odbc-driver from the IBM website.

2) i created a system-dsn with name xyz thru control panel.

3) from asp.net i created an oledb adapter/connection by dropping the object from the toolbox on the webform.

4) In the provider tab, I specified the provider as Microsoft-Oledb-provider-for-odbc-driver.

5.1) In the connection tab, I select the "use data source data" radio button and i see the xyz name in the list, but if i select it and hit 'Test connection' I get an error as below

ERROR:- Test connection failed because of an error in initializing provider. [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

5.2) In the connection tab, Instead of clicking the "use data source data" radio button, i tried to go thru the second radio button "use connection string" and in the next screen i selected the system dsn "xyz"
ERROR:- Operation cannot be executed because an error occurred during connection to the driver.

Pls help jshaker
[email protected]

Jeba Shaker
[email protected]