>>< %@ Page CompilerOptions='/R:"C:\Program Files\Microsoft.NET\Odbc.Net\Microsoft.data.odbc.dll"'% > >>< %@ Import Namespace="System.Data" % > >>< %@ Import Namespace="Microsoft.Data.Odbc" % > >><SCRIPT Language="VB" Runat="server"> >>Sub Page_Load(Source as object, e as EventArgs) >>Dim sConString As String = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=linux3; >>DATABASE=maindata; UID=user1; PASSWORD=user1pass; OPTION=3" >>Dim oConnection as ODBCConnection = new ODBCConnection(sConString) >>Dim sSQL as String = "SELECT name,contact,email,enabled,username FROM customer" >>Dim oDataAdapter as ODBCDataAdapter = New ODBCDataAdapter(sSQL, oConnection) >>Dim oDataSet as DataSet = new DataSet() >>oDataAdapter.Fill(oDataSet) >>>>
>><?php >>$connection=mysql_connect("linux3","user1","user1password"); >>$db=mysql_select_db("maindata",$connection); >>$sql="SELECT name,contact,email,enabled,username FROM customer"; >>$result=mysql_query($sql); >>>>