Jump to content

Recommended Posts

Posted (edited)

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 by wolstech
Remove password
Posted

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)

  • Like 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...