Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Can I use a Linux database-server?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Can I use a Linux database-server?

 Post Reply Post Reply
Author
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 120
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post Topic: Can I use a Linux database-server?
    Posted: 04 April 2014 at 1:06am
I'm trying to run WebWiz on my LAN.
The forum is running on a Win 2003 server, but I wanted to experiment using a mySQL-database that's being run on a Raspberry Pi.

However, this is giving me error messages saying that:
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Is it possible to run this forum with a Linux-based database-server at all?

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9730
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 04 April 2014 at 8:25am
Yes this should be able to use mySQL running on a Linux server.

The error you are getting is because you need to install either the myODBC 3.51 or 5.1 driver the Win 2003 server. T

he version of myODBC (3.51 or 51.) depends on which myODBC driver you select when installing Web Wiz Forums.

You can download the myODBC drivers from https://dev.mysql.com/downloads/connector/odbc/ and install; them on the web server not the database server.
Back to Top
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 120
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2014 at 4:50pm
5.1 Driver installed.
System DSN configured in ODBC Data Source Administrator, and connection to the database on the Raspberry Pi tested successful in these settings.

Still I get the same error msg.
Is there anything I need to setup in IIS to get it to read the drivers?
And what Data Source Name do I have to use?
 


Edited by Pilsener - 15 April 2014 at 5:27pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9730
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2014 at 10:47am
Web Wiz Forums supports a DSN-less connection and can use either myODBC 3.51 and 5.1 drivers when using a mySQL database.

You select which myODBC driver when installing Web Wiz Forums.

Check that you have the right version of the myODBC driver installed on the web server. You can have both drivers installed without them conflicting with each other.
Back to Top
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 120
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2014 at 2:43pm
The link you provided in your first post, points to the download of v 5.3 of the driver.
Is this one too new for WebWiz?

Update:
5.3 was too new.
Removed 5.3 and installed 5.1
Success.
 



Edited by Pilsener - 16 April 2014 at 2:49pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9730
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2014 at 3:07pm
It is the same link to download all versions of the myODBC driver. You need to select the version from the download page that you wish to download.

Glad to hear though you now have it sorted.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2022 Web Wiz Ltd. All rights reserved.