This question about Not sure...: Answered

DB front end in Foswiki

I consider building simple 'front end' for CRUD operations by means of Foswiki extensions.

Is it a good idea or maybe I should use different tool? Is there anyone who tries to accomplish that? What was the result? Is there any connection/configuration issues?

-- RomanAndrzej - 26 Jun 2014

Has been done a couple of times on intranets using SqlPlugin.

-- MichaelDaum - 26 Jun 2014

Could you tell me SqlPlugin will be able to connect to MS SQL Server database? Unfortunately I need to use it.

-- RomanAndrzej - 23 Sep 2014

There is no direct requirement to use a specific database server in SqlPlugin. Try the DBD::Sybase driver installed on your Foswiki server.

-- MichaelDaum - 24 Sep 2014

Alternatively you could use the DBD::ODBC driver. We have that is use in production connecting to an MS SQL database.

-- JulianLevens - 25 Sep 2014

Thank you for answer. Unfortunately, my biggest issue is that I wish to query MS SQL Database which is on different server. Moreover, this server is on our internal corporate network and Wiki on Amazon. I think that it might be very tricky to configure or even impossible.

-- RomanAndrzej - 06 Dec 2014

QuestionForm edit

Subject Not sure...
Extension SqlPlugin
Version Foswiki 1.1.9
Status Answered
Related Topics
Topic revision: r6 - 06 Dec 2014, RomanAndrzej - This page was cached on 12 Jan 2018 - 23:00.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License