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
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy