mySQL connection string for ASP

This is my first go at mySQL. I have converted my Access databases to mySQL and can access the database with ASP on my PC. I have now created the databases & loaded up the data on my client's host which requires the use of a socket path. They provide connection strings for PHP &Perl which I have tried to translate to ASP but I am getting

ADODB.Connection.1 error '80004005'

SQLState: S1000
Native Error Code: 80

no matter what. The sample PHP & perl strings are :

PHP CODE

<?php
$db = @mysql_connect("localhost:/home/*username*/*yourdomain.com*/.database/mysql/mysql.sock", "root", "*your password*");
?>

PERL CODE

my($db) = DBI->connect("DBI:mysql:*database_name*:localhost;

mysql_socket=/home/*username*/*yourdomain.com*/.database/mysql/mysql.sock",'root','*your password*');


My ASP:

conn.Open "Driver={MySQL}; SERVER=localhost; Port=0; Option=0; Socket=/home/*username*/*yourdomain.com*/.database/mysql/mysql.sock; DATABASE=*database_name*; UID=root; PWD=*your password*;"

I've tried a few variations but no use! ISP is as helpful as a hole in the head. Any help would be gratefully received!

There is an article on this site on this very topic: http://www.devarticles.com/art/1/50/4

Yes that's where I started! As you would see from my ASP attempt I have used that construct. I can't get it to work - I figured there must be something I have wrong in the translation between the supplied PHP and the quoted article.

http://support.microsoft.com/defaul...&NoWebContent=1


read that.

The answer is that what I coded should have worked but the ISP only sort-of supports ASP - you can do various things but connecting to mySQL is not one of them!