Graphics

I have a fancy ticker scene (not a true ticker crawl, just using a take group with back-to-back logic) that advances through a league's draft order based on an excel sheet, and updates to reflect picks and trades in real-time. I have the workbook setup as an .XLS with legacy workbook sharing turned on. My datalinq server is set to Excel (mixed numeric/text data) and refreshes every 1 second.

Everything worked fine for a few days. I could run my ticker with the excel sheet open and make selections/trades that would immediately be reflected in the XPression scene upon saving the workbook. Then, a few days into testing, the ticker started blanking out momentarily, like it lost data, before returning the data with some playout glitches about 5 seconds later. When I checked the Datalinq Server's log window I get this set of errors. The "Error in updating" one repeats about 20 times a second for about 5 seconds, until the server seems to catch up and restore the data to the scene.

09-01-24 18:06:52.411: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Exception opening ADO Client: The Microsoft Jet database engine cannot open the file ''.  It is already opened exclusively by another user, or you need permission to view its data09-01-24 18:06:52.489: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$09-01-24 18:06:52.537: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$

I've attempted to rebuild the workbook and play with some of the Datalinq server settings, but nothing seems to stop the error from happening.

Any idea how I can fix this? TIA

Apologies, I'm running version 11.0 for both XPression and the Datalinq Server.

I have a fancy ticker scene (not a true ticker crawl, just using a take group with back-to-back logic) that advances through a league's draft order based on an excel sheet, and updates to reflect picks and trades in real-time. I have the workbook setup as an .XLS with legacy workbook sharing turned on. My datalinq server is set to Excel (mixed numeric/text data) and refreshes every 1 second.

Everything worked fine for a few days. I could run my ticker with the excel sheet open and make selections/trades that would immediately be reflected in the XPression scene upon saving the workbook. Then, a few days into testing, the ticker started blanking out momentarily, like it lost data, before returning the data with some playout glitches about 5 seconds later. When I checked the Datalinq Server's log window I get this set of errors. The "Error in updating" one repeats about 20 times a second for about 5 seconds, until the server seems to catch up and restore the data to the scene.

09-01-24 18:06:52.411: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Exception opening ADO Client: The Microsoft Jet database engine cannot open the file ''.  It is already opened exclusively by another user, or you need permission to view its data09-01-24 18:06:52.489: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$09-01-24 18:06:52.537: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$

I've attempted to rebuild the workbook and play with some of the Datalinq server settings, but nothing seems to stop the error from happening.

Any idea how I can fix this? TIA

Can you show us a picture of your connection string in the ADODB Datalinq setup? 

Apologies, I'm running version 11.0 for both XPression and the Datalinq Server.

I have a fancy ticker scene (not a true ticker crawl, just using a take group with back-to-back logic) that advances through a league's draft order based on an excel sheet, and updates to reflect picks and trades in real-time. I have the workbook setup as an .XLS with legacy workbook sharing turned on. My datalinq server is set to Excel (mixed numeric/text data) and refreshes every 1 second.

Everything worked fine for a few days. I could run my ticker with the excel sheet open and make selections/trades that would immediately be reflected in the XPression scene upon saving the workbook. Then, a few days into testing, the ticker started blanking out momentarily, like it lost data, before returning the data with some playout glitches about 5 seconds later. When I checked the Datalinq Server's log window I get this set of errors. The "Error in updating" one repeats about 20 times a second for about 5 seconds, until the server seems to catch up and restore the data to the scene.

09-01-24 18:06:52.411: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Exception opening ADO Client: The Microsoft Jet database engine cannot open the file ''.  It is already opened exclusively by another user, or you need permission to view its data09-01-24 18:06:52.489: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$09-01-24 18:06:52.537: [ Info      ] ADODB DataLinq Source (NWSL Draft 2024) Error in updating data for ADODB connection, Table: DraftData$

I've attempted to rebuild the workbook and play with some of the Datalinq server settings, but nothing seems to stop the error from happening.

Any idea how I can fix this? TIA