test page

This page uses a test plugin to test PDO connections to MS SQLservers.

Both the connect string tests below are using the same uid and pwd to access a table which exists in both databases. The same queries work ok for both connections when accessed from an ASP.NET web page, but the connect string is specified differently for .NET (for test page: <a href=”http://medialab.st-andrews.ac.uk/dbTest.aspx” target=”_blank”>see here</a>)

Testing using: sqlsrv:server=symbiosis.st-andrews.ac.uk,1433

There was a connection error:
SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Testing using: sqlsrv:server=c-biocluster.st-andrews.ac.uk,30332

found: 1 match
(1 match implies a successful query)

Some data from match: "Steve"

I perform a wide variety of functions within the School of Medicine and the School of Biology at St Andrews University, and provide design and media production support to a number of other websites and science communication projects.

My primary role is focussed on web, video and interactive media and design and production. I am also involved in graphic design for print. I am further associated with IT support staff involved with network support, design and management of a number of websites and network resources. I also deliver some media related staff training, and media teaching for undergraduates and postgraduates.

Skill-set overview:

Skill Area Details

Graphic Design

2D layout and design for print and screen.
InDesign, Illustrator, Photoshop.

Photography

Studio and ambient lit stills photography. Digital image manipulation.
Photoshop, Lightroom, Aperture.

Video Production

Scriptwriting, Small Crew Direction, Editing, Lighting, Camera operation, Sound recording. Animation. Graphics. Final Cut X, Motion

Web Design

Page development and layout, site structure, graphic design, UI design, dynamic content and database applications. Wordpress Theme authoring and customisation.  HTML, CSS, see also programming.

Programming

VB.NET, PHP, Javascript.
Wordpress plug-in authoring (PHP).
Database applications (MS SQL)

Training

Course development and teaching: video production training.  Ad hoc training on various topics (eg Wordpress for Editors, Authoring with Storyline).

Interactive design

Writing, structuring, implementation. For online, offline and exhibition products: Articulate Storyline.
Also non-screen based interactive design.

Writing

Scriptwriting for factual/promotional screenplays.
'Plain English' writing for web and print.

Information Design

Content selection, prioritisation, editing and structuring, designing effective media vehicles for communicating ideas and information.

Voice

Occasional voiceover recording.

Exhibit Design

Many of the above skills areas in various combinations, also coordinating construction & production with service providers and subcontractors.