Print Page | Close Window

Trouble setting up database connection MySql

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=31138
Printed Date: 30 March 2026 at 12:10pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Trouble setting up database connection MySql
Posted By: guitarblogger.dk
Subject: Trouble setting up database connection MySql
Date Posted: 10 January 2015 at 9:03pm
Hi

I have Unoeuro account with a MySql database where I try to setup the forum software.

I have tried testing with both the 3.51 and 5.1 myODBC Database Drivers and both fail with:

Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

From the Unoeuro support pages they have this example on a MySql connection:

<%
SQLserveradr="mysql3.unoeuro.com"
SQLdatabase="my database"
SQLlogin="my login"
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
%>
So I guess I can change the setup_database_connection.asp to reflect this.

I have some noobish experience in classic asp and sql (using access databases).

But I am little at loss of where exactly to make the change? 









Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 January 2015 at 8:42am
The error means that the myODBC 3.51 or myODBC 5.1 database driver is not installed on the server.

One of tehse driverrs is required in order for Classic ASP to be able to connect to a mySQL Database.

You should contact the server admin and ask that they installed one of the drivers below on the server:-

myODBC 3.51
myODBC 5.1


-------------
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: AllMor
Date Posted: 14 January 2015 at 9:16am
Hi,
 
I use UnoEuro and when I launched my forum http://forum.excel-regneark.dk  I had the same problem as you.
 
The solution was removing the drivers version mySQL sting.
 
So, in the files:
  • setup_db_con_test.asp
  • setup_database_connection.asp
  • \database\database_connection.asp
you have the change the string:
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
to
strCon = "Driver={MySQL};Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
 
At this time I think i'ts the only way to make it Work with UnoEuro.
 
 


Posted By: guitarblogger.dk
Date Posted: 15 January 2015 at 8:26pm
Originally posted by AllMor AllMor wrote:

Hi,
 
I use UnoEuro and when I launched my forum http://forum.excel-regneark.dk  I had the same problem as you.
 
The solution was removing the drivers version mySQL sting.
 
So, in the files:
  • setup_db_con_test.asp
  • setup_database_connection.asp
  • \database\database_connection.asp
you have the change the string:
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
to
strCon = "Driver={MySQL};Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
 
At this time I think i'ts the only way to make it Work with UnoEuro.
 

^^Thanks!^^

This worked like a charm. 



Print Page | Close Window

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