use jscript to connect mysql of wamp
Posted by: icelun (---.ctinets.com)
Date: June 21, 2010 02:41PM

i have search in web, and find out many solution, but away give
"data source name not found and no default driver specified"
i want to know is have any special setting for wamp to let jscript to access?

//----------------------------------------------------------------------------------------------//
var conn = new ActiveXObject("ADODB.Connection"winking smiley;
var rs = new ActiveXObject("ADODB.Recordset"winking smiley;
conn.open ="Driver={mySQL ODBC 3.51 Driver};Server=xxx.xxx.xxx.xxx;Port=4900;Database=my_dbname;Uid=user;Pwd=pass;Option=3";
var sSQLStatement = "SELECT count(*) FROM my_dbname.asuser ";
rs.Open(sSQLStatement, conn);
//----------------------------------------------------------------------------------------------//

my code is same as this. i run in softimage(XSI).



Edited 1 time(s). Last edit at 06/21/2010 02:42PM by icelun.

Options: ReplyQuote


Sorry, only registered users may post in this forum.