Print Page | Close Window

Can I use a Linux database-server?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30984
Printed Date: 28 March 2024 at 4:21pm
Software Version: Web Wiz Forums 12.07 - https://www.webwizforums.com


Topic: Can I use a Linux database-server?
Posted By: Pilsener
Subject: Can I use a Linux database-server?
Date 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?




Replies:
Posted By: WebWiz-Bruce
Date 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 http://dev.mysql.com/downloads/connector/odbc/" rel="nofollow - https://dev.mysql.com/downloads/connector/odbc/ and install; them on the web server not the database server.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Pilsener
Date 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?
 


Posted By: WebWiz-Bruce
Date 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.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Pilsener
Date 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.
 



Posted By: WebWiz-Bruce
Date 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.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.07 - https://www.webwizforums.com
Copyright ©2001-2024 Web Wiz Ltd. - https://www.webwiz.net