I got some coding from internet.. but conn variable is always emty("")..
Do you have any idea??
My Env:
- WinXp
- VS 6.0, .NET 2003, .NET 2005 and MySQL, MSDE and FireBird.
Any Idea?? Thanks.
Code:
<SCRIPT LANGUAGE=javascript>
<!--
function ConDB()
{
var conn = new ActiveXObject("ADODB.Connection") ;
//var conn = CreateObject("ADODB.Connection");
alert(conn);
//var connectionstring="Provider=SQLOLEDB;Password=;User ID=;Initial Catalog=;Data Source=;"
//var connectionstring="Provider=SQLOLEDB;Password=;User ID=gpctadmin;Initial Catalog=;Data Source=;"
var connecitonstring = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;UID=root;PWD=testing123;" //_ & "OPTION=" & 1
alert(connecitonstring);
if(conn != ''){
conn.Open(connectionstring);
alert(conn);
}
else{
alert("d");
}
//var rs = new ActiveXObject("ADODB.Recordset");
//rs.Open("SELECT * FROM YourTablename ", conn);
//rs.MoveFirst
//while(!rs.eof)
//{
//document.write( yourtablefieldname);
//rs.movenext;
//}
//rs.close;
//conn.close;
} //-->
</SCRIPT>
<body topmargin="0" OnLoad="javascript:ConDB()">
Reply With Quote
Bookmarks