Member Avatar for plahanov

Dear Friends,
please help me to resolve my problem wit Oledb connection.

For my current Project I need to fetch the data from an excel file.
Each second the data in the excel file is changing... What I want to do is, copy it from the excel and Validate it in every second.

So I use an Oledb connection to get the data from Excel file...
Its working excellent for two hours... After 2 hours I am getting an error that

"the connection for viewing your linked microsoft excel worksheet was lost......"
...

I searched a lot to get a solution but was futile.
I was stuck with this error for 3 days.. No Idea what would be the error ..

Please help me friends,
Plahanov

error.jpg 57.4 KB
Edited by plahanov because: n/a
  • 2 Contributors
  • 1 Reply
  • 153 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for lolafuertes

Is it possible to create a new connection once the current is lost? If so, catch the exection event, close the current and try a new connection.

Hope this helps.

Edited by lolafuertes because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.