>< %@ 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); >>