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 ?!?
Topic Options
Post Options
Thanks(0)
