Web Wiz Support and Community Forums : Connecting de mysql db https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 13:37:24 +0000 Sun, 03 Dec 2006 18:05:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22095 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Connecting de mysql db : ChangestrCon = &#034;Server=mysql.aaa.com&#034;...]]> https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117867.html#117867 Author: dpyers
Subject: 22095
Posted: 03 December 2006 at 6:05pm

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

To
strCon = "Server=" & strSQLServerName

]]> Sun, 03 Dec 2006 18:05:32 +0000 https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117867.html#117867 <![CDATA[Connecting de mysql db : 1: I get the following error:...]]> https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117854.html#117854 Author: Ivar
Subject: 22095
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...
 


Edited by Ivar - 03 December 2006 at 8:48am]]> Sun, 03 Dec 2006 08:48:00 +0000 https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117854.html#117854 <![CDATA[Connecting de mysql db : What is the error you are getting?Have...]]> https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117806.html#117806 Author: dpyers
Subject: 22095
Posted: 02 December 2006 at 2:27pm

  1. What is the error you are getting?
  2. Have you already created an empty db with those credentials?
]]> Sat, 02 Dec 2006 14:27:38 +0000 https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117806.html#117806 <![CDATA[Connecting de mysql db : I&#039;m trying connecting de...]]> https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117795.html#117795 Author: Ivar
Subject: 22095
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 ?!?
 
 
 
]]> Sat, 02 Dec 2006 13:19:38 +0000 https://forums.webwiz.net/connecting-de-mysql-db_topic22095_post117795.html#117795