Greetings,

I am attempting to work on a site using javasript ASP and MySQL. Unfortunately, I cannot seem to get my connection string to work. Here it is...

<%
var adoConn = Server.CreateObject("ADODB.Connection");
adoConn.Open = ("Driver={mySQL}; Server=localhost; Port=3306; Option=0; Socket=; Stmt=; Database=bibletruthchapel_org; Uid=username; Pwd=password;");
%>

Any thoughts?

Clay Hess

__________________
Clay Hess

<%
mycon = "driver={MySQL};server=localhost;uid=user;pwd=pwd; database=bibletruthchapel_org;option=youroption"
Set datacon= Server.CreateObject("ADODB.Connection")
datacon.Open mycon

strQuery = "SELECT * FROM your_table;"
Set RS = datacon.Execute(strQuery)
%>

Whats the error!!!
Try it this way, it works for me.
Regards


sinapra

well, what's the error message?
probably the driver not specified.
for example, Driver={Mysql odbc 3.51 Driver};
search ur own mysql driver for correct odbc version;

Check this & also privode the Error Messages

 ODBC 2.50 Local database:

"Driver={mySQL};Server=localhost;Option=16834;Data base=mydatabase;"

 ODBC 2.50 Remote database:

"Driver={mySQL};Server=data.domain.com;Port=3306;O ption=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

 ODBC 3.51 Local database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"

 ODBC 3.51 Remote database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE= myDatabase;USER=myUsername;PASSWORD=myPassword;OPT ION=3;"