Web Wiz Forums - Data Source name not found

Print Page | Close Window

Data Source name not found - problem

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=29884
Printed Date: 31 March 2026 at 9:43pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Data Source name not found - problem

Posted By: mrOkay
Subject: Data Source name not found - problem
Date Posted: 19 October 2011 at 6:19pm

Hey,

I just tryed this forum, but at the installing process it went down.

Im getting this error

Data source name not found and no default driver specified

I've already read plenty of guys with same problem, but it didn't solve it.

Jeg chose MySQL, and filled out the inputs, but it keeps givin me this error.

What should I do ?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 October 2011 at 8:20am

The error means that the myODBC driver is not installed on your web server and so the web server can not talk to the mySQL database.

There are two choices on the install wizard myODBC 3.51 and myODBC 5.1 select the one that you have installed on the server.

If neither are installed on the server you would need to have the server admin install either myODBC 3.51 or myODBC 5.1 on the server. If you run the server yourself you can download the latest myODBC 5.1 driver for the page below:-

http://dev.mysql.com/downloads/connector/odbc/" rel="nofollow - http://dev.mysql.com/downloads/connector/odbc/

-------------
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: mrOkay
Date Posted: 20 October 2011 at 1:02pm

Hmm

"Use the driver named "mySQL"

That was all my webhotel wrote to me

What sould I do ?

Posted By: WebWiz-Bruce
Date Posted: 20 October 2011 at 1:21pm

They are giving advice for connecting from PHP which has built in drivers to connect to mySQL.

When you connect to mySQL from ASP you need to use the myODBC driver to connect, which needs to be installed on the server.

You need to let your web host know you are connecting to a mySQL Database from ASP which requires the myODBC driver to connect, and ask them which version they have installed, if any.

Posted By: mrOkay
Date Posted: 20 October 2011 at 2:15pm

I wrote what you said, and they answered:

You have to use the driver named "MySQL"... Its ASP, and it is myODBC

Freakin danish people. I ax'd them twice what version it was, but they didn't answer.

What should I tell em? Should I open up my AK 47 Big smile

Posted By: WebWiz-Bruce
Date Posted: 20 October 2011 at 4:19pm

Sounds like they do not have a glue what they are talking about, are you sure you are not using a reseller who does not have any knowledge of the product they are supporting?

The simple way to put is to them is 'which of the below myODBC drives to you support for mySQL?'

1. MySQL ODBC 5.1 Driver

2. MySQL ODBC 3.51 Driver

If they do not know fire them as they would be useless if you had anything go wrong as they obviously do not have a clue if they con not even answer a simple support question like this.

Posted By: mrOkay
Date Posted: 20 October 2011 at 4:52pm

I appreciate your help

Actually they are one of the biggest in Denmark, but their support is horrible. This is not the first time.

Now I wait and see for their next answer....

Posted By: mrOkay
Date Posted: 20 October 2011 at 4:56pm

Ok I wrote:

Wich of the folloing is INSTALLED AT YOUR SERVER:

1. MySQL ODBC 5.1 Driver
2. MySQL ODBC 3.51 Driver

Its all mySQL, but is it ODBC 5.1 or 3.51? Cuz I can't connect to any of them

They answered:

Theres a driver named "mysql" on our webserver, maybe you should try to use that, just like the other thousands os users? It is version 5.1, if you don't know.

Edit:

Btw. They linked to the default way of connecting to mySQL. I run a site with over 1000 users pr. day, but still...

<%
SQLserveradr="[server]"
SQLdatabase="[database]"
SQLlogin="[brugernavn]"
SQLpassword="password"

Set Conn = Server.CreateObject("ADODB.Connection")

conStr = "driver={MySql};server="& SQLserveradr &";database="& SQLdatabase
conStr = conStr & ";uid="& SQLlogin &";pwd="& SQLpassword & ";OPTION=3"

Conn.Open conStr
%>

Posted By: WebWiz-Bruce
Date Posted: 20 October 2011 at 5:29pm

Then select the myODBC 5.1 driver when installing Web Wiz Forums, if you still get the same error then it sounds like you need to change web host to one with decent support.

ASP works better with SQL Server, so if you have that option I recommend that you use SQL server instead.

Posted By: mrOkay
Date Posted: 21 October 2011 at 1:06am

I've tryed to choose both the first time I installed it, but its the same error.

But webhost is almost never down, and its rare that I need support so I don't think that'll help.

And I've been using ASP+MySQL for serveral years without problems, so I think the problem here is the way the forum connects to the database - not saying theres an error, but it might be diffrent from what this server wants.

Posted By: WebWiz-Bruce
Date Posted: 21 October 2011 at 11:07am

The way Web Wiz Forums connects to a mySQL or SQL Server Database has not changed in 10 years and is used on over 100,000 websites, so can not see the way the forum connects as being the issue.

Have you created as blank mySQL or SQL Server Database to use with the Web Wiz Forums?

-------------
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: mrOkay
Date Posted: 24 October 2011 at 3:27pm

What do you mean by a blank mySQL database?..

Posted By: WebWiz-Bruce
Date Posted: 24 October 2011 at 3:59pm

You need to have your web host setup an empty mySQL database toi use for your forum.

You then use the connection details your web host give you to connect the empty mySQL database from the Web Wiz Forums setup wizard which will then create the tables in the database that are required for the forum to run.