"Database" image not refreshed

Using Excel,SQL,Oracle, and other ODBC Compliant Databases
Post Reply
matdaut
Forum Contributor
Forum Contributor
Posts: 4
Joined: Tue Mar 19, 2013 5:33 pm

"Database" image not refreshed

Post by matdaut »

I'm using an ODBC connection to an Excel file to get a list of images to display.
And it's working quite well... my Excel file contains only one column with the full path of the images. I use that value in the "Image path" field of one image object on a page.

My excel file is like this:

FullPath
D:\Slide01.png
D:\Slide02.png
D:\Slide03.png
D:\Slide04.png
D:\Slide05.png
D:\Weather.png

The "Weather.png" is overwritten on the server by a new version every hour (because the weather is changing!). However, it does not trigger any change on the LCD screen... Always displaying the "old" Weather.png. Like if it was taken from a cache or something... Can you help ?

Thanks!
Viktor S
Noventri Support Specialist
Noventri Support Specialist
Posts: 12
Joined: Mon Dec 19, 2011 5:27 pm
Location: Maryland, USA
Contact:

Re: "Database" image not refreshed

Post by Viktor S »

Hello Matdaut,

Make sure that you running the latest version of the Noventri software available here : http://www.noventri.com/forum/viewtopic.php?f=14&t=205

You may be experiencing an excel lock issue with your default ODBC driver. To fix this, install Microsoft's AccessDatabaseEngine.exe driver, restart Suite, then choose the following driver in your Suite project:

Microsoft Excel Driver (*.xls, *.xlsx,...)

It is important that you select this exact option as there will now be multiple excel drivers to choose from.

This version of the driver should take care of the lock issues you are experiencing. Please let us know how it goes, or if there is anything else we can help you with.

Kind Regards,
Viktor
Viktor Seredich
Technical Support Engineer
Specialized Communications Corp. / Noventri
20940 Twin Springs Dr.
Smithsburg, MD 21783-1510 USA
800-359-1858
301-790-0103
Fax: 301-790-0173
http://www.noventri.com
rdflesher
Valued Contributor
Valued Contributor
Posts: 25
Joined: Thu Dec 01, 2011 3:43 pm

Re: "Database" image not refreshed

Post by rdflesher »

So do I update the ODBC drive on the server only since the problem appears to be the serer locking the file(s)?
David L
Noventri Digital Signage Expert
Noventri Digital Signage Expert
Posts: 34
Joined: Thu Dec 10, 2009 2:00 pm

Re: "Database" image not refreshed

Post by David L »

The same driver should be installed on all machines running either the Noventri Suite or Noventri Server. Since you will be changing your project settings to use the new driver, the same driver needs to be installed on all machines.

David
rdflesher
Valued Contributor
Valued Contributor
Posts: 25
Joined: Thu Dec 01, 2011 3:43 pm

Re: "Database" image not refreshed

Post by rdflesher »

FYI - the downloaded file says Microsoft Office Access db engine. Does that matter?
David L
Noventri Digital Signage Expert
Noventri Digital Signage Expert
Posts: 34
Joined: Thu Dec 10, 2009 2:00 pm

Re: "Database" image not refreshed

Post by David L »

Yes, that is correct. The pack has a number of Microsoft ODBC Drivers.

Please remember to change your Suite project to use the excel driver labeled, "Microsoft Excel Driver (*.xls, *.xlsx,...)" . It is important that you choose that exact option as you will now have different excel drivers to choose from.

David
Post Reply