Web Wiz Forums - Connecting de mysql db

Print Page | Close Window

Connecting de mysql db

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=22095
Printed Date: 08 April 2026 at 1:34pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Connecting de mysql db

Posted By: Ivar
Subject: Connecting de mysql db
Date Posted: 02 December 2006 at 1:19pm

I'm trying connecting de software to the mysql database, but is does not goes swell..

Let say these are the stats:
Servername: mysql.aaa.com
username:aaa
Password: 1234
db name: aaa

Is it correcly to edit in the database connection:

_____________

strSQLServerName = "mysql.aaa.com" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "aaa" 'Holds the user name (for SQL Server Authentication)

strSQLDBPassword = "1234" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "aaa" 'Holds the name of the database

'Initilise the DB Connection String

strCon = "Server=mysql.aaa.com" & strSQLServerName & ";User ID=aaa" & strSQLDBUserName & ";Password=1234" & strSQLDBPassword & ";Database=aaa" & strSQLDBName & ";"

End If

______________

Something I do wrong, but what ?!?

Replies:

Posted By: dpyers
Date Posted: 02 December 2006 at 2:27pm

What is the error you are getting?
Have you already created an empty db with those credentials?

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: Ivar
Date Posted: 03 December 2006 at 8:48am

1: I get the following error:

Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql.aaa.commysql.aaa.com' (11001)

I don't understand how the double got there ?

2: Well, my provider did that yes and gave me the the stats I used...

Posted By: dpyers
Date Posted: 03 December 2006 at 6:05pm

Change
strCon = "Server=mysql.aaa.com" & strSQLServerName

To
strCon = "Server=" & strSQLServerName

-------------

Lead me not into temptation... I know the short cut, follow me.