<< TV-Info [85/117] >>

TV-Info

Home / Projects / TV-Info

TVInfo

TVInfo

Periodic transformation (SQL Enterprise Manager - > Data Transformation Service) the local TV-Movie-Clickfinder (http://www.tvmovie.de/clickfinder/clickfinder.html) - Access data base (Microsoft Access) to Microsoft SQL Server data base. From there the transmission information is picked out by a Java program under use of the MS-SQL-Server-JDBC-Driver and represented so largely on the screen that they are readable from far distance. Over the cursor keys movies can be selected and detailed information indicated. The moreover at the upper edge of screen the current date and the current time are indicated. Ideally if one possesses a computer to see TV and one have a wireless keyboard.
Characteristic: The Access data base of the TV-Movie-Clickfinder contains detailed program information, which is not indicated in the Clickfinder (with the free version) or only with a connection to the Internet.

Details

Language(s)	JAVA
Technologies	MS SQL server, JDBC, SQL
Tasks to solve	Installation of the MS SQL Server, installation of the JDBC-driver, configuration of the server, providing a transformation service (Access data base to MS SQL), SELECT inquiries to the SQL data base, generation of HTML and - visualization under Java, reaction to link clicks in the HTML
State	finished, but not published, only optimized for a resolution of 1280x1024 and limits to the 8 main-stations (free version of the Clickfinder).
Creation time area	October 2004

JSWins (JavaScript-Desktop-System)