Switching to My SQL

Comersus Version: 7095
Database type: Access
Frequency: Permanent issue


I have a hosting account with PHPMyAdmin and database is already created. Seems to be OK.
But I have some problem with the database connetion string at comersus/includes/settings.asp. I followed these steps:
1) Access connetion is blocked
' DSN less connection
' pDatabaseConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &server.MapPath("../database/comersus.mdb")&";"
2) I changed
' database (access, sqlserver, mysql)
private const pDataBase = "access"
to
private const pDataBase = "mysql"
3) I tried
' mySQL Server 2.5
pDatabaseConnectionString = "Driver={mySQL};Server=localhost;database=mydatabasename;user=myusername;password=mypassword"
and also
' mySQL Server 2.5
pDatabaseConnectionString = "Driver={mySQL};Server=http://marodoco.startlogicmysql.com ;database=mydatabasename;user=myusername;password=mypassword"
But do not work. Where am I wrong?
Thank you

Tags:, ,
3 Comments

Add a Comment

Your email address will not be published. Required fields are marked *