mariadb Maria DB - Remote access

[nppd]

I need to know how I can connect with MariaDB from classic asp. 

I try to use the following connection string: connString = "Provider=MSDASQL; Driver={MariaDB ODBC 3.1 Driver}; Server=2steps.gr.helioho:3306; Database=nppd_2steps.gr; UID=nppd_master; PWD=[removed]; Option=3;" but your server returns the Error: Error connecting to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 

 

Any suggestions?

Nick 

 

 

Edited May 8 by wolstech
Remove password

[wolstech]

Host name is incorrect...2steps.gr.helioho:3306 should be tommy.heliohost.org:3306 assuming the database is on your Tommy account.

Also, be sure you enabled remote access in Plesk (it's under the settings for the database user, at the bottom)