| Author |
 Topic Search  Topic Options
|
zheka 
Newbie
Joined: 14 November 2006
Status: Offline
Points: 4
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum Integration doesn't work
Posted: 29 February 2008 at 11:43am |
Hi,
I've just installed newspad and forum on the same server - everything works perfectly on it's own.
But when I am trying to do the forum integration I am getting the following error:
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I've triple checked all the settings and could not make it work.
Did anyone have the same problems?
Any help would be appreciated
Thanks
|
 |
freakdaddy
Groupie
Joined: 24 January 2008
Status: Offline
Points: 79
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 March 2008 at 10:12am |
|
Yeah, I don't know. I had the exact same error. I've been searching the forum for an answer, but can't find one. I'm only going to assume that it's due to a recent change.
I triple checked all my settings as well....
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2008 at 11:00am |
|
This is a server error.
The error often means that the database driver is not installed on the web server.
If you could say which database type you are using, and where you get this error should be able to help further.
|
|
|
|
zheka
Newbie
Joined: 14 November 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2008 at 12:24pm |
I am using mySQL. Getting error when I press Test Database connection in Web Wiz forum Integration section.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2008 at 12:56pm |
|
This error has come up before and only happens on some servers running mySQL.
Instead of setting the exact driver it sets it is the Driver={MySQL} driver, this works on most servers, however one or two it doesn't
In the files:-
admin_test_webwizforums_connection.asp
functions/webwizforums_database_connection.asp
Change:-
Driver={MySQL}
To:-
Driver={MySQL ODBC 3.51 Driver}
|
|
|
|
zheka
Newbie
Joined: 14 November 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2008 at 1:18pm |
Worked perfectly!
Thanks!!!
|
|
freakdaddy
Groupie
Joined: 24 January 2008
Status: Offline
Points: 79
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 March 2008 at 10:01pm |
|
Thanks, yeah this worked for me too. Just a quick FYI for you Bruce, the database connection file was set with that ODBC 3.51 driver, it was only the admin test that wasn't. Which is why I thought it was weird because I got the newspad up and running no problem (and I've had the forums up for some time).
One quick question now that the integration is setup. What good does this do me? I was expecting that I would be able to access my groups now and members, but that doesn't appear to be the case. I assume there is a way to do this however, correct?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 March 2008 at 9:45am |
|
When you send send your eNewsletter, below the place you select which NewsPad categories you want the item in you have another box that allows you to select which Web Wiz Forums groups you want to send your eNewsletter to.
You can also have links to the news items appear on the hompegae of your forum by enabling this in Web Wiz Forums.
|
|
|
|
Forum Integration doesn't work